How do I mail merge 2nd sheet of an excel sheet?

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

Hi,

For mail merge process you can use this link:
http://office.microsoft.com/en-us/word/HA010349201033.aspx?pid=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