Mailing word attachment

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Buzzmcduffie - 09 Dec 2003 15:18 GMT

I need a command button on my word template which will
automatically attach the template to an email, address it,
fill in the subject line and message.
I've gotten this far but need help with the email address,
subject line and message

Private Sub CommandButton1_Click()
Options.SendMailAttach = True
ActiveDocument.SendMail
End Sub

Thanks!!

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 11 Dec 2003 08:37 GMT

Hi Buzz,

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

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

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I need a command button on my word template which will
> automatically attach the template to an email, address it,
[quoted text clipped - 8 lines]
>
> Thanks!!

Reply to this Message