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

Thanks."

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: http://support.microsoft.com/kb/294683