Link to Office Word 2003

[Jack]

Hi
Just had my computer upgraded to XP pro with Access 2003 and Word 2003.
Is there a way of sending the results of a query to a Word mailmerge
document.
Is there a simple way of doing it or does one have to use ODBC, OLE, DDE or
whatever?

I tried sending the data from a query to word, used to work no problem with
the old Access and Word programs.

It seems to work when sending to Excel but not to Word 2003.
Am I missing some connectivity software or what. Where can I find step by
step instructions on how to link Access to Word 2003?

Somebody said something changing * to a % sign in the queries?

Can you please help?

Many thanks
J

 

[Sheila D]

Hi Jack

I had all sorts of problems linking parameter queries to Word mail merge in
2003 and found lots of info by looking in the Word support group. I now do
the final selection in Word 2003 rather than try to use them which is fine as
they are only for me but not so good if you have multi users. Select queries
are no problem - just select it as the source data and should be fine.

Hope this helps

Sheila

 

[Jack]

Thanks Sheila

Hi Jack

I had all sorts of problems linking parameter queries to Word mail merge in
2003 and found lots of info by looking in the Word support group. I now do
the final selection in Word 2003 rather than try to use them which is fine as
they are only for me but not so good if you have multi users. Select queries
are no problem - just select it as the source data and should be fine.

Hope this helps

Sheila

 

[lamar]

Is it possable to export data in a field to a word doc., such as names,
address,state?