odbc reads all records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barry - 15 Dec 2003 19:51 GMT

At home, I set up a Word 2000 mail merge file that works very well
using odbc.
Here at work, I use Word 2002 and am trying to get that 'home' merge
file to work. After reading this group I know I have to select
Tools---->Options----> General---->Confirm Conversion at Open. When
the confirm dialogue comes up I choose odbc as my connectivity. I do
connect okay but in Word 2002 every time I do something, let's say in
the Edit Recipients option, all the records in the the database (about
6500) get read. My recollection from home is that that did not happen
when using odbc with Word 2000. Is there any way to prevent the
records being read using Word 2002?

Barry

Reply to this Message

Cindy M -WordMVP- - 16 Dec 2003 14:25 GMT

Hi Barry,

The problem is the Recipients dialog box. If you can avoid that, things
will work more like in Word 2000.

1. Use the toolbar to connect to the data, not the Wizard
2. Use the older "Mail merge..." button or Mail Merge Helper to get to
the Query Options (see the Word 2002 section on my website if you don't
know where to find these commands)

> At home, I set up a Word 2000 mail merge file that works very well
> using odbc.
[quoted text clipped - 7 lines]
> when using odbc with Word 2000. Is there any way to prevent the
> records being read using Word 2002?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)

Reply to this Message

Barry - 16 Dec 2003 18:41 GMT

> Hi Barry,
>
[quoted text clipped - 25 lines]
> This reply is posted in the Newsgroup; please post any follow question
> or reply in the newsgroup and not by e-mail :-)

Your suggestion(s) worked. Thank you.

Barry

Reply to this Message