#MAIL MERGE HOW TO#
#MAIL MERGE CODE#

This data file can be an Excel spreadsheet or Google sheet. The data file is a source file that contains the data (like name, address, phone number) in the spreadsheet. Mail merge has two essential components that a user should know. The main purpose of mail merge from Excel to Word is to use file1 (Word file) and file2 (Excel document) to create a third file. It is basically the personalized document to be sent.

The third and last one is another Word document that is the final document prepared from the above two files.

#MAIL MERGE CODE#

These source file data are replaced from the fields inside the code of Word document. Excel file is a source file here that contains information about the recipients in the columns to be merged with Word document.A Word document that contains the data with customizing fields for personalized mail/letters.You can understand it easily if you think the mail merge in terms of three documents. Before learning the mail merge process, it looks a very tough task to do. Mail merge is a simple process of creating and sending bulk customized emails or letters to different users. This chapter will guide you to create mail merge from Excel to Word. You can create an email/letter for hundreds of recipients at once. Mail merge can do it easily without creating the mail separately for each recipient. The users do not need to compose the individual email template/ letter for each user. The template file can be a letter or email.īasically, the mail merge allows the users to create a personalized document that varies from recipient to recipient. It works automatically and takes the data from the sheet to the template file. You do not need to create an email from the Email application. Things to know while prepare mail mergeĪ mail merge is a way to quickly create and send the bulk of personalized emails or letters.The MS Excel sheet is only used as a source file, but the merge is actually performed from Microsoft Word.

If you are not even aware about mail merge, you will learn it too.Īn Excel user should know that the mail merge operation does not perform from Microsoft Excel. The mail merge process basically includes the three documents in this process, i.e., template, source, and final document. In this chapter, we will try to elaborate on the mail merge process from Excel to Word.

#MAIL MERGE HOW TO#

This chapter is all about mail merge and how to do it in Excel. Next → ← prev Mail merge from Excel to Wordīefore starting the mail merge, users should know what is mail merge and why it needs.