Mailmerge with an Access database?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

prismlight - 14 Jul 2005 02:03 GMT

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

Reply to this Message

Anne Troy - 14 Jul 2005 02:22 GMT

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

www.OfficeArticles.com

> Hi
> Im at step 3 - Select Recipients.
[quoted text clipped - 4 lines]
>
> thanks in advance

Reply to this Message

Doug Robbins - 14 Jul 2005 06:35 GMT

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.

Signature

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

> Hi
> Im at step 3 - Select Recipients.
[quoted text clipped - 4 lines]
>
> thanks in advance

Reply to this Message

prismlight - 14 Jul 2005 18:51 GMT

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

> Hi
> Im at step 3 - Select Recipients.
[quoted text clipped - 4 lines]
>
> thanks in advance

Reply to this Message

Peter Jamieson - 14 Jul 2005 22:14 GMT

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

> Thanks everyone,
>
[quoted text clipped - 17 lines]
>>
>> thanks in advance

Reply to this Message

Rate this thread: