Home |
Search |
Today's Posts |
#1
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple records mail merge - Another Question | Mailmerge | |||
Mail Merge Multiple Records | Mailmerge | |||
Merge Multiple Records from Excel into Word Mail Merge | Mailmerge | |||
Multiple Records Mail Merge | Microsoft Word Help | |||
Mail Merge - Multiple Address Records | Mailmerge |