View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Dynamic number of records for merge...

See fellow MVP Macropod's "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 as you must get the mail merge main document set up exactly as
required.



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"codwilco" wrote in message
...
I have an excel spreadsheet something like the following:

1 Person1 25.00 Address1
1 Person1 49.00 Address1
2 Person2 120 Address2
3 Person3 50 Address3
3 Person3 48 Address3
3 Person3 499 Address3

I need one letter for each person with the amounts listed multiple times
on
the document. So, I need a record change within the document for each
value
and a new document for each record number change.

I cannot figure out how to do this. Any suggestions would be appreciated.

Dave