Mail merge in excel is a very useful feature which allows us to customize one excel document for many different people like sending emails according to name, address, or any other information. This process is mainly for them. The advantage is that one wants to send the same type of information to more people like invitation letter, notification etc.
Benefits of mail merge
With the help of merge mail, you can send personalized letters to a large number of recipients. There is no need to create a new document every time because if you have to send the same letter to 100 people in merge mail, then everyone's name and address are different, then merge mail helps you automatically.
Process to merge mail:-
- Preparing the data source:-
You have to prepare in excel the details of all the people to whom you want to send the letter like name, address, email etc. and divide it into columns in an excel sheet.
- Columns with different information like name, address, email
2.Preparing the document:-
Now prepare a letter in Word. In this letter, add merge fields at the place where you want to see the information of each person like name or address.
3. Setting up merge mail:-
Go to the mailings tab in word and click on select recipients. Now select your excel sheet from there.
4. Inserting Fields:-
Now using insert merge field you can insert merge fields like name, address etc. in your letter
5. Finalizing the mail merge
When your letter is ready then click on finish and merge. Now you can view or even print what you have merged.
Conclusion:-
Merge mail me saves both time and effort especially when you need to send personalized letters to a large number of people
0 Comments