Send active document as email, specifying recipient & subject

C

CeliaTechWriter

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
 

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

Top