Excel File data into Multiple word files by one click | Microsoft Word | Tips and Tricks

 One Excel File data into Multiple word files by one click

Files:

https://drive.google.com/file/d/1haq_31ki8LwQfqd_gviiQQpOt5wbASpU/view?usp=sharing

Steps follows:

1. Open Microsoft Word

2. Go to  Mailing Tab

3.  In Start Mail Merge Ribbon click on Select Recipients

4. select Use Exiting List(select your excel data file from computer)

5. In write and Insert Ribbon click on insert merge fields ( Insert required data fields)

Note: you can check preview by click on preview results

6. make a heading word 1st line data

a. home tab

b. style ribbon

c. select heading 1

7. In finish Ribbon click on finish & Merge option

8. Select edit individual documents

(created excel data rows into individual word pages)

9. Click on view tab

10. In document views ribbon select outline option

11. Outlining tab

12. In Outline tools select show documents

13. In master documents ribbon select create 

14. Save file

Its Done.

Thank you for more latest updates follow us.