Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Email Macro that unlocks Document
I have a macro that send the document to email as an attachment that works
fine. I also added another command that unlocks the document when it is being attached. What I would like to do is have the original document stay protected and only have the attached copy unprotected. Here is what I have so far, and it does work, but like I say I want the original document to stay protected. I am very new to this and learning as fast as I can. Thanks Mike Private Sub CommandButton1_Click() Options.SendMailAttach = True ActiveDocument.SendMail Unprotect Password:="shops05" End Sub |
#2
|
|||
|
|||
Hi ?B?TWlrZSBBbmRlcnNvbg==?=,
I have a macro that send the document to email as an attachment that works fine. I also added another command that unlocks the document when it is being attached. What I would like to do is have the original document stay protected and only have the attached copy unprotected. Here is what I have so far, and it does work, but like I say I want the original document to stay protected. I am very new to this and learning as fast as I can. My inclination would be to say: How about if you save the document, then unprotect and send it, and afterwards close the document without saving? Otherwise, you'll need an additional button to click on after you've sent your email, to reinstate protection. Private Sub CommandButton1_Click() Options.SendMailAttach = True ActiveDocument.SendMail Unprotect Password:="shops05" End Sub Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge with attachments | Mailmerge | |||
Getting email addresses out of a word document | Microsoft Word Help | |||
How do I email a mail merged document? | Mailmerge | |||
Word mail merged document by email as attached file. | Mailmerge | |||
Turning off Line Numbering Macro unformats my document! | Page Layout |