Using different worksheets as sources for mailmerge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Graham - 28 Jan 2005 17:09 GMT

I need to extract data from up to 50 different worksheets in the same
workbook to merge to a standard word document. When I set up the data source,
it always defaults to the first sheet in the workbook. How do I get it to
look at the current or open sheet that I want to extract the data from ?
Many Thanks

Reply to this Message

Doug Robbins - 29 Jan 2005 00:40 GMT

Word can only use a single work sheet as a data source for the one
mailmerge, not multiple sheets. To be able to select a particular sheet,
from the Tools menu, select Options and then go to the General tab and check
the box for the "Confim conversions at open" item. Then when you attach the
data source to the main document, you will be given a number of options for
the method of connection to be used. One of them will give you the ability
to select a particular sheet in the work book.

Signature

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

>I need to extract data from up to 50 different worksheets in the same
> workbook to merge to a standard word document. When I set up the data
> source,
> it always defaults to the first sheet in the workbook. How do I get it to
> look at the current or open sheet that I want to extract the data from ?
> Many Thanks

Reply to this Message