Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Nov 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    mail merge (97 sr1)

    Hi there

    I have been given a spreadsheet to mail merge with a word doc.

    The spreadsheet has duplicate records.

    How can I remove the duplicates before or during the merge?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: mail merge (97 sr1)

    Does this <post#=268203>post 268203</post#> answer your question?

    Steve

  3. #3
    Lounger
    Join Date
    Nov 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mail merge (97 sr1)

    Hi there

    thanks for the link.

    Yes it answers the question, but I do not know how to use the feature and the help is confuising.

    What is the criteria to eliminate duplicate customer names that would be in column A?

  4. #4
    Lounger
    Join Date
    Nov 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mail merge (97 sr1)

    When I do that I get the message that you can only copy filtered data to the active worksheet.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: mail merge (97 sr1)

    Highlight the range (including the headers)
    Data - filter - advanced filter

    In the "advanced filter" dialog
    Select the "copy to another location"
    Check the "unique records only"
    In the "copy to:" box list the cell you want to copy the "unique" (unduplicated) data set to.

    After copying the dataset, you can (if you want) delete the original data with the duplicates
    Steve

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: mail merge (97 sr1)

    Select an unused area of the current worksheet. You can always move it later.

    OR

    you can "filter-in-place", then COPY the "filtered data" and paste it onto another worksheet or in a another workbook.

    Steve

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mail merge (97 sr1)

    If you sort the records on the columns where the duplicates appear (e.g. LastName, FirstName), you can use the technique that HansV mentioned in <post#=268806>post 268806</post#>.
    Cheers,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •