Hi Chris,

Most people have no problem using the older technology (the MM Helper) with
Excel or Access. There are, however, traditionally problems between Word and
Excel using the older technology (DDE connection instead of ODBC or OLEDB) if
either the Word document or the Excel workbook is slightly damaged. (The
reasoning behind most of my questions) My guess would be that this is the case,
in this particular instance.

I don't have exact answers to your questions,
but I have more information (which ends up being even more confusing). I
walked through the mail merge wizard with some files she sent me, and the
query worked fine for me (it's basically a sales report "form letter" in
which we were querying for a specific sales district). When I mentioned
this to my co-worker, she tried the wizard and it also worked -- previously
she was using the mail merge helper (which she happens to prefer using). So
I tried the mail merge helper (after I found it buried in the toolbar
customizations -- I guess there may be a reason it's not easy to find :-)),
and I get the same erroneous results that she was getting. Could the helper
possibly be broken?


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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 :-)