HOW TO USE EXCEL TO AUTOMATICALLY CHANGE THE SERIAL NUMBER OF THE PRINTED DOCUMENT

Through Excel and Word, with the use of mail merge, complete the printing of single-page document automatic numbering

Workaround for word 2003:

Create a new Excel document, enter the word "serial number" in A1 (it can also be any character), enter the 1001001 in A2, hold down the Ctrl key, drag the small black block (i.e. fill the handle) in the lower right corner of the border of the A2 cell down until it reaches the A51 grid, and the automatic number of 1001001-1001050 will be obtained, and the file will be saved.

Open the Word document you want to print, select Tools - Letters & Mail - select 'Mail Merge' and 'Show Mail Merge Toolbar'

Letter - Next step -

Use the current template - Next.

Select Recipient-Browse-

Select the excel file you just saved - Open - OK -

The Ordinal Number column - Select All - OK appears.

Now where you need to insert the ordinal number, click on the 'Insert Merge Field' button on the mail merge toolbar (to the left of the Insert Word field).

In the Insert Merge Field dialog box, 'Ordinal' is displayed under the field - Point Insert - Close.

Now you can click to insert "Merge to Printer" on the right side of the Merge Field dialog box, and if you merge to a printer, you will automatically type out 50 documents with different serial numbers.

Quote the Use Props report Reply to top

Click "Tools" - Autocorrect - add correction items as you wish.

There's this in the toolbar.

<><4. Click the [Worksheet] tab in the "Page Setup" window, find the "Row Number Column Label" in the [Print] area, check the checkbox in front of it, and the [OK] setting will take effect, as shown in the figure.

5. Now you can see the numbers of the ** rows and columns in the print preview, and the next time you print the file, Excel will automatically print these numbers to complete the rendering.

<><4. Click the [Worksheet] tab in the "Page Setup" window, find the "Row Number Column" in the [Print] area, and check the checkbox in front of it.

5. Now you can see the numbers of the rows and columns of the model in the print preview, and Excel will automatically print these numbers when you print the file next time to complete the renderings.

Use this key to vertical the ready-made grinding book, check only incremental printing, and select the excel type of blind bright macro.

Create an Excel document, and the other steps are the same as above.

Open the Word document you want to print, click on the "Mail" menu, and in the "Start Mail Merge" option bar, select "Select Recipients" - Use Existing List

Find the excel file you just created in the pop-up window, and click "Huaiqing OK" after the pop-up window pops up

Place the cursor in the document where you need to insert the serial number, select "Lead Marker Insert Merge Field" in the "Write and Insert Fields" option bar, and click the word "Serial Number" in it to insert "Serial Number" in this position

In the "Complete" option bar, select "Finish & Merge" -- Print Document, if you select "All" in the pop-up dialog box, 50 copies will be automatically printed, and automatically numbered, if you need to print a custom number of copies, you can define it in the third item "From to yourself".