Mail Merge

[clown fish]

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

[Anne Troy]

Select the worksheet columns and Insert-->Name-->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

"clown fish" <[email protected]> wrote
in message news:[email protected]...
>
> 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:
> http://www.excelforum.com/member.php...o&userid=31364
> View this thread: http://www.excelforum.com/showthread...hreadid=510582
>