Hi Dale,
> I am having trouble merging a letter in Word with a
> mailing list I have as a select query in Access. I cannot
> connect to the data source. Apparently, I cannot connect
> via DDE. How do I connect using another method? Does ODBC
> work? How do I set that up?
to give you detailed instructions we need to know the
version of Word you're using? (And Access, as well, please)
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)
Dale - 13 Feb 2004 22:47 GMT
Sorry, I'm using office XP.
The DB is in an access 2002 format and this is driving me
crazy now. Any help is greatly appreciated.
D.
>-----Original Message-----
>Hi Dale,
[quoted text clipped - 19 lines]
>
>.
Cindy M -WordMVP- - 19 Feb 2004 16:10 GMT
Hi Dale,
> office XP.
>
[quoted text clipped - 5 lines]
> via DDE. How do I connect using another method? Does ODBC
> work? How do I set that up?
Right, DDE won't work between different Office versions.
You can use ODBC. Activate "Confirm conversions on open" in
Tools/Options/General, then connect to the Access database.
In order to see the list of queries with the tables, click
"Options" and activate "Views".
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)