"Creating Mail Merge Recipients List"


The mail merge recipients list (or data source) is one of the fundamental elements that are needed when doing the mail merge.

The data source (recipients list) contains the data that will change with each record, such as names, identification numbers, address, etc. You have two choices:

  • create a new data source
  • use a pre-existing source (such as Contacts from Microsoft Outlook)

You also can choose which entries to be included in your data source without having to open it, change the appropriate entries, and then save the changes. That's means you can simply add or delete data source entries and fields.


To create a New Data Source

  • From the Mailings tab, in the Start Mail Merge group, click on Start Mail Merge icon and from the menu appear, select the desired options to create your mail merge. For example: Select Letters.
  • Click the Select Recipients icon and select Type New ListÂ… from the list appears.
  • Word 2007 mail merge new address list

  • From the New Address List dialog box displayed, click the Customize Columns button.
  • Word 2007 mail merge customize address list

  • From the Customize Address List dialog box displayed, you can add, delete, rename, move up or down the existing field names. Click OK when finish.
  • Click in a field to add information. In the appropriate fields, type the desired information for the data source.
  • You can add the entries by clicking on the New Entry button and add more entries.
  • When all entries are complete, click OK.
  • From the Save Address List dialog box displayed, using the Save in drop-down list or Favorite Links section, navigate to the desired save location (such as desktop).
  • In the File name: text box, type the desired name for your address list (such as My Address Lists).
  • Click the Save button.


Note: The default save location is My Data Sources and the file extension is .mdb (Microsoft Office Address Lists).


To access or edit the recipient lists

  • Open the main document.
  • From the Mailings tab, in the Start Mail Merge group, click on Edit Recipient List icon.
  • Word 2007 mail merge recipient lists

  • From the Mail Merge Recipients dialog box displayed, select the desired entry by clicking on the Data sources: section.
  • Click the Edit button.
  • From the Edit Data Source dialog box displayed, edit the desired entry and click the OK button when finish.
  • Click Yes if any message pop-up.
  • Click OK.


Tip: Before creating the mail merge recipients list (data source), do plan out the data you want to include. Although you can edit fields after creating your data source, it is most efficient to know which fields will be included in the first place.


Related Articles:

Creating Merged Letters in Word 2007

Creating Merged Envelopes in Word 2007

Creating Mailing Labels in Word 2007

Creating an E-mail Merge in Word 2007

2007 Save and Save As Features



Can't find what you're looking for? Try Google Search!

Custom Search


Back to Top

You're viewing the Word 2007 mail merge recipients info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.