MM of HR asked me one day, saying that a group of personnel appointments in the company were stored in an Excel worksheet recently, but the template was completed in the form of Word when it was issued, however, it would be too hard to repeat one by one. I asked if there is any way to generate a Word letter of appointment based on Excel Data in batches. The most depressing thing is that she showed me the Word that another person has already prepared and said, "You see it as you did "......
However, I have never touched this thing before. Although there is research on something that has already been made, there is no clue. So after a while, she escaped. When I came back, I had a hard time thinking and researching. Fortunately, with the help of Google, the solution was finally found after several keywords were replaced-in fact, office03 already existsEmail mergeFunction. Considering that many single IT colleagues do not dare to enjoy IT exclusively, this article is available.
Preparations
First, prepare a Word document with the following content. (You don't have to worry about data domains, Word controls, and so on. I had a detour on it)
Next, prepare an Excel Data source with the following content:
Start merging
1. Open the Word document, click the email in the feature area, and select "Mail Merge step-by-step wizard" in "Start mail merge"
2. In the functional area on the right, select Document Type as letter
3. Select the current document from the start document
4. Select the prepared Excel Data Source from select recipient
5. select another project from the writing letter
6. Insert the merged domain name to the specified position in the article.
7. In the preview of a letter, you can view the merged letter.
8. Click "merge", and then select "Edit single letter" in "merge selection ".
9. In the "merge to new document" dialog box, select all to view multiple appointment books generated based on the data source. Save the new document.
Okay, the above is the Mail Merge function. Which of the following example can be downloaded one day?