View Single Post
 
Old 04-24-2012, 07:45 AM
tonywatsonmail tonywatsonmail is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Jun 2011
Posts: 10
tonywatsonmail is on a distinguished road
Unhappy Code to stop as "save as" if the mail merge has not been done

Hi Everyone,

I've got a bit of a problem, Hope someone can help me!

Ive created a Number of Word Documents as "Template" Letters and use Mailmerge to create the Actual Documents using Data from access,

This works perfectly to as you all know to create the document you just, open the template, got to mailmerge, "merge single record" and you have the document all nice and easy you then save the merged document to the relevent client.

the problem I have is some of the people in my office are so stupid they can even follow these simple instructions and just save the "template" Document unmerged! which you can imagine when you then email it the a customer they cant open it because its not merged and cant find the data.

can someone give me some code that I could use to stop them from saving the "Template" maybe with a message box saying "You have not merged document, please merge document before trying to save!"

any help would be greatly appreciated

Thanks

Tony
Reply With Quote