 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / September 2005Access Query to Word Mail Merge in XP
I have some apps created in Access97 VBA, converted to Access 2000, and now they need to be moved to XP. These databases are secured using Access security. They worked great in 97-2000, but there is one feature that breaks in XP, the Mail Merge. I can get the queries to run in Access and then Word opens, but it says that it can't open the data source. By modifying the Tools>Options>General>Confirm on opening setting in Word 2002, I get further. When it runs, Word opens up, but doesn't know what data source and table it should use. I can manually merge to that database from Word. Enabling the confirm on open setting allowed the use of a secured database as a merge data source. David: The following KB articles may be useful, depending on your circumstances. http://support.microsoft.com/default.aspx?scid=kb;en-us;320476 http://support.microsoft.com/default.aspx?scid=kb;en-us;888697 http://support.microsoft.com/default.aspx?scid=kb;en-us;833064  SignatureDavid Lloyd MCSD .NET http://LemingtonConsulting.com This response is supplied "as is" without any representations or warranties. I have some apps created in Access97 VBA, converted to Access 2000, and now they need to be moved to XP. These databases are secured using Access security. They worked great in 97-2000, but there is one feature that breaks in XP, the Mail Merge. I can get the queries to run in Access and then Word opens, but it says that it can't open the data source. By modifying the Tools>Options>General>Confirm on opening setting in Word 2002, I get further. When it runs, Word opens up, but doesn't know what data source and table it should use. I can manually merge to that database from Word. Enabling the confirm on open setting allowed the use of a secured database as a merge data source. Thanks for the response. The first article was somewhat useful, but it applies only when you are iniating the merge from Word. I would like to restore the original functionality where the merge is iniated from Access and the data source name is passed to Word so that the user is presented with the list of possible merge fields when Word opens up. David: It would be helpful to see the code you are using to better understand how you are trying to accomplish this task. SignatureDavid Lloyd MCSD .NET http://LemingtonConsulting.com This response is supplied "as is" without any representations or warranties. Thanks for the response. The first article was somewhat useful, but it applies only when you are iniating the merge from Word. I would like to restore the original functionality where the merge is iniated from Access and the data source name is passed to Word so that the user is presented with the list of possible merge fields when Word opens up. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.