Hello All -

I have an excel sheet with text in Column A and Column B. I need each line exported to a seperate word document where there maybe 1000 plus lines in one excel sheet. Therefore, first line goes to one word doc, second line to another word doc etc....

On the work document I need Column A to appear at the top of the page and Column B located near the bottom of the page.

Example:

Column A Column B
John Doe 12345678
Chris Johns 12345678
Nancy Johns 12345678
etc....


Does anyone know how to do this or a macro to do this?

Thanks in advanced

daveofgv