Mail merge from more than one XL worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 06 Apr 2007 13:54 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 06 Apr 2007 17:21 GMT

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.

Signature

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

> 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

Reply to this Message