Send active document as email, specifying recipient & subject

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CeliaTechWriter - 28 Sep 2006 21:18 GMT

I have a form. Links don't work with a protect file apparently, so I need to
write a macro to unprotect the doc, send it as am email attachment, and
protect it again.

The protection is no problem. Neither is opening an email dialog with the
file as an attachment. But the file name is the subject line, and I can't
find a way to set the subject line and pre-fill the Recipient email address.
It can't be difficult, but I'm going around and around the VB help and I
can't find it! The MailMerge functionality seems like could do it, but I
can't get it to work. Help!

Thanks, Celia

Reply to this Message

Doug Robbins - Word MVP - 01 Oct 2006 20:16 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 form. Links don't work with a protect file apparently, so I need
>to
[quoted text clipped - 10 lines]
>
> Thanks, Celia

Reply to this Message