How do I Mail merge filtered records?
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: How do I Mail merge filtered records?

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    How do I Mail merge filtered records? Each time I try to meger a subset from a file, the whole file merges.

    Thanks Charles

  2. #2
    Guest

    Default

    Charles

    Perhaps, I don't have any clever answers for you but a few options that would work. You can save the filtered records into a new excel file and link this to your merge document. Alternatively, you can create another column in your spreadsheet, Type a "Y" in the first row against your first filtered record and then drag then autofill the rest of the filtered records. You can then filter these records out using the query option in the word mail merge wizard to select everything with a "Y" in your new column.

    HTH

    Matt

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have just done a similar thing to what you describe. I used Autofilter to find the records I wanted, then I highlighted and copied them to a new worksheet with the same headings etc. (the new worksheet must be the first one in the workbook), then merged them in to Word.

    It worked for me, hope this helps.

  4. #4
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    You could also use advanced filter to filter to a new location, but why not use Word's Mail Merge Criteria options to filter for you? You can set the filter options each time you run the merge without having to prefilter in Excel.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com