Access Query to Word Mail Merge in XP

D

David.

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.
 
D

David Lloyd

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

--
David 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.
 
D

David.

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.
 
D

David Lloyd

David:

It would be helpful to see the code you are using to better understand how
you are trying to accomplish this task.

--
David 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.
 
Top