Last Updated on
With a mail merge, you can quickly pull together information for mass mailings, combining form letters and emails in Word with data stored in Excel. In this guide, we’ll cover how you can mail merge from Excel.
How To Do A Mail Merge From Excel
Today's best modem deals!
ARRIS SURFboard SBG7600AC2 DOCSIS 3.0 Cable Modem
Prepare For The Spreadsheet
Before you begin, you want to ensure that everything in your Excel spreadsheet is prepared for the mail merge.
All the data required for the merge should be provided on the first sheet of your Excel spreadsheet.
Format The Spreadsheet
The spreadsheet must be formatted with one row for each intended recipient.
Check that the column names in the spreadsheet and the field names you wish to insert match.
Make sure that data entries in the spreadsheet are correctly formatted, so that their values can be properly read.
Prepare For The Mail Merge
Save the Excel spreadsheet to your local device, if it isn’t saved there already.
Read through the spreadsheet to correct or add any necessary information before you begin the merge.
Begin The Mail Merge From Excel To Word
With your information prepared and checked, you can begin the mail merge. The process is suitable for both mail and email messages.
Prepare Your Word Document For Merging
Open a Word document.
Select the Mailings tab, and then select the Start Mail Merge group. A drop-down menu will appear. Select the type of mail merge you wish to run, such as Letters, or E-mail Messages.
Connect To Your Excel Spreadsheet
On the Mailings tab, click on Select recipients. From the drop-down menu, select Use an Existing List.
A dialog box will appear, allowing you to connect your Excel spreadsheet to your Word document. Find your chosen Excel file and select Open, then find your chosen target sheet and select Ok.
Choose The Recipients Of The Mail Merge
On the Mailings tab, click Edit Recipients List. This will allow you to refine the recipients list, and remove anyone not in the intended audience.
Mail Merge Recipients dialog box will appear. This will allow you to check or uncheck the recipients of the mail merge.
Sort, filter, and validate the recipient’s email using the Refine recipient list option in the same dialog box.
Write Your Letter
Create your letter in your Word document, or copy a pre-written message from another document.
Add Your Merge Fields
In the Mailings tab, select Address Block. A dialog box will appear. Select the settings and options that work for you, using the Preview section to check the data is correct.
In the Mailings tab, select Greeting Line. Another dialog box will appear, similar to the Address Block, for you to select your chosen greeting. The Greeting Line and Address Line will appear as placeholders.
Other merge fields can be added using the Insert Merge Field drop-down menu. Insert your chosen field within the text.
Preview Your Mail Merge
Select Preview Results on the Mailing tab, to check the details have merged correctly. Use the arrow keys to navigate across the recipients.
Finish Your Mail Merge
To finish, select the Finish & Merge button on the Mailings tab. From here, you can print or email the letter. Alternatively, you can edit individual documents from the same button.
Save For Future Uses
Save your mail merge document by clicking the Save button. `
The mail merge Word document will now stay connected to the Excel data source. Next time you have a bulk message to send out, you can use the same document.
When you open the mail merge, Word will prompt you to stay connected. Click Yes on the dialog box.
A mail merge from Excel can help you to accurately place data into form letters. By using this method, you can send personalized mail with greater ease.
Be sure to check the information and headings in the Excel form are correct before merging, or you will encounter errors.
However, the preview button can be used to ensure everything is accurate, and that the data has been merged correctly.