Mail merge from more than one XL worksheet

S

Steve

Is it possible, within the one WOrd document to mail merge from more than one
XL worksheet?
I have a XL workbook with several worksheets and want to pull data from
several sheets into the one Word document
 
D

Doug Robbins - Word MVP

Word can only use a single data source for mailmerge. Therefore, you would
need to insert a new sheet into your workbook and on that sheet reference
the required columns from the other worksheets so that you get all of the
data appearing in the one place.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
Top