Hello all,

Apologies for posting this here but I don’t know which other thread is best to post in!

I have a document that is set out as a form to be in filled using form properties in word 2000
In the document is a check box that should, when selected by the user, email the document to a specific email address.

I created the macro to do this by recording my actions, however, I get an outlook new mail message with the document as an attachemt with no email address showing.

What I what to be able to do is have this document sent without user interaction and to the email address I have recorded in the macro.

If anyone can help I would be over the moon as this is driving me mad.

Here is the code the macro created:

Sub mailtofacilitieshelpdesk()
'
' mailtofacilitieshelpdesk Macro
' Macro recorded 15/09/2005 by John
'
    ActiveDocument.SendMail
End Sub

Regards

John

Hi,

What you could try is this:
-create a reference to the Microsoft Excel 10.0 Object Libary (Tools>References)

ActiveDocument.SendMail
Excel.Application.Sendkeys "[email protected]" , wait 'your email address
Excel.Application.Sendkeys "%S" ' alt S to send