Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
List records from the many side of a one-to-many
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
List records from the many side of a one-to-many
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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
List records from the many side of a one-to-many
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' |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
List records from the many side of a one-to-many
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' |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a template with a permanent list along left side of page | Page Layout | |||
Mail Merge does not include all records from list or Access table | Mailmerge | |||
Mail Merge does not include all records from list or Access table | Mailmerge | |||
how display list of files in two folders side by side | Microsoft Word Help | |||
List View with multiple records | Mailmerge |