Thus, the column names in that Excel spreadsheet must be the same as the field names. These placeholders are placed in Word files, whose respective values are picked from the defined Excel spreadsheet. Mail merge has fields, which are known as placeholders. This Excel spreadsheet contains such information, names, email address, address, etc. Mail merge works with Excel spreadsheet to create multiple personalized documents. It saves the effort to create a personalized document for multiple recipients at once. It allows the users to create the personalized documents that will automatically vary recipient-by-recipient. Mail merge is the quickest way to customize the document, like email and newsletters. In this chapter, we will discuss how mail merge works by pairing both Excel and Word applications to create multiple documents. This way, it saves the time of users to retype and recreate the multiple documents with minimal difference. These names are stored in an Excel sheet. Mail merge is an interesting feature that allows to incorporates the data from both Excel and Word and creates multiple documents at once, such as - letter.įor example, you can write a letter and create a mail merge to print it with 10 different salutations like Dear Krish, Dear Joe, Dear Mack, etc. However, MS Excel also helps MS Word to perform mail merge. It is a feature of MS Word, which is available inside the Mailing tab in Microsoft Word. Mail merge is not an MS Excel feature, actually.
0 kommentar(er)
