I tried what you suggested. This time I used the named fields in Excel, and
I got four merge fields. Ususally I just tell it entire spreadsheet. Still
need five because the City, State, zip didn't come across.
I have no hidden columns in my worksheets.

"Peter Jamieson" wrote:

Can you please try exporting the Excel data from one of the "non-working"
sheets and re-importing into a completely new sheet?

Do you have any hidden columns in the non-working sheets?


Peter Jamieson
"Bob Carlton" wrote in message
...
I have five columns in my Excel spreadsheet. Business name, owner, P.O.
Box,
Street address, and City, State, zip code. And I need to import all of
them
to my mailing labels. All my Excel sheets are set up the same way. But,
when I go to import the spreadsheet into mail merge, even if I select the
entire spreadsheet, sometimes it only allows 3 merge fields. I have tried
everything I can think of, but the problem pops up in 2 of my 4
spreadsheets.

"Bob Carlton" wrote:

The number of merge fields seems to vary. I need five merge fields, and
sometimes only 3 are available. If I go to a different excel document to
import, there may or may not be five fields available. How do I set word
so
that I have more merge fields available all the time.
--
bob carlton