Word won't honor caps command from Excel in merge

[Enzo Ferarri]

I have data in Excel that I downloaded. It is in all caps. I set up clone
columns and applied the '+proper(A22)' command to get the capitalization
correct. That worked fine. Unfortunately, when I bring it over to my
envelope in Word, it seems to have a nasty habit of forcing "ALL CAPS" on the
envelope. I can go in word by word and force 'Initial Caps', but it doesn't
save it, i.e., when I bring the document back up, it overrides with
'UPPERCASE'. Which is a command I never used. Word gremlins. I made it
work, finally, after recreating the envelope from scratch, but it's still not
right. I can't close the file and reopen it as I have to go back and refix
everything. Where is the 'uppercase' cram coming from?

 

[Bob Buckland ?:-\)]

Hi Enzo,

You may want to also post this in the Word Mailmerge/Fields
newsgroup(link below) and include the versions of Word and
Excel you are using.

=======
I have data in Excel that I downloaded. It is in all caps. I set up clone
columns and applied the '+proper(A22)' command to get the capitalization
correct. That worked fine. Unfortunately, when I bring it over to my
envelope in Word, it seems to have a nasty habit of forcing "ALL CAPS" on the
envelope. I can go in word by word and force 'Initial Caps', but it doesn't
save it, i.e., when I bring the document back up, it overrides with
'UPPERCASE'. Which is a command I never used. Word gremlins. I made it
work, finally, after recreating the envelope from scratch, but it's still not
right. I can't close the file and reopen it as I have to go back and refix
everything. Where is the 'uppercase' cram coming from? >>
--
LLet us know if this has helped you,

Bob Buckland ?
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends8

A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.word.mailmerge.fields
or via browser:
http://communities2.microsoft.com/c...us/?dg=microsoft.public.word.mailmerge.fields

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com