word with mail merge import excel to print the problem of the admission ticket

First of all, your excel sheet should have the corresponding fields, such as name, gender, etc.

Because you want to type four on a piece of paper, where the ** is name1, gender 1....Name2 Gender2....Name3 Gender3....Name4 Gender4....Indicate the other fields you want.

Second, open Word and make four admission tickets on one. The fields to be inserted are in Excel.

Third, select the data source in Word, which is the excel sheet you just made, and also let you select the workbook. Then insert the domain. It's name1, gender1....

Name2 Gender2....Name3 Gender3....Name4 Gender4....

It should show as f1f2....Once you're done, check out the merged domains and you're done. When you print, there's a Merge to Printer button.

Note: View-Tools-Mail Merge. The toolbar for mail merge appears on it. Just click the button above and you're good to go.

The rows of the excel sheet must be made as name 1 gender 1....Name2 Gender2....Name3 Gender3....Name4 Gender4....

The excel sheet must be saved and opened in a state.

I also use the sungirl00156 method.,But there are 10 pieces of information that each person needs to import.,Do you have any other easier way?。

1. First of all, open the admission ticket template that needs to be made, which needs to be in word format. Prepare the basic information, which must be in excle format. The Excle information table is closed.

2. Then click on the email below to quote and <>

3. After the mail merge appears, click in the upper left corner to open the data source.

4. Select the excle** containing the data that you prepared earlier, and click OK.

5. Select the area that needs to be filled in with the mouse, click the upper left corner to insert the merged field, select the corresponding name column after the dialog box appears, and click Insert.

6. At this time, the name column is ready, follow the above steps: select the area that needs to be filled in with gender, click on the upper left corner to insert the merge field, select the corresponding gender column after the dialog box appears, click Insert, and then select the gender, admission ticket number, and exam time area.

7. Then click above to view the merged data.

8. At this time, you can preview the merged content, and if there are mistakes, you can correct them in time.

9. Click Merge to new document above, select all in the dialog box, and click OK.

10. Slide the mouse down, you can see all the contents of the merger, and the admission ticket is completed. Just rename the document and save it where we can find it.

Method 1: Copy eight of the same tables in Word, and then select "Columns" in "Page Setup" to divide into two columns, and finally adjust the size and format, it should be fine!

Method 2: That is the way to insert a text box, and you can also achieve the same purpose!

Mail Merge Steps:

1. Click Tools in Word - Letter and Mail Merge - select the first item Mail Merge and the second item Show Mail Merge toolbar;

2. Click the second symbol on the toolbar: Open Data Source - Follow the prompts in the dialog box to find the folder - open the excel sheet you want to merge;

3. Put the cursor in the position you want to merge in word, click the 6th symbol on the mail merge tool: insert field--- select in turn in the pop-up dialog box, select one -- click insert, close; Place the cursor in the second position you want to merge - click Insert, close;

4. After all the insertions are completed, click the penultimate symbol in the mail merge toolbar: Merge to new document, save it as the corresponding file name in the new document, and finish.

When we need to print certificates in batches or envelopes in batches with WROD, if you master the small function of "mail merge", you can get your job done in minutes, come and try it.