Mail merge using Excel won't recognise one sheet

K

kiwiwaldo

I am trying to create labels from an Excel workbook with several sheets. this
has worked fine in the past, but now word will not recognise the one sheet
which contains the addresses. other sheets are recognised fine. what could
be different? no filters applied, no print areas, but the sheet shows twice
on the list of sheets. tried changing the name to no avail. any suggestions?
Thanks.
 
P

Peter Jamieson

1. Which version of Word and Excel?

2. Is the workbook open or closed when you try to connect to it?

3. Is one sheet name like the other but with a "_" at the end? If so, try
using the one without the "_". otherwise, can you please state what the
sheet names are that you see when you select the sheet.
no filters applied, no print areas
Click to expand...

have you /ever/ applied any of these in this workbook?
 

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

Duplicate Mail Merge Record Every Time 5
Mail Merge Different Photos - Word 2013 Headache! 1
Set up and printing a 4-up mail merged postcard 0
Using mail merge to distinguish colours in Word 4
Publisher is filling blank lines with data 2
Mail Merge Makes One Page of One Name of One Label Instead 1
mail merge (word 2010) cuts off the text after 255 characters 1
Mail merge over 30 labels 1

Top