How to make a certificate in bulk with mail merge in Word document

First of all, we need to use excel** to make a list of awards, including names, awards, dates, etc., as long as the items that need to be filled in the award certificate, and remember to make the header when making **, so that we can use the mail merge to make a selection, and save it on the desktop after completion.

Then open the word document, create a new award document, if there is no award template in the available template, you can** (the template in is**good), if you are not satisfied with the font design in the award, you can change it yourself, and if you want to merge the invitation, you can also **invitation, or design your own invitation.

Once opened, select "Mail" on the ribbon, click "Start Mail Merge", and select "Mail Merge Step-by-Step Wizard (W)" from the drop-down menu

Then click "Choose recipients".

Then select "Browse" above

Then in the pop-up selection data source, find the excel** we made earlier, select and open it.

Then select or position the cursor in the place where we want to add the name and award, and then click on "Other items".

Then click "Database Domain" in the pop-up dialog box, then select the item we want to insert, such as "Name", and then click "Insert".

Then the place we selected becomes the project we inserted.

Then use the same method as step 11 to insert "Award", "Event", etc. in order (each time you insert it, you need to close the dialog box of "Insert Merge Field" before you can select it again, remember to select the position we want to insert).

Once you've inserted everything, go ahead and click on "Preview Letter".

Then a certificate is complete, and then go ahead and click "Finish Merging".

If you want to see all of them's awards, click on "Individual Letters".

In the pop-up dialog box, click "All" and then OK.

When you're done, scroll down and you'll see all of your awards.

Part 1: Preparations.

In the first step, I opened Excel2010 and filled in the award information form, including the certificate number, name, category and honorary name.

The second step is to use word2010 to design a template for the certificate of honor against the previous certificate of honor, display the public part, and leave a blank space for the position to be filled. Click "Page Setup" under the "Page Layout" tab of Word2010, and customize the paper size according to the actual size of the certificate of honor in the "Paper" option of the "Page Setup" dialog box. In general, it is a bit larger than A4 paper.

The second part is to make a certificate of honor.

In the first step, I click on the "Mail" tab of Word 2010, click on "Start Mail Merge", and select the "Normal Word Document" option. Then click the "Use existing list" option in "Select recipients" to open the "Select Data Source" dialog box, in this dialog box, locate the path where the Excel2010** file you just filled in is located and select the file.

The second step, click "Recipient List", select the name of the person who issued the honorary certificate in the window that opens, the default is to select all, click the "OK" button after selection, move the cursor to the position of the word2010 document where you want to insert the name, click the small arrow on the right side of the "Insert Merge Field", select "Name", and use the same method, select "Category" and "Award Name" in turn. It should be noted here that the name and other words on the original honor certificate should be deleted.

The third part is completed.

In the first step, now I can click on "Preview Result" to see that the name, category and award name of the awardee are automatically replaced with the information of the awardee, click the arrow on the right side of "Preview Result" or enter a number, and you can see that all the honorary certificates have been replaced successfully.

The second step, now click the arrow in the lower right corner of "Finish and Merge" to select different items to process them differently, "Single Document" can merge these honorary certificates into one Word 2010 document; "Print Documents" can print these certificates directly from the printer. Select Single Document and select All records in Merge to New Document to generate a new document with a Certificate of Honor, including all printouts.

After six steps, I have completed all the work of the certificate of honor in word 2010 using the mail merge function, and the rest is to print the certificate of honor one by one.

Here's how:Operating equipment: Qi Na Dell computer.

Operating system: win10

Operating software: excel2017

1. Excel file ready.

2. Open a Word template.

3. Mail in the word toolbar and click Select Recipients to use the existing list.

4. After selecting the existing Qing Travel list, select the excel sheet and click Open.

5. After opening the table, select the worksheet where the personal information is located.

6. Once opened, position the cursor where the name is inserted and click on the insert merge field to select the name.

7. Repeat the naming steps of the college and major, and insert the information.

8. After inserting the information, click Mail and merge a single document.

9. Then select All and click OK.

10. Click OK to merge the mail.

Finish. <>

1. List the names twice in excel and then save.

2. Open the word of the award certificate, and click on the tool-letter and mail-mail frank faction merge.

3. After right-clicking Merge, click Select Letter.

4. Then select Use Current Document.

5. Click to browse.

6. Select the judgment chamber just now excel** to open.

7. After opening Excel, click on other items.

8. Select the "Name" line in "Domain", click the "Insert" command button at the bottom of the dialog box, and insert the student's name at the cursor.

9. Select the award and insert the domain into the appropriate position.

10. After inserting, click Next to complete the merge.

11. Finally, click Print.

1. List the names twice in excel and then save.

2. Open the word of the award certificate, click Tools-Letter and Mail-Mail Merge.

3. After right-clicking Merge, click Select Letter.

4. Then select Use Current Document.

5. Click to browse.

6. Select Excel** just now to open.

7. After opening Excel, click on Other Items.

8. Select the "Name" line in "Domain", click the "Insert" command button at the bottom of the dialog box, and insert the student's name at the cursor.

9. Select the award and insert the domain into the appropriate position.

10. After inserting, click Next to complete the merge.

11. Finally, click Print.

If you don't know how to use the mail merge function, you can directly use the following ready-made tools to create them in batches.

Set the first line of the mail merge template to the built-in format header level 1, save the template to a folder, merge it into a new document, enter the insert outliner, split the molecular documents, and each will generate multiple sub-documents with the name of the first-level header in the folder.

Here's how:

1. First, click the [Email] tab and select the recipient according to the settings shown below.

2. Find the location where the basic table is stored, and select the data source according to the prompts.

3. Click the View tab and select Outline View.

4. Select the title of the Chinese file, click the [Outline] tab, and set the outline level to [Level 1].

5. Switch to the [Mail] tab, click each blank cell in turn, and insert the merge field. Also insert the Name field before the title (not required here, you can select it if you want).

6. Then click [Finish and Merge] and [Single Document], and then you can generate a word document named "Letter 1".

7. In the [Outline] view, press CTRL+A to select all content, and set it as shown below to create a sub-document.

Click the Save button to save the "Letter 1" document as "Summary". docx”。directory is generated with several sub-documents named by the employee's name.

First of all, you have done the mail merge, click Done and merge the first item in the single document. All word files are automatically generated. But in a word, if you still need to split again. It's another formula.

This is very simple, I can write a program with opencv, you just need to provide it to be filled.

I can do the ** template and text (preferably in **, or in a txt file), such as filling in batches the name of the winner on the award certificate, the name of the student on the graduation certificate, 35,000 is not a problem.