Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-22-2011, 06:19 AM
DaveBF DaveBF is offline Need some help with building a mail merge document. Windows XP Need some help with building a mail merge document. Office 2010 32bit
Novice
Need some help with building a mail merge document.
 
Join Date: Sep 2011
Posts: 7
DaveBF is on a distinguished road
Default Need some help with building a mail merge document.


Hi,

I'm building a mail merge document which uses a SQL database. I want to be able to give the file to someone, so that when they open it, it will do the mail merge and give them the final document.
I set it up with a SQL datasource.
I also included a macro in the Normal file, which on Open, does a Finish & Merge, and closes the original document. This seems to work when I test it on my machine. I saved it as a macro-enabled Word document.

But when I give the file to someone else to run, there are 2 problems.
1. It asks for a datasource.
2. It cannot find my macro definition (the function I put in the Normal file).

Does the datasource get included in the docm file? Or is the datasource definition separate from the document?

Does the Normal file get included in the docm file, or is it always local to the current user?

Thanks.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need some help with building a mail merge document. Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
Need some help with building a mail merge document. Mail Merge :~( Peeps Mail Merge 1 05-31-2011 02:25 AM
Need some help with building a mail merge document. mail merge ericlch16 Mail Merge 3 04-30-2011 04:44 AM
delete blank pages from mail merge document blusea Word 0 12-17-2010 06:10 PM
Mail Merge hiteshkataria Mail Merge 4 11-06-2009 05:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:26 PM.


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