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