Mail Merge

Icon representing a letter, an address label and envelope.What is a mail merge?

A mail merge is a method of taking data from a database, spreadsheet, or other form of structured data, and inserting it into documents such as letters, mailing labels, and envelopes. It usually requires two files, one storing the variable data to be inserted, and the other containing both the instructions for formatting the variable data and the information that will be identical across each result of the mail merge. (Adapted from Indiana University KB https://kb.iu.edu/d/agiy)

Mail merge lets you create a batch of documents that are personalized for each recipient. For example, a form letter might be personalized to address each recipient by name. A data source, like a list, spreadsheet, or database, is associated with the document. Placeholders–called merge fields–tell Word where in the document to include information from the data source. More information from Microsoft: https://support.office.com/en-us/article/use-mail-merge-for-bulk-email-letters-labels-and-envelopes-f488ed5b-b849-4c11-9cff-932c49474705