Mailmerge with an Access database?

[prismlight]

Hi
Im at step 3 - Select Recipients.
Use an existing list-Browse.
It will only allow me to pick ONE file at a time.

Is there an easy way to select more then one file at a time?

thanks in advance

 

[Anne Troy]

Isn't there a Select All button at the bottom of the window?
*******************
~Anne Troy

www.OfficeArticles.com

 

[Doug Robbins]

Mailmerge only functions with a single, flat datasource. You cannot select
multiple files or tables within a database. If the data that you want is in
multiple tables, then you will need to define a Select or Union Query in
Access to combine those tables and then use that Query as the datasource for
your mailmerge.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[prismlight]

Thanks everyone,

So now I understand that I can NOT select more then one file or table within
Access and that I need to use a Union (or select) Query to combine records.

My only question is how to do a Union Query that will delete duplicates?

thanks

ps. maybe this should be posted in Query section? sorry im new to this

 

[Peter Jamieson]

UNION removes duplicates by default.

What you may find is that you will not be able to use the default connection
method in Word 2002/2003 (OLEDB) to connect to a UNION query. You may be
able to work around that by
a. wrapping the UNION query up in yet another query (I don't know for sure)
b. changing the connection method (check Word Tools|Options|General|Confirm
conversions at open, and choose ODBC or DDE when prompted. There are side
effects.

Peter Jamieson