How can I send a document by email to a specific recipient?

G

Guest

I have a word user form. At the end of the form a dialogue box pops up to
save the document according to the value in one of the fields. Then a further
dialogue pops up with a button allowing the user to return the completed form
by email.
All this works great. However, I would like to specify my email address in
the macro behind the button so that the user does not have to enter it
manually.
This is the macro as it stands now:

Private Sub btnSendMail_Click()
' set option to have doc sent as attachment and not as text
Options.SendMailAttach = True
ActiveDocument.SendMail
End Sub

I have tried to implement routing slip but this made it very cumbersome and
not clear at all... What I am looking for is an additional property which
will allow me to define the destination email address.
Word 2003 on XP Pro SP2.

Many thanks for any assistance offered.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I send a document as attachment and fill in email address? 4
Access Automatically Send a notification email once a record is added 0
Email Macro that unlocks Document 1
How can do you FAX a Word document in Word 2007 64 bit mode? 1
send form by email 1
How do I route a word 2007 doc to sequential recipients? 1
Macro Button on Document to Email active document as an attachment 6
Recipient can modify my password protected word document 4

Top