[4charity]

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!

[Peter Jamieson]

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!

[4charity]

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!