Exporting select data from Excel sheet to a word Doc

MLoveless

New Member
Joined
Mar 6, 2015
Messages
3
Hello,

I have a order form which Multiple orders per line. Some orders have multiple lines if the customer purchased multiple items. I want to be able to export each order into a separate word document. Is there a way to do this?

Example


Order NumberCustomer NameAddressContact NumberItem
123Mike123 Fashion Lane818-222-5555Tooth Brush
123Mike123 Fashion Lane818-222-5555Tooth Paste
123Mike123 Fashion Lane818-222-5555Comb
456Sally852 Bread st212-555-2222Spray
789Joe9999 Shop blvd303-999-7777Watch
789Joe9999 Shop blvd303-999-7777Shirt

<tbody>
</tbody>


So this example would create 3 word documents

1st one would have Mike's Information in it once and the list of items he was getting
Tooth brush, tooth Paste, and a Comb

2nd one would have Sally's information and her One item

3rd one would have Joe's information and his two items.
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Hello,

I have a order form which Multiple orders per line. Some orders have multiple lines if the customer purchased multiple items. I want to be able to export each order into a separate word document. Is there a way to do this?



Example


Order NumberCustomer NameAddressContact NumberItem
123Mike123 Fashion Lane818-222-5555Tooth Brush
123Mike123 Fashion Lane818-222-5555Tooth Paste
123Mike123 Fashion Lane818-222-5555Comb
456Sally852 Bread st212-555-2222Spray
789Joe9999 Shop blvd303-999-7777Watch
789Joe9999 Shop blvd303-999-7777Shirt

<tbody>
</tbody>


So this example would create 3 word documents

1st one would have Mike's Information in it once and the list of items he was getting
Tooth brush, tooth Paste, and a Comb

2nd one would have Sally's information and her One item

3rd one would have Joe's information and his two items.



If it was in the same word document on different pages that would be ok as well.
 
Upvote 0

Forum statistics

Threads
1,216,146
Messages
6,129,142
Members
449,488
Latest member
qh017

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top