You can move sheet2 before sheet1 or give the sheet2 data range a name.

Word will allow you to select a named range for the merge input.


Gord Dibben MS Excel MVP

On Tue, 14 Aug 2007 07:08:03 -0700, Deh_Dot
wrote:

I'm trying to merge Sheet 2 of an Excel spreadsheet into lables in Word. Is
there an option during the merge process that allows me to select Sheet 2
instead of Sheet 1 (that automatically shows)?