Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 09-22-2011, 06:53 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 one problem solved

I solved the 2nd problem by putting the code to do Finish/Merge directly into the document instead of into Normal.dot.

So now, how do I include the sql datasource definition into the docm file?
Reply With Quote
Reply

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 11:38 AM.


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