I am trying to perform a mail merge in MS Word using data from an
Access query.

The query brings together 2 tables (tblCustomers and tblOrders) in a
one-to-many relationship. For example, John Smith has 2 orders, Mary Jo
has 3 orders, etc. I would like to create letters for these people
like:

###

Dear Mr. Smith:

According to my records, you have the following orders:

2/3/05 Car parts
4/5/05 Audio parts

Sincerely,

Me

###.

.... and so on for each customer.

Can MS Word's mail merge feature reproduce something like this? If so,
how?

Thank you.

Kurt

Word isn't very good at this kind of thing. You may be able to use one of
the approaches described on Cindy Meister's pages at

http://homepage.swissonline.ch/cindymeister/

- see Mailmerge FAQ, Special Merges, Multiple Items per condition.

If possible use an Access report.

Peter Jamieson

wrote in message
ups.com...
I am trying to perform a mail merge in MS Word using data from an
Access query.

The query brings together 2 tables (tblCustomers and tblOrders) in a
one-to-many relationship. For example, John Smith has 2 orders, Mary Jo
has 3 orders, etc. I would like to create letters for these people
like:

###

Dear Mr. Smith:

According to my records, you have the following orders:

2/3/05 Car parts
4/5/05 Audio parts

Sincerely,

Me

###.

... and so on for each customer.

Can MS Word's mail merge feature reproduce something like this? If so,
how?

Thank you.

Kurt

Cindy Meister's page had some good options, including a function to
concatenate the child records into a string. But then I found a
function from Duane Hookom's Library which is much simpler and
straightforward. For those interested:

Generic Function To Concatenate Child Records

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic%20Function%2 0To%20Concatenate%20Child%20Records'

OK, thanks for the feedback.

Peter Jamieson

wrote in message
oups.com...
Cindy Meister's page had some good options, including a function to
concatenate the child records into a string. But then I found a
function from Duane Hookom's Library which is much simpler and
straightforward. For those interested:

Generic Function To Concatenate Child Records

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic%20Function%2 0To%20Concatenate%20Child%20Records'