merging to Word

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Duplicate Mail Merge Record Every Time 5
Merge Excel file into Word Document 3
Mail merge labels 8 per page, but 84 is not divisible by 8 3
Mail Merge skipping records/sending one at a time 0
Booklet in Word, Merge Directory from Excel 0
Need Help Creating a Word 2010 Chistmas Letter Template 8
Set up and printing a 4-up mail merged postcard 0

Top