Labels in Word from Excel spreadsheet do not contain all headings

[Susan_10]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I have for years used my PC based Word & Excel in combination to create an address book for our subdivision using the labels system but including many more headings than traditionally appear in a label.
Using Office for Mac I only get some of the headings and some that are not even in my spreadsheet (like alternate phone, p, a, etc.).
I have tried choosing entire worksheet and even defined specific cells (a1:n98), still the same headings that do not make sense.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I have for years used my PC based Word & Excel in combination to create an
address book for our subdivision using the labels system but including many
more headings than traditionally appear in a label.
Using Office for Mac I only get some of the headings and some that are not
even in my spreadsheet (like alternate phone, p, a, etc.).
I have tried choosing entire worksheet and even defined specific cells
(a1:n98), still the same headings that do not make sense.

Are you using the Mail Merge manager in Word? If so, what fields are you
seeing there?

 

[Susan_10]

In Excel, column headings are: Last name, First name, Street address, Phone, Lot, mail address, Email,
Child 1, Service 1, Child 2, Service 2, Child 3, Service 3
I used the Mail Merge manager in Word, but available headings were not a match with Excel column headings. My choices for setting up the labels became: Last name, First name, Street address, Street name, phone, p1, alt. phone, lot, alt. mailing address, A, and A1.
I went back, redid all the column headings, just because I couldn't think of any reason for the discrepancy but someone in my Word question suggested I might have "invisible" something causing the problem. I got exactly the same choices.

 

[JE McGimpsey]

In Excel, column headings are: Last name, First name, Street address, Phone,
Lot, mail address, Email,
Child 1, Service 1, Child 2, Service 2, Child 3, Service 3
I used the Mail Merge manager in Word, but available headings were not a
match with Excel column headings. My choices for setting up the labels
became: Last name, First name, Street address, Street name, phone, p1, alt.
phone, lot, alt. mailing address, A, and A1.
I went back, redid all the column headings, just because I couldn't think of
any reason for the discrepancy but someone in my Word question suggested I
might have "invisible" something causing the problem. I got exactly the same
choices.

Sounds like Row 1 in your spreadsheet is hidden.