exporting excel to multiple word documents? like mail merge?

Kyle775

Board Regular
Joined
Feb 16, 2005
Messages
230
i have an excel list, is there a way to set up a single word document to take data from excel? maybe this isnt the right place to ask, might be more of a word question than an excel question... (but i dont use word very often) i need exactly what a mail merge does only each row to a new page or document of word.... something to do with word forms? templates? i have looked at a few options but i think i just need to be pointed in the right direction.... any help is great!! thanks!
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Kyle775

Board Regular
Joined
Feb 16, 2005
Messages
230
in case anyone else is attempting this and comes across this thread, ive figured this out, it is done as a mail merge to a letter in word. much the same way labels are done, i found it easiest to show the merge tool bar and then click on "add merge feild" button to choose the feild i want to use from my data source.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,070
Messages
5,570,018
Members
412,304
Latest member
citrus
Top