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


Reply
 
Thread Tools Search this Thread
  #1  
Old 30-06-2009
Member
 
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

Thanks."

Reply With Quote
  #2  
Old 01-07-2009
Member
 
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
Reply

  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 11:20 AM
How to use mail merge for Faxes in Word Bankebihari Windows Software 4 28-07-2010 12:42 PM
How to use mail merge to create envelopes in Word? - Empty Shell - Windows Software 5 17-03-2010 01:07 AM
Email mail merge from Word 2007 Carlee Windows Software 3 28-07-2009 11:57 PM
Mail merge from MS Word Jaishree Windows Software 2 08-07-2009 11:43 AM


All times are GMT +5.5. The time now is 12:49 PM.