What is a mail merge in office

Mail merge: In office, create two documents first: A word that includes a main document with all the files in common (such as an unfinished envelope, etc.) and a data source that includes change information Excel (the recipient, sender, zip code, etc.), and then use the mail merge feature to insert changed information in the main document , the synthesized file user can be saved as a Word document and can be printed or sent out in the form of a message.

Application areas

1, Bulk printing envelopes: In a uniform format, the electronic form of the postcode, the recipient address and the recipient printed out.

2, Bulk printing letters: mainly in exchange from the spreadsheet to call the recipient, change the title, the content of the letter basically fixed unchanged.

3, Bulk printing invitations: Ditto 2.

4, Batch printing payroll: From the spreadsheet call data.

5, Bulk print personal resume: From the spreadsheet call different field data, each page, corresponding to different information.

6, Batch print student transcript: Take out personal information from spreadsheet results, set up comment fields, and write different comments.

7, Batch printing various types of award certificate: in the spreadsheet set name, award-winning name and other funds, in Word format printing, you can print many certificates.

8, Batch printing admission ticket, admission ticket, postcards, envelopes and other personal statements.

In short, as long as there is a data source (spreadsheet, database), etc., as long as a standard two-dimensional table, it is easy to press a record of a page from the Wrod in the mail merge function to print out.