If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hide Template on Copletion of Merge
I am using Access to populate a document using MailMerge in Word. My letter
comes out fine. Once the end-user reviews the letter and saves it and closes it, the template appears on the screen and asks the user if s/he would like to save changes to it. I would like for the template to not appear at all, as I do not want the endusers to have the ability to make changes to it! Is there some code I can attach to the template to do this? Also, I am pretty new to VB, so please be as descriptive as possible Thanks! |
#2
|
|||
|
|||
Hide Template on Copletion of Merge
See the recent conversation titled "Mail Merge Automation Code problem"
for one bit of code that seems to have done the trick for at least one person. Peter Jamieson http://tips.pjmsn.me.uk 4charity wrote: I am using Access to populate a document using MailMerge in Word. My letter comes out fine. Once the end-user reviews the letter and saves it and closes it, the template appears on the screen and asks the user if s/he would like to save changes to it. I would like for the template to not appear at all, as I do not want the endusers to have the ability to make changes to it! Is there some code I can attach to the template to do this? Also, I am pretty new to VB, so please be as descriptive as possible Thanks! |
#3
|
|||
|
|||
Hide Template on Copletion of Merge
Thanks, Peter.
I don't know how I missed that post. Actually, right before me End If statement I added in: 'close the orginal file objWord.Close wdDoNotSaveChanges This worked well too. Thanks for your help! "Peter Jamieson" wrote: See the recent conversation titled "Mail Merge Automation Code problem" for one bit of code that seems to have done the trick for at least one person. Peter Jamieson http://tips.pjmsn.me.uk 4charity wrote: I am using Access to populate a document using MailMerge in Word. My letter comes out fine. Once the end-user reviews the letter and saves it and closes it, the template appears on the screen and asks the user if s/he would like to save changes to it. I would like for the template to not appear at all, as I do not want the endusers to have the ability to make changes to it! Is there some code I can attach to the template to do this? Also, I am pretty new to VB, so please be as descriptive as possible Thanks! |
Thread Tools | |
Display Modes | |
|
|