What is the directory in mail merge?

A Directory Mail Merge allows you to use specified fields from a data source to create a list. For example, you may have a data source containing information pertaining to registration for a conference.

Can you use mail merge to create a directory?

A Directory Mail Merge allows you to use specified fields from a data source, like excel, to create a list or document. Rather than copy and paste the relevant columns from your data source, into Word, you can use a Directory merge to easily produce this list.

How do I merge mailing lists from excel to Word?

On your Word document, highlight the field you want to populate with the data from Excel. On the Mailings tab, choose the ‘Insert Merge Field’ button, a list of the column headers on your saved excel document will drop down (i.e. Company Name, etc.). Choose the appropriate field you want to merge and choose Insert.

How do I create a mail merge list from excel?

Create a new mail merge list

1. Go to File > New > Blank Document.
2. Choose Select Recipients > Type a New List.
3. In the New Address List dialog box type recipient information in each column as appropriate.
4. For each new record, select Add New.
5. If you need more columns, such as for an order number, follow these steps:

Can an Excel spreadsheet be used as the data source for a Word mail merge?

An essential step in a Word mail merge process is setting up and preparing a data source. You can use an existing Excel data source or build a new one by importing a tab-delimited (. txt) or comma-separated value (. csv) file.

Can you mail merge from Excel?

Insert a merge field You can insert one or more mail merge fields that pull the information from your spreadsheet into your document. Go to Mailings > Insert Merge Field. Add the field you want. Repeat steps 1 and 2 as needed.

Is mail merge possible in Excel?

Mail Merge is a handy feature that incorporates data from both Microsoft Word and Microsoft Excel and allows you to create multiple documents at once, such as letters, saving you the time and effort of retyping the same letter over and over.

How do I convert Excel to Word labels?

Connecting Your Excel Spreadsheet to Word To do so, go to File > Options > Advanced > General, and select the C*onfirm File Format Conversation* on Open option. This will automatically convert any Excel formatting into the proper Word formatting when you import mail merge labels from Excel.