label headings

[Susan_10]

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

I've also posted same question to Excel
I have used PC based Word/Excel in combination to publish our subdivisions address list using the mail merge/labels system minus actual labels.
Trying this same procedure using my new Mac and Office for Mac, I do not get all the headings I have in my spreadsheet carrying over to Word, I also have additional headings I have not created. I reread the directions, followed them exactly both using the default "use entire spreadsheet" and defining the cells (a1-n98) and it never works.
Why not and what can I do?

 

[John McGhie]

The only thing I can think of is that your column names do not match your
merge field names. Check for invisible spaces...

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

I've also posted same question to Excel
I have used PC based Word/Excel in combination to publish our subdivisions
address list using the mail merge/labels system minus actual labels.
Trying this same procedure using my new Mac and Office for Mac, I do not get
all the headings I have in my spreadsheet carrying over to Word, I also have
additional headings I have not created. I reread the directions, followed them
exactly both using the default "use entire spreadsheet" and defining the cells
(a1-n98) and it never works.
Why not and what can I do?

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Sydney, Australia. mailto:[email protected]

 

[John McGhie]

Life is too short to waste any of it on idiots who sign themselves
"lockerroom lesbians"

I'm confused. When I've done this before Word checks the column names in Excel
and uses them. This time it only goes so far, then makes up some and leaves
off quite a few. How would I know if there were invisible spaces?
On Nov 16, 2008, at 9:06 PM, John McGhie wrote:

The only thing I can think of is that your column names do not match
your
merge field names. Check for invisible spaces...







posted same question to Excel > I have used PC based Word/Excel in
combination
to publish our subdivisions > address list using the mail merge/labels
system minus actual labels. > Trying this same procedure using my new
Mac and Office for Mac, I do not get > all the headings I have in my
spreadsheet
carrying over to Word, I also have > additional headings I have not
created.
I reread the directions, followed them > exactly both using the default
"use entire spreadsheet" and defining the cells > (a1-n98) and it never
works. > Why not and what can I do?





-- Don't wait for your answer, click here: <http://www.word.mvps.org/>





Please reply in the group. Please do NOT email me unless I ask you to.





John McGhie, Microsoft MVP, Word and Word:Mac Sydney, Australia.
mailto:[email protected]

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Sydney, Australia. mailto:[email protected]

 

[Susan_10]

I'm the one with the question, not "locker room lesbian" so perhaps you could waste your time after all. I still don't understand why Word decides what my merge fields will be. As I said before, perviously Word used the column headings from the source excel worksheet. This time it consistently choses some the same, makes some up, and omits many.
I've used Word's mail merge manager for years (PC based) doing the very same task I'm trying to do with this Mac version. It always used the column headings I put into Excel before. I also have no idea of where to "check for invisible spaces". I've never had any before and don't believe I do now either.

 

[John McGhie]

Sadly, I don't have much to add, even though you are not a locker room
lesbian, whatever that may be.

Given your experience with this mechanism, it is not likely that you are
making any of the usual mistakes, such as spaces in field names.

So I can only assume that either your main document or your spreadsheet is
corrupt and Word is not reading the internal code correctly.

Since it is very rare for an Excel spreadsheet to corrupt, my first thought
would be to "Maggie" the main document:

The Maggie:

1. Create a new blank document
2. Carefully select all of the text in the bad document EXCEPT the last
paragraph mark
3. Copy it.
4. Paste in the new document.
5. Save under a new file name and close all, then re-open.

This technique for de-corrupting is known as "Doing a 'Maggie'", after
Margaret Secara from the TECHWR-L mailing list, who first publicised the
technique.

Hope this helps

I'm the one with the question, not "locker room lesbian" so perhaps you could
waste your time after all. I still don't understand why Word decides what my
merge fields will be. As I said before, perviously Word used the column
headings from the source excel worksheet. This time it consistently choses
some the same, makes some up, and omits many.
I've used Word's mail merge manager for years (PC based) doing the very
same task I'm trying to do with this Mac version. It always used the column
headings I put into Excel before. I also have no idea of where to "check for
invisible spaces". I've never had any before and don't believe I do now
either.

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Sydney, Australia. mailto:[email protected]