Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links

Word 2007 Mail Merge

Windows Software

Thread Tools Search this Thread
Old 30-06-2009
Join Date: Jun 2009
Posts: 1
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


Reply With Quote
Old 01-07-2009
Join Date: Feb 2008
Posts: 180
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: http://support.microsoft.com/kb/294683
Reply With Quote

  TechArena Community > Software > Windows Software
Tags: , ,

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

All times are GMT +5.5. The time now is 08:27 PM.