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
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