VBA Code - Exporting One Excel File to Multiple Word Documents

Hi,

I am looking to split out data from one excel file into multiple word documents without having to manually copy, paste and save each time. I have attached an excel file where I will need the data from columns E-G pasted into 5 different word documents based on the number in column D. There is also constant text in each word file that will need to be carried over (this text is in the attached word file).

The final product for the first file would look like this in Microsoft Word:

Dear User,
Here is the following information from excel:

Letter1 Letter2 Letter3
a g a
b b d
c d f

The file would then be saved and titled "1 - Request". Then, 4 more files would be created. The second one would be saved as "2 - Request" and look like this:

Dear User,
Here is the following information from excel:


Letter1 Letter2 Letter3
d r h
e w k
f q l

If this is easier without using VBA, I am open to other suggestions as well!

Thanks,

Nicole

David,

This is great - thank you so much for your help!

Nicole