Mix data from Excel to Word

The following article shows how to Merge data from Excel to Word 2013 .

For example, write a detailed salary table for 100 workers using data from Word and Excel.

Salary details are created by Word file in which the Name field, Department, December 2015 salary details are taken from Excel file.

Mix data from Excel to Word Picture 1

Excel file data:

Mix data from Excel to Word Picture 2

Step 1: Choose MAILINGS -> Start Mail Merge -> Step by Step Mail Merge Winzard .

Mix data from Excel to Word Picture 3

Step 2: In Mail Merge select Letters -> Next: Starting document .

Mix data from Excel to Word Picture 4

Step 3: Integrate select Use the current document -> Next: Select recipients .

Mix data from Excel to Word Picture 5

Step 4: Click Browse and select the path to the Excel file containing the list.

Mix data from Excel to Word Picture 6

Step 5: After selecting the Excel file, the Select Table dialog box appears -> select the data table you want to insert (here choose Sheet 1) -> OK .

Mix data from Excel to Word Picture 7

Step 6: Check the records you want to retrieve data -> Select OK .

Mix data from Excel to Word Picture 8

Step 7: Place the cursor at the position you want to insert data -> select More Items .

Mix data from Excel to Word Picture 9

Step 8: Select the corresponding data field -> Insert .

Mix data from Excel to Word Picture 10

Step 9: Insert the corresponding remaining data fields with the following results:

Mix data from Excel to Word Picture 11

Step 10: Select Next: Preview your letters with demo record -> click Next: Complete the merge to complete the data merging.

Mix data from Excel to Word Picture 12

Step 11: Choose Edit Individual letters -> select dialog box appears displaying all area All or option of records displayed in the From . To -> OK .

Mix data from Excel to Word Picture 13

Step 12: Results after selecting:

Note: After mixing data you can merge between pages to save paper.

Good luck!