Macro for e-mailing a Word file as an attachment

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jon.mullich@wamu.net - 21 Apr 2006 15:00 GMT

I have a macro that attached the file as an e-mail. How do I edit the macro
to pre-fill the e-mail recipient and subject line on the e-mail? And can it
be edited to send the e-mail within the macro?

What is does now is open the Outlook e-mail window with the file attached,
with no recipient filled in and the subject the name of the file. What I want
it to do is have the recipient and subject pre-filled and automatically send
the e-mail attachment without any additional actions.

I'm on Office 2003. Here's my current macro:

Sub attach()
'
' attach Macro
' Macro recorded 04/20/2006 by Jon Mullich
'
ActiveDocument.SendMail
End Sub

Reply to this Message

Doug Robbins - Word MVP - 26 Apr 2006 19:42 GMT

See the article "How to send an email from Word using VBA" at:

http://www.word.mvps.org/FAQs/InterDev/SendMail.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a macro that attached the file as an e-mail. How do I edit the macro
> to pre-fill the e-mail recipient and subject line on the e-mail? And can
[quoted text clipped - 18 lines]
> ActiveDocument.SendMail
> End Sub

Reply to this Message