Open the MS Word file with the letter template In order to mail merge Excel to Word, we will make use of the Mail Merge Wizard. Save both files in the local drive for easy reference. Note that for each recipient, we have entered the First Name, Last Name, Address and Country of residence.
The MS Excel mail recipient file will look like this: Mail merge Excel to Word letter Excel mail merge template The MS Word file will look like the example below.įigure 1. Microsoft Excel file with the list of recipients, where we allocate one line for each recipient.Microsoft Word file with the letter template.In order to mail merge from Excel to Word, we need two files: We can create and send letters and emails with a large mailing list in a shorter span of time with the mail merge. So much time can be saved when we merge from Excel to Word.
0 kommentar(er)
