merge with excel question

[Cowtoon]

I have all of my data for my merge in an excel spreadsheet. For good
reasons, the spreadsheets has the information in several worksheets (but all
in one file).

Is there a way to do a merge that will include all of the worksheets? I
have to do toooooo many merges to merge all of the data, otherwise. I don't
usually merge all of the worksheets at a time.

Can someone help with this. Thanks. Diana

 

[Doug Robbins]

Word can only use a single "flat file" as the data source. If for some
other reason, you need to keep the separate worksheets, add another
worksheet to the file on which you have references to each of the cells in
the individual worksheets so that on that new worksheet ALL of the data is
displayed.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP