Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Sheila Sheila is offline
external usenet poster
 
Posts: 31
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple records mail merge - Another Question mom2dramaqeen Mailmerge 10 April 4th 09 12:36 AM
Mail Merge Multiple Records Peter Hibbs[_2_] Mailmerge 5 February 16th 09 04:43 PM
Merge Multiple Records from Excel into Word Mail Merge Jim[_6_] Mailmerge 1 January 8th 09 10:08 PM
Multiple Records Mail Merge yuckster Microsoft Word Help 1 November 26th 05 07:08 AM
Mail Merge - Multiple Address Records paldba Mailmerge 1 August 1st 05 07:41 PM


All times are GMT +1. The time now is 02:00 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"