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