Hi Everyone
Thanks for taking the time to assist me if you can.

I am fairly new to mail merging & Office.

I have created a mail merge email in word 2003 whose source is a query from
a database in Access 2000/2003 and it worked successfully. However, there are
multiple records for each recipient and rather that create a seperate email
for each record, can I create one email with all the records from the
database that relate to that recipient and how do I do it.

If anyone can help me could they tell me in failrly simple terms as I have a
very limited understanding of Macros & programming (and I mean very limited!).

Thanks in anticipation

Stretch

Word does not really have the ability to perform a "multiple items per
condition (=key field)" mailmerge.

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic

Or take a look at the following Knowledge Base Article

How to Work Around Duplicate Names in Mail Merge Data

http://support.microsoft.com/default...b;en-us;302665


--
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

"Stretch" wrote in message
...
Hi Everyone
Thanks for taking the time to assist me if you can.

I am fairly new to mail merging & Office.

I have created a mail merge email in word 2003 whose source is a query
from
a database in Access 2000/2003 and it worked successfully. However, there
are
multiple records for each recipient and rather that create a seperate
email
for each record, can I create one email with all the records from the
database that relate to that recipient and how do I do it.

If anyone can help me could they tell me in failrly simple terms as I have
a
very limited understanding of Macros & programming (and I mean very
limited!).

Thanks in anticipation

Stretch