Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Data sources you can use for a mail merge
 

You can use just about any type of data source (data source: A file that contains the information to be merged into a document. For example, the list of names and addresses you want to use in a mail merge. You must connect to the data source before you can use the information in it.) for a mail merge. Here are some examples.

ShowMicrosoft Outlook Contact List

You can retrieve contact information directly from your Outlook Contact List.

ShowMicrosoft Office Address List

You can create a simple Office Address List during the mail merge, and access it for later use. This is best for small, simple lists that you don't use frequently.

ShowOther database files

You can use:

You can access these sources or start the Data Connection Wizard by clicking New Source in the Select Data Source dialog box.

ShowDifferent type of electronic address book

You can use the following types of address books:

ShowMicrosoft Word data source or a header source

You can use a Word document as a data source. The document should contain a single table. The first row of the table must contain headings, and the other rows must contain the records you want to merge. You can also use a header source (header source: A document that contains the header row (or header record) to be used with the data source specified for a mail-merge main document.) as a data source.

Note  If you installed Microsoft Office (instead of installing Microsoft Word by itself), you can also use Microsoft Query to construct a query (query: A means of finding all the records stored in a data source that fit a set of criteria you name. Queries can contain operators, quotation marks, wildcard characters, and parentheses to help focus your search.) and retrieve the data you want from an external data source (external data source: A data source that contains the data a user wants to gain access to: for example, a Microsoft Excel list or a Microsoft Access database.).

© 2009 Microsoft Corporation. All rights reserved.