For mail merge, the best combination is Excel and Word.
Find here how to mail merge from Excel to Word in two easy methods.
Mail merge is the most affordable form of office work automation on desktop and laptop computers.
So lets get started with the methods to do a mail merge from Excel to Word.
you’re free to separate various data in a single row under different column headers.
These column headers will work as the counterpart for Mail Merge Fields in Word.
you’re able to create the column header as you c’mon now.
But later, you must make minor edits in column headers to match fields in Word.
Find below the basic steps to create a database for mail merge in Excel.
Youve successfully created the Excel database for the mail merge project.
Lets get started creating the mail merge template in Microsoft Word.
The letter must contain some basic information about you as shown below.
These are static for all emails and mails.
Word mail merge will carry the formatting in all other documents that you create in this mail merge project.
Finishing merging in Word
Once ready, clickFinish & Merge>Edit Individual Documents>Allin theMerge recordsdialog box.
ClickOKto create all merged documents for each customer in the Excel database.
So, you must save the file separately or send emails right away.
However, this is a tricky method.
You must modify the source database in Excel according to the available Mail Merge Fields in Word.
For this, you must have the Excel file with you.
Then, create a new Word document and start writing your email or mail.
How Do I Create a Mail Merge From Excel Data?
