Query to Word link 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

 

[[MVP] S.Clark]

% is the wildcard operator for SQL Server.

Try the office links button for Word.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting