![mail merge from excel document mail merge from excel document](https://support.content.office.net/en-us/media/d1136770-3df5-4cc8-bb73-f890511f57d5.png)
- #Mail merge from excel document how to
- #Mail merge from excel document Pc
- #Mail merge from excel document download
Then, return to it when finishing the merge to choose the corresponding column. First, you need to select the file with an address list in Step 3 of the Step-by-step Mail Merge Wizard. Specifying recipients in Word is a bit complicated. Selecting recipients when mail merging in Word.Just indicate the spreadsheet file as the database when selecting recipients and the column header name for the To field. Now, the mail merge tool you use can create individual emails containing the unique address for every recipient from the mailing list. Put your mailing list in the appropriate column. To mail merge the data from the spreadsheet document via Mail Merge with Attachments, save the Excel file in a comma-separated value (.csv) format. Format the columns containing percentages and postal codes as text. the format of columns that contain numeric data, like currency and measures.the presence of the table for merging in the first sheet of your Excel file.
![mail merge from excel document mail merge from excel document](http://moonlapsetech.com/Images/Word_MailMerge02.png)
For instance, to address recipients by the first name, both the last and first name need to be in separate columns
#Mail merge from excel document how to
#Mail merge from excel document download
#Mail merge from excel document Pc
Because Excel is a ubiquitous spreadsheet format, many PC users know how to work in it, at least at a basic level.
![mail merge from excel document mail merge from excel document](https://images.techhive.com/images/article/2015/06/figure2-mail-merge-step-2-select-recipients-100589518-large.png)
![mail merge from excel document mail merge from excel document](https://i.ytimg.com/vi/ZQJydKxJtd8/maxresdefault.jpg)
The most common file format for this document is MS Excel. The column headings of such a spreadsheet correspond to the merge fields in the mail template. Mail merge data can be contained in a spreadsheet file.