Change Case in Merge

I get a new Excel workbook every week that contains names and addresses in
all upper case. How can I set the case to Proper when merging into Word
2008?

Do I have to write the formulas in Excel to convert to Proper case first,
then do the merge, or is it possible to force the case during the merge?

Thanks,

c~

Carl Martin
San Angelo, TX

If you use Alt-F9 to view your fields and see e.g.

{ MERGEFIELD myfield }

then strip out any \*Mergeformat in the field and insert \*Caps to give you

{ MERGEFIELD myfield \*Caps }


Peter Jamieson

http://tips.pjmsn.me.uk

Carl Martin wrote:
> I get a new Excel workbook every week that contains names and addresses in
> all upper case. How can I set the case to Proper when merging into Word
> 2008?
>
> Do I have to write the formulas in Excel to convert to Proper case first,
> then do the merge, or is it possible to force the case during the merge?
>
> Thanks,
>
> c~
>
> Carl Martin
> San Angelo, TX
>
>