Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-24-2012, 07:45 AM
tonywatsonmail tonywatsonmail is offline Code to stop as "save as" if the mail merge has not been done Windows 7 32bit Code to stop as "save as" if the mail merge has not been done Office 2007
Novice
Code to stop as "save as" if the mail merge has not been done
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
hit okay to "Merge to E-mail" nothing happened mubi_masti Outlook 0 10-21-2011 03:06 PM
Code to stop as "save as" if the mail merge has not been done How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM
Can I stop the right click "move here" feature? BillAnderson PowerPoint 0 04-16-2011 02:42 PM
How to stop "replace"'ing new words (in desperate need of advice) bme081 Word 6 11-02-2009 05:57 AM
VBA Code for making "mailings" tab active jandrade15 Mail Merge 0 08-01-2009 09:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft