View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Multiple records mail merge - Another Question

Hi mom2dramaqeen,

The process is fully explained in my my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at:
http://www.wopr.com/index.php?showto...#entry731 107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial (especially the Introduction) before trying to use the mailmerge document included with it.

--
Cheers
macropod
[MVP - Microsoft Word]


"mom2dramaqeen" wrote in message
...
I've read the other post on this and I'm still lost.

I have a file sorted by a "key" code that I want to send an email mail merge
and have all "rows" from my data source that have this same "key" on that one
email, before the next email is made.

I've read the articles posted and I'm completely confused. I don't know how
in my document to mark my "key" field as a the key. I don't understand how
to or where at in my main document to do this.

Can someone help me and be more specific.

here is an example of what I'm working with:
Key Fname Lname Salary
001-090 Joe Smith 20,000
001-090 Suzie Smith 15,000
001-091 Bob James 20,000
002-090 Jan Jones 20,000

This data is in excel, I know how to create a normal main document and
connect to my data source. My data source is sorted by the key. I want my
document to have a letter type formate containing generic informaiton with a
table of the people who have the problem. So for example 001-090 should have
two rows in the table One for Joe and then another line for Suzie, but
001-091 would only have one.

Please help.