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)?

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)?

Hi,

For mail merge process you can use this link:
http://office.microsoft.com/en-us/wo...CL100636481033

It is recommeded that you combine two sheets into a common worksheet and
then do a mail merge within the word document.

Important: There is no option to select the second sheet during the runtime.
You must have to follow the same process agin for mail merging the second
sheet2.

Challa Prabhu

"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)?