Re: Skip Duplicate Records + Put all Records in One Document

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Use a catalog (or in Word XP and later it is called "Directory") type
mailmerge main document in which you have nothing but

<<NAME>>
<<ADDRESS>>
<<CITY>>
<<STATE>>
<<ZIP>>

Then execute that merge to a new document and to that document add any other
text that you want.

You will find information on a method of removing duplicates in the article
"Finding and replacing characters using wildcards" at:

http://www.word.mvps.org/FAQs/General/UsingWildcards.htm


--
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

"Ryan D" <RyanD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8C7E281F-7263-42DA-8E2E-B0E3195A45B3@xxxxxxxxxxxxxxxx
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.


.

Relevant Pages

  • Re: data from access to word
    ... Use a catalog type ... mailmerge main document to which you attach your table in Access as the data ... services on a paid consulting basis. ...
    (microsoft.public.word.docmanagement)
  • Re: Printing list of recipients?
    ... One way to do it is to set up a catalog type ... mailmerge with the merge fields in the cells of a single row table in the ... directly to me will only be answered on a paid consulting basis. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: How can I create a table of merged data? eg row for each entry
    ... Use a catalog ... mailmerge main document in which you have just a one row table with the ... each record in the data source. ... services on a paid consulting basis. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Creating a catalog...help with pagination
    ... You need to use a catalog ... mailmerge main document. ... services on a paid consulting basis. ... >directory) using info from an Access Database. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mail Merge VBA problem in Word/Access 2003
    ... Note The MailMerge object is available regardless of whether the specified ... with an attached data source. ... > I'm not sure what your point is because this is actual VBA ... > code from an Access 2000 function which DOES execute a ...
    (microsoft.public.word.mailmerge.fields)