Write the body of your letter in the Word document. Select the appropriate one (in this case, a Letter mail merge)ĥ. In the drop-down menu, you’ll see all the different mail merge documents available to you.Ĥ. Click on the Mailings tab and click Start Mail Merge.ģ.
Open a new Word document, which will be the main document that will be sent to each recipient in your mail merge.Ģ. Step Two: Create the Document in Microsoft Wordġ. Make sure you’ve made all the necessary edits to your Excel Spreadsheet before you start the mail merge process. When you’re finished creating your contact sheet, save it by clicking on File – Save As. Fill in all the contact data, one per row, starting in cell A2.Ħ. if one of your column headers is “First name” then the field names in your Word template will also be “First name”.ĥ. Note that the column headers must read the same as the placeholder names you want to use in your Word template (e.g.
Enter column headers in the first row (beginning in cell A1). Start entering your address list details into your Excel spreadsheet.Ĥ. Step One: Create Your Address List in Microsoft Excelģ. The mail merge automatically grabs the personalization data from your data file to your template file. that will be added to your template file. The Data File – the data source (usually a Microsoft Excel Spreadsheet or Google Sheet) containing all the personalized data such as first names, last names, addresses, job titles etc. that will be grabbed from your data file (your Excel Spreadsheet).Ģ. It will contain all the placeholder names which will become the personalized data such as first and last names, addresses, job titles etc. The Template File – the document you’ll be sending out to your recipients. The mail merge process consists of two parts:ġ.
#MAILINGS IN EXCEL HOW TO#
How to Do a Mail Merge With Word & Excel The Components of a Mail Merge Mail merges are useful when personalizing any kind of message or document. Try from the Chrome Store today! What Can You Use Mail Merges For? Right Inbox has just recently launched it’s own mail merge feature for Gmail, which makes it super easy to send mail merges within Gmail. They let you send out messages en masse that are personalized to each recipient, so you don’t have to manually customize each document yourself.
0 kommentar(er)
