Have a excel sheet that has many rows of data in it ( about 500 ). Need a way to export each row to a word document. I know this can be done per row with VB but the issue I am running into is that I have my data on the fourth tab on the excel Sheet and I need to export each row sometime once and other time more then this. The reason is that it is for a drawing based item and if joe purchased 10 tickets I need to be able to export that row 10 times to a printable ticket to be able to pick from at the end of the drawing. bit maybe Mary only bought 1 ticket and I need to print that row to word only once.
Any help would be great.