Merging Excel worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BANKBOY - 04 May 2006 01:03 GMT

Hi there,

I am trying to merge an excel spreedsheet that utilizes 3 worksheet for
various calculations, however I only want to import the first worksheet into
the mail merge.

It seems that word is automatically importing all 3 worksheets creating.

Any ideas?

THANKS PEOPLES

Reply to this Message

Doug Robbins - Word MVP - 04 May 2006 04:48 GMT

In Word, from the Tools menu, select Options and then go to the General tab
and check the box against the item "Confirm conversions at open." After you
do that, when you attach the data source to the mail merge main document,
you will be given a choice of the method by which the attachment should be
made. Select the DDE option.

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

> Hi there,
>
[quoted text clipped - 8 lines]
>
> THANKS PEOPLES

Reply to this Message