Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mailmerge with an Access database?
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 |
#2
|
|||
|
|||
Isn't there a Select All button at the bottom of the window?
******************* ~Anne Troy www.OfficeArticles.com "prismlight" wrote in message ... 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 |
#3
|
|||
|
|||
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" wrote in message ... 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 |
#4
|
|||
|
|||
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 "prismlight" wrote: 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 |
#5
|
|||
|
|||
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 "prismlight" wrote in message ... 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 "prismlight" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use access query computed fields in Word mailmerge | Mailmerge | |||
How to insert only selected fields from Access database in Word? | Microsoft Word Help | |||
MailMerge Word 2003 to Access 2000 query blank data | Mailmerge | |||
Mailmerge - Catalog - Access Database with subform | Mailmerge | |||
Mailmerge data source in an Access database will not open | Mailmerge |