Change Case in Merge Carl Martin <carl.martin[ at ]angelo.edu> 11/13/2008 2:56:29 PM 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

Re: Change Case in Merge Peter Jamieson <pjj[ at ]KillMAPSpjjnet.demon.co.uk> 11/13/2008 5:14:49 PM 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: [Quoted Text] > 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 > >