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:
![Mix data from Excel to Word Picture 14](https://tipsmake.com/data/images/mix-data-from-excel-to-word-picture-14-y8do9WuqM.jpg)
Note: After mixing data you can merge between pages to save paper.
Good luck!
You should read it
- How to copy data from Excel to Word?
- Create reports automatically in word from Excel's data sheet
- Transfer form data from Word to Excel
- How to insert a Word document into an Excel file
- How to Convert Word to Excel
- How to copy Word data to Excel keeps formatting
- Instructions to copy data from Excel to Word retain the format
- How to scroll bar scrolls horizontally and vertically in Word and Excel
- How to convert a Word file to Excel
- How to use Excel spreadsheets in Microsoft Word
- How to align text in a cell in Excel
- How to recover Word, Excel files when deleted with Data Recovery Wizard