word mail merge

Word mail merge function: Insert a kind of data related to the sent information into the fixed content of the main document, and generate the required email documents in batches. Greatly improve work efficiency.

In Office, first create two documents: a WORD main document that includes the common content of all files (such as unfilled envelopes, etc.) and a data source EXCEL that includes change information (filled in recipients, Sender, zip code, etc.), and then use the mail merge function to insert the changed information into the main document. The user can save the combined file as a Word document, print it out, or send it as an email.

Application areas

1. Batch printing of envelopes: According to a unified format, add the zip code and recipient in the spreadsheet The address and recipient are printed.

2. Print letters in batches: The main thing is to call the recipient from the spreadsheet and change the name. The content of the letter is basically unchanged.

3. Batch printing of invitations: Same as above 2.

4. Print salary slips in batches: call data from spreadsheets.

5. Print resumes in batches: call different field data from the spreadsheet, one page per person, corresponding to different information.

6. Print student transcripts in batches: take out personal information from the spreadsheet results, set the comment field, and write different comments. [1]

7. Print various award certificates in batches: Set the name, award title and qualifications in the spreadsheet, set the printing format in WORD, and you can print many certificates.

8. Batch print admission tickets, postcards, envelopes and other personal reports.

In short, as long as there is a data source (spreadsheet, database), etc., as long as it is a standard two-dimensional number table, you can easily print one record per page from WROD using the mail merge function. come out!

Recommended related articles:
1. How to use the word email function
2. What are the basic operations of word

The following are used in Word2010 Use the "Mail Merge Wizard" to create a mail merge letter as an example. The steps are as follows:

Step 1. Open the Word2010 document window and switch to the "Mail" group. Click the "Start Mail Merge" button in the "Start Mail Merge" group, and select the "Mail Merge Step-by-Step Wizard" command in the menu that opens.

Step 2, open the "Mail Merge" task pane, select the "Letter" radio button on the "Select Document Type" wizard page, and click the "Next: Starting Document" hyperlink.

Step 3. In the "Select Start Document" wizard page that opens, select the "Use Current Document" radio button and click the "Next: Select Recipients" hyperlink.

Step 4. Open the "Select Recipients" wizard page, select the "Select from Outlook Contacts" radio button, and click the "Select 'Contacts' Folder" hyperlink.

Step 5, select the previously saved Outlook profile in the "Select Profile" dialog box that opens, and then click the "OK" button.

Step 6. Open the "Select Contacts" dialog box, select the contact folder to be imported, and click the "OK" button.

Step 7. In the opened "Mail Merge Recipients" dialog box, you can uncheck the contacts as needed. If you need to merge all recipients, click the "OK" button directly.

Step 8, return to the Word2010 document window, click the "Next: Compose Letter" hyperlink in the "Select Recipients" wizard page of the "Mail Merge" task pane.

Step 9, open the "Writing Letter" wizard page, position the insertion point cursor at the top of the Word2010 document, then click the "Address Block", "Greetings" and other hyperlinks as needed, and compose as needed Contents of the letter. Click the "Next: Preview Letter" hyperlink when you're finished writing.

Step 10. You can view the content of the letter on the "Preview Letter" wizard page that opens. Click the Previous or Next button to preview letters from other contacts. After confirming that there are no errors, click the "Next: Complete Merge" hyperlink.

Step 11: Open the "Complete Merger" wizard page. Users can either click the "Print" hyperlink to start printing the letter, or click the "Edit Single Letter" hyperlink to edit individual letters.

For more Word-related technical articles, please visit theWord Newbie Tutorialcolumn to learn!

The above is the detailed content of word mail merge. For more information, please follow other related articles on the PHP Chinese website!