View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Ryan D Ryan D is offline
external usenet poster
 
Posts: 15
Default Skip Duplicate Records + Put all Records in One Document

I wish I knew how to edit, sorry. To solve the first problem, I just copy
and pasted my merge fields 80 times. I can get ALL the records to appear in
my document. Now, how do I get "Next Record" to skip buplicate names?

I currently have:

NAME
ADDRESS
CITY
STATE
ZIP
NEXT RECORD

NAME
ADDRESS
CITY
STATE
ZIP
NEXT RECORD

etc...

"Ryan D" wrote:

I'm drafting a letter. In the body, I need to dump ALL the name, address,
etc. fields from Excel into one letter. I.E. Is there a way to merge all
the data? Currently, each name (etc.) is appreaing in a seperate document.

Also, how do I skip repeat names?

Thans in advance.