Results 1 to 2 of 2

Thread: Word 2007 Mail Merge

  1. #1
    Join Date
    Jun 2009

    Word 2007 Mail Merge

    Hi All,

    I have an Excel spreadsheet that has all the info I need to merge into letters in Word. I'd like to be able to insert multiple lines based on a unique ID, for example:

    1 - 101 - Dave - football - 6/25/09
    2 - 101 - Dave - soccer - 6/21/09
    3 - 101 - Dave - baseball - 5/19/09
    4 - 102 - John - football - 6/25/09
    5 - 102 - John - volleyball - 6/25/09

    I'd like to have a merge with the name, which I can do. I'd like to then have a list of the sports 101 has played and the dates listed below in 1 letter. Is this possible? It would look like this:

    "Hi Dave,

    You've done the following:

    football - 6/25/09
    soccer - 6/21/09
    baseball - 5/19/09


  2. #2
    Join Date
    Feb 2008

    Re: Word 2007 Mail Merge

    Microsoft Office Word 2007
    On the Mailings tab, click Start Mail Merge, and then click Step by Step Mail Merge Wizard.

    • In the Mail Merge task pane, click Letters. This will allow you to send letters to a group of people and personalize the results of the letter that each person receives.
    • Click Next: Starting document.

    To use an existing data source, follow these steps:
    1. In the Mail Merge task pane, click Use an existing list.
    2. In the Use an existing list section, click Browse.
    3. In the Select Data Source dialog box, select the file that contains the variable information that you want to use, and then click Open.
    4. Click OK to return to the main document.
    5. Save the main document.
    6. When you save the main document at this point, you are also saving the data source and attaching the data source to the main document. Type the name that you want to give to your main document, and then click Save.

    For more info:

Similar Threads

  1. Mail Merge not working in Word 2010
    By Raja Ram in forum Windows Software
    Replies: 5
    Last Post: 19-05-2011, 11:20 AM
  2. How to use mail merge for Faxes in Word
    By Bankebihari in forum Windows Software
    Replies: 4
    Last Post: 28-07-2010, 12:42 PM
  3. How to use mail merge to create envelopes in Word?
    By - Empty Shell - in forum Windows Software
    Replies: 5
    Last Post: 17-03-2010, 01:07 AM
  4. Email mail merge from Word 2007
    By Carlee in forum Windows Software
    Replies: 3
    Last Post: 28-07-2009, 11:57 PM
  5. Mail merge from MS Word
    By Jaishree in forum Windows Software
    Replies: 2
    Last Post: 08-07-2009, 11:43 AM

Posting Permissions

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