software

Is it possible to specify which worksheet on an excel spreadsheet that
Microsoft word picks up the data from.

I seem to only be able to make Word find data records on the first
worksheet and I could do with mailmerging the data on the third.

I need the first worksheet's data for a separate merge so I can't
simply swap sheet 3 for sheet 1!

Many thanks for any help with this...

CF--
clown fish
------------------------------------------------------------------------
clown fish's Profile: www.excelforum.com/member.php...oamp;userid=31364
View this thread: www.excelforum.com/showthread...hreadid=510582Select the worksheet columns and Insert--gt;Name--gt;Define. When you go to
merge, the name will be one of the options along with Entire Spreadsheet...

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

quot;clown fishquot; gt; wrote
in message ...
gt;
gt; Is it possible to specify which worksheet on an excel spreadsheet that
gt; Microsoft word picks up the data from.
gt;
gt; I seem to only be able to make Word find data records on the first
gt; worksheet and I could do with mailmerging the data on the third.
gt;
gt; I need the first worksheet's data for a separate merge so I can't
gt; simply swap sheet 3 for sheet 1!
gt;
gt; Many thanks for any help with this...
gt;
gt; CF
gt;
gt;
gt; --
gt; clown fish
gt; ------------------------------------------------------------------------
gt; clown fish's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31364
gt; View this thread: www.excelforum.com/showthread...hreadid=510582
gt;