How do you print certificates and envelopes in bulk in Word?

the method of batch printing certificate:

First, the establishment of a certificate template

First of all, use Word to make a certificate template and save it as "certificate. Doc", the class, name, award category first vacated, to ensure that the printed output of the format and certificate paper.

　　Second, use Excel to establish the winning database

Enter the winners in the Excel form as well as receive some relevant information and save them as "certificate data. xls".

　III. related databases and certificates

Open "certificate. Doc", select view → toolbar → mail merge, select "Open Data Source" in the newly appearing toolbar, select "Certificate data. xls", open and select the appropriate workbook, default to Sheetl, and press OK.

Position the mouse where you want to insert the team, click Insert Field, select Class in the pop-up dialog box, and press insert. The same method completes the insertion of names, items, and rankings.

　Four, preview and print

Select View merged data, and then use the front and rear arrows to browse the effects of the merged data, and select Merge to new document to generate a Word document that contains all the certificates, which can then be printed in bulk.

The mail merge feature makes it easy to associate Excel data with a Word document, and if the data changes, just modify it in the Excel table. With this function, can also be very convenient to produce and print transcripts, payroll and so on.

How to print envelopes in bulk:

Many schools before the beginning of the school to send students to accept the letter, after the test to send the student transcripts, the Dean needs to print a large number of envelopes. In fact, use Word XP and Excel XP can collaborate to print envelopes, take a look at it.

1. Preparation Stage

(1) Create a new Excel file "Freshman list", the new list of information import or direct input, such as: Postal code, mailing address, name and so on.

(2) Create a new Word file "envelope", invoke menu tools → letters and messages → Chinese envelopes Wizard, open the Envelope Making wizard dialog box (not required to install with the Office XP source disk), design an envelope according to the wizard prompts, and set the font, font size (as shown in the picture).

2. Call data

(1) in the "envelope" file, call menu "view → mail Merge", display the Mail Merge toolbar, click the [Open Data Source] Tool button, press the prompt to select the new Excel file "Freshman list", select Sheet1.

(2) Select "000000" (for postal code), click on the Mail Merge toolbar [insert field] button, select Insert "Zip Code" in dialog box, "000000" be replaced by "ZIP code". Then do the same thing, substituting "address", "name".

(3) Click on the Mail Merge toolbar [view merge Data icon] button to display the student data in the "Freshman list".

3. Print Envelopes

Many schools at the end of the semester to send students the results of the notice, the Dean needs to print a large number of envelopes. Use Word XP to collaborate with Excel XP to print envelopes in bulk, take a look.

Learn the above method, now in Word batch printing certificates and envelopes is not convenient much.