Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Aug 2008
    Location
    Jerusalem, Israel
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    printing a recipient list in mail merge (word 2007)

    I am using Word 2007 with Vista. How do I print out the names, addresses, etc for the entries on my recipient list in my mail merge? Not to print letters, just to print out a list of the entries in the recipient list.

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 15 Times in 15 Posts

    Re: printing a recipient list in mail merge (word 2007)

    What is the data source of your mail merge? You may be able to open the data source in its own application and print it from there.
    If you prefer to use mail merge:
    - Activate the Mailings tab of the ribbon.
    - Click on Start Mail Merge and select Directory from the dropdown list.
    - Alternatively, select Step by Step Mail Merge Wizard, and select Directory in Step 1.
    - Proceed as usual with a mail merge.

  4. #3
    Star Lounger
    Join Date
    Aug 2008
    Location
    Jerusalem, Israel
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: printing a recipient list in mail merge (word 2007)

    That did it. Thanks.
    Maybe you know how I can combine two recipient lists into one?

  5. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 15 Times in 15 Posts

    Re: printing a recipient list in mail merge (word 2007)

    Mail merge itself does not have that capability, so you'll have to do it in the source application. What kind of recipient lists are you using? Word documents, Excel worksheets, Access tables, Outlook contacts, or ...?

  6. #5
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,773
    Thanks
    0
    Thanked 162 Times in 150 Posts

    Re: printing a recipient list in mail merge (word 2007)

    Hi dovid,

    If you're able to add a dummy last record to your datasource, you could extract a recipients list at the end of the mailmerge using a field in your main mailmerge document coded like:
    {IF{MERGEFIELD Recipient}= "Final" {REF Recipients} {IF{MERGESEQ}= 1 {SET Recipients {MERGEFIELD Recipient}} {SET Recipients "{REF Recipents}, {MERGEFIELD Recipient}"}}}
    In the above example, I've used a data field named 'Recipient' and assumed a dummy last record with a "recipient" named 'Final'.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  7. #6
    Star Lounger
    Join Date
    Aug 2008
    Location
    Jerusalem, Israel
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: printing a recipient list in mail merge (word 2007)

    I'm not very computer literate so I can't answer your question. I did a mail merge and chose "create a new list" and used the dialog box that appears to enter my data.

  8. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 15 Times in 15 Posts

    Re: printing a recipient list in mail merge (word 2007)

    That means that it's probably an Access database. You should be able to see the file name in step 3 of the mail merge wizard. The database is probably stored in the (My) DataSources folder in (My) Documents.
    Try to locate and open the database, you should then be able to print the table named Office_Address_List.

  9. #8
    Star Lounger
    Join Date
    Aug 2008
    Location
    Jerusalem, Israel
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: printing a recipient list in mail merge (word 2007)

    thanks for the help!

Posting Permissions

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