How To Use Mail Merge | Microsoft Excel | Microsoft Word

Hello Friends,

In today's fast working environment we want short tricks to complete our work in less time. Everyone has listened about mail merge bur more of that don't know how to use and what benefits are. 

By using mail merge you can send a letter, notice, invitation etc in just 5 minutes. you just have to create excel sheet and a letter or notice whatever you want to send.

Mail merge is a function of Microsoft Word. we importing details from excel.

There are three main parts to create a Mail Merge, (1) Creating Contacts (2)import contacts to word ( 3) Use Mail Merge.

We are making an invitation card for that we need a list of our guests and address to send.

(1) Creating a contact list: We are taking 10 contacts with their Name Address and Mobile no.

Data For Mail Merge

And Save Excel File.

(2) Importing Contracts to Word

Step 1: Open Microsoft Office Word, Take New Page. Click on Mailings(Top of the Microsoft Windows) It will show toolbar

Select Mailings For Mail Merge

Step 2:  Now Click on Select Recipients(In the Start Mail Merge Section), Then click on use Existing List(Which We have created in Excel)

A new Window will open. We use our list that we created in part 1 to select the excel file from the Select Data Source window.

(3) Use Mail Merge

Step 1: Go to the place where you want to insert contact information. Click on Insert Merge Field (Will show your data that you entered in excel file)

Merge Fileds Inserted for Mail Merge

When inserting all the field its look like the above image.

Then click on the Preview Result will show you a letter or invitation with contact information for all the contact by clicking next and previous.

Then click on finish and merge. Will Show you three option 

(1)Edit Individual Document: Will open each recipients document and allow you to modify (2)Print Document: Will print all recipients document

(3) Send E-Mail Messages: Which sends a document to each recipient's e-mail.

Follow the instruction on the page you visit.

We have added a link of word file and excel file.

How would you like this content to write us in the comment box!

If you face any difficulty in the content feel free to ask!

Thank You.