merging to Word

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

I'm trying to merge an Excel worksheet #2 for labels on
word. I keep getting records for worksheet #1 even though
I've set the print area for worksheet #2. When the dialog
box appears on word to choose Entire workbook or print
area, I choose print area. I can't figure out what I'm
doing wrong.
Thanks
 
Laura

Word's mailmerge and Excel as a source for data is sometimes quirky and the
best way to ensure proper merging is to have the worksheet you want merged to
be the first sheet in the workbook.

I have always been successful using this method.

Move Sheet2 to the left of Sheet1 and try again.

Gord Dibben Excel MVP XL2002
 
Back
Top