To use Mail Merge:
- Open an existing Word document, or create a new one.
- From the Mailings tab, click the Start Mail Merge command and select Step by Step Mail Merge Wizard from the drop-down menu. Opening the Mail Merge Wizard.
Contents
How do I do a mail merge from Excel to Word 2013?
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.
- Choose File > Save.
What is the use of mail merge feature of Word 2013?
Mail merge is a tool which allows you to create form letters, mailing labels and envelopes by linking a main document to a data source. It is the process of combining a list of data with a template. Data Source – a file that contains the information to be merged into a document.
How do I turn on mail merge in Word?
Set up and Choose Document Type
Click the Mailings tab. Click the Start Mail Merge button. Select Step-by-Step Mail Merge Wizard. The Mail Merge pane appears on the right, ready to walk you through the mail merge.
What are the steps in mail merge?
The mail merging process generally requires the following steps:
- Creating a Main Document and the Template.
- Creating a Data Source.
- Defining the Merge Fields in the main document.
- Merging the Data with the main document.
- Saving/Exporting.
How do I import data from Excel to Word?
Inserting linked Excel data into a Word table
- Open the Excel source workbook.
- Select the data you want to place in the Word file.
- Press Ctrl + C or right-click and choose Copy from the drop-down menu.
- Open the Word destination document.
- Position the insertion point where you want the linked Excel data to appear.
How do you insert a mail merge field in Word?
Add individual merge fields
- Click or tap where you want the merge field.
- Choose the down-arrow under Insert Merge Field, and select a field.
- If you don’t see your field name in the list, choose Insert Merge Field.
- Choose Database Fields to see the list of fields that are in your data source.
- Choose Insert.
What are the three basic steps of mail merge?
There are three documents that are involved in the mail merge process: the main document, the data source, and the merged document.
Go to the Mailings tab. Click on Start Mail Merge Button and select the Step by Step Mail Merge Wizard from the drop down menu. A Mail Merge window should show up on the right.
How do I send a mail merge to multiple recipients?
There are two ways to send an email to more than one person in mail merge.
- Use the dynamic CC and BCC option and include the other recipients in the same message but in the CC/BCC fields.
- Add multiple email addresses in the Email Address column, separated with commas.
Can you merge an Excel file into a Word document?
Merge Word and Excel Documents
Once your spreadsheet is ready, open a new document in Word. Click on the Mailings tab and select Start Mail Merge and decide whether you want to create labels, letters, envelopes, emails or a directory. Select.
How do I link an Excel spreadsheet to a Word document?
The process of linking an Excel workbook to a Word document is straightforward. Simply copy a range from Excel. Then, in Word click Home -> Paste (small arrow). There are various options, as default we can click the icons for Paste Link and keep formatting or Paste Link and merge formatting.
How do you update a mail merge in Word?
Press [Alt] + F9 again. Position the cursor anywhere in this field and press the [F9] function key to update it. Or, right-click the field and choose Update Field. Preview the results to confirm the merge field displays with the formatting you want to see in the document for each of the mail merge records.
How do I do a mail merge with existing letters?
To perform a Letter mail merge in Microsoft Word
- In Word, choose File > New > Blank Document.
- On the Mailings tab, in the Start Mail Merge group, choose Start Mail Merge > Letters.
- Choose Select Recipients then Use an Existing List.
- Type the date and any other information you want at the top of the letter.
Open the document in Microsoft Word, and click on the Mailings tab.
- Click Select Recipients and go to “Use Existing List”
- Use the dialog box to navigate to and open the data spreadsheet.
- Select the appropriate table in the text dialog box.
- Select Finish and Merge.
- Go to Send E-Mail Messages.
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.