VBA in Word to populate word document from excel data file.

ThisisElvis

New Member
Joined
Jul 19, 2019
Messages
1
I am looking for a way to extract excel data into a word document, from the VBA in the word document. There is one cell in the excel file that is either empty or contains data that needs to be split so for example:

Excel Data

Cell1 Cell2 Cell3 Cell4
Yes Yes No Yes|No|Maybe|Not Required

In Word doc after import

Cell1 value is: Yes
Cell2 value is: Yes
Cell3 value is: No

Cell4 Part1 is: Yes
Cell4 Part2 is: No
Cell4 Part3 is: Maybe
Cell4 Part4 is: Not required

Then repeat for all other rows in the excel data file.

I don't think this can be achieved using mail merge because of the data in cell4

Appreciate any suggestions on how this can be done.

Thanks in advance
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,102,510
Messages
5,487,310
Members
407,590
Latest member
Grobler

This Week's Hot Topics

Top