Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multiple excel lines on one letter on mail merge.
Hi All,
My question is simple, probably has a simple answer. I have a list of customers who us money, now, i have all their details on excel so i did a mail merge but most customers owe more than one invoice, how do i list boith invoices on one letter rather than mail merge generating 2 letters for the same customer. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multiple excel lines on one letter on mail merge.
probably has a simple answer.
Unfortunately not...Word is not really designed to do this stuff. If you have Access you may be better off importing your data to Access and using its reporting facilities. Using fields, you can try starting with the example in the following KB article: http://support.microsoft.com/kb/211303 There are other ways to do it (e.g. using a DATABASE field to pick up multiple lines per customer, but that does have some problems, or generating your Word document from scratch using Word or Excel VBA) but I'd see how you get on with the approach described in the article. -- Peter Jamieson http://tips.pjmsn.me.uk " wrote in message oups.com... Hi All, My question is simple, probably has a simple answer. I have a list of customers who us money, now, i have all their details on excel so i did a mail merge but most customers owe more than one invoice, how do i list boith invoices on one letter rather than mail merge generating 2 letters for the same customer. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multiple excel lines on one letter on mail merge.
Sounds like you are trying to perform a "multiple items per condition (=key
field)" mailmerge which Word does not really have the ability to do: 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 http://support.microsoft.com/default...b;en-us;211303 or at: http://cornell.veplan.net/article.aspx?&a=3815 -- 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 " wrote in message oups.com... Hi All, My question is simple, probably has a simple answer. I have a list of customers who us money, now, i have all their details on excel so i did a mail merge but most customers owe more than one invoice, how do i list boith invoices on one letter rather than mail merge generating 2 letters for the same customer. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to delete multiple mail merge lines in tools dropdown | Microsoft Word Help | |||
Mail Merge multiple records on One Contract/Letter | Mailmerge | |||
Mail Merge letter with Excel Data incorporated | Mailmerge | |||
Mail merge option with multiple data source records in one letter. | Mailmerge | |||
How to do a mail merge with an Excel workbook that has multiple w. | Mailmerge |