|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 11th, 2009, 06:58 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help With Form Ltr Mail Merge With Multiple Input Records Per Page
I am using MS Word 2007 and Excel 2007. My Excel file source contains the
following fields: LAST NAME, FIRST NAME, ADDRESS 1, ADDRESS2, DATE, AMT, PROJECT. I have the same name listed multiples times, depending on the number of projects they have contributed to, i.e.: Jones Mary some street some apt. 09/09/09 $10.00 Missions Jones Mary 10/01/09 $ 5.00 Thanksgiving Baskets Smith Sue some street some apt. 07/01/09 $20.00 Christmas Dodge Joe some street 05/02/08 $ 5.00 Global Missions Dodge Joe 06/05/09 $ 1.00 Missions Dodge Joe 08/02/09 $ 4.00 Some Project My goal is to write one letter to each of the people in my Excel list itemizing their contributions. So, Mary Jones would have 2 items in her list, Sue Smith would have 1 item in her list, and Joe Dodge would have 3 letters in his list. I am choosing "Directory" in the "Start Mail Merge"; and have connected successfully to my Excel spreadsheet. I learned that I have to use ctrl + F9 to enter my brackets, but for the life of me I cannot get the logic right. Can you please help me. I'm stumped. Bill 
|
|
#2
September 11th, 2009, 08:37 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Help With Form Ltr Mail Merge With Multiple Input Records PerPage
The solution Macropod just mentioned is probably also applicable to your
problem: ------------------ To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. ------------------ - Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv Sheila wrote: I am using MS Word 2007 and Excel 2007. My Excel file source contains the following fields: LAST NAME, FIRST NAME, ADDRESS 1, ADDRESS2, DATE, AMT, PROJECT. I have the same name listed multiples times, depending on the number of projects they have contributed to, i.e.: Jones Mary some street some apt. 09/09/09 $10.00 Missions Jones Mary 10/01/09 $ 5.00 Thanksgiving Baskets Smith Sue some street some apt. 07/01/09 $20.00 Christmas Dodge Joe some street 05/02/08 $ 5.00 Global Missions Dodge Joe 06/05/09 $ 1.00 Missions Dodge Joe 08/02/09 $ 4.00 Some Project My goal is to write one letter to each of the people in my Excel list itemizing their contributions. So, Mary Jones would have 2 items in her list, Sue Smith would have 1 item in her list, and Joe Dodge would have 3 letters in his list. I am choosing "Directory" in the "Start Mail Merge"; and have connected successfully to my Excel spreadsheet. I learned that I have to use ctrl + F9 to enter my brackets, but for the life of me I cannot get the logic right. Can you please help me. I'm stumped. Bill
|
|
#3
September 11th, 2009, 10:48 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Help With Form Ltr Mail Merge With Multiple Input Records Per
Peter,
Thank you so much. We'll take a look and get back to you if we still have problems with hour merge. Really appreciate your timely response and info. Sheila "Peter Jamieson" wrote: The solution Macropod just mentioned is probably also applicable to your problem: ------------------ To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. ------------------ - Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv Sheila wrote: I am using MS Word 2007 and Excel 2007. My Excel file source contains the following fields: LAST NAME, FIRST NAME, ADDRESS 1, ADDRESS2, DATE, AMT, PROJECT. I have the same name listed multiples times, depending on the number of projects they have contributed to, i.e.: Jones Mary some street some apt. 09/09/09 $10.00 Missions Jones Mary 10/01/09 $ 5.00 Thanksgiving Baskets Smith Sue some street some apt. 07/01/09 $20.00 Christmas Dodge Joe some street 05/02/08 $ 5.00 Global Missions Dodge Joe 06/05/09 $ 1.00 Missions Dodge Joe 08/02/09 $ 4.00 Some Project My goal is to write one letter to each of the people in my Excel list itemizing their contributions. So, Mary Jones would have 2 items in her list, Sue Smith would have 1 item in her list, and Joe Dodge would have 3 letters in his list. I am choosing "Directory" in the "Start Mail Merge"; and have connected successfully to my Excel spreadsheet. I learned that I have to use ctrl + F9 to enter my brackets, but for the life of me I cannot get the logic right. Can you please help me. I'm stumped. Bill
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
