Windows IT Pro is the leading independent community for IT professionals deploying Microsoft Windows server and client applications and technologies.
  
  
  Advanced Search 


Return to article

Capitalizing Surnames on Mail Merge Printouts
 

When I use the Tools, Mail Merge command from my Contacts folder in Microsoft Office Outlook 2003 to create file folder labels, the labels print out as "Smith, John." I'd like to capitalize just the surname, as in "SMITH, John." How can I do this?

The formatting needs to be part of the merge field code. Insert the fields from your contacts into the merge document as you typically would. Then, to see the field codes in Microsoft Word, click Tools, Options, and click the Field Codes box on the View tab. Edit the Last_Name field so that it looks like the following:

{MERGEFIELD "Last_Name" 

\* Upper \* MERGEFORMAT }

For more information about merging data from Outlook to Word, see "Performing a Mail Merge from the Contacts Folder," Exchange & Outlook Administrator, November 2005, InstantDoc ID 47697.
—Sue Mosher







Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro DevProConnections IT Job Hound
Left-Brain.com Technology Resource Directory asp.netPRO ITTV Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 © 2009 Penton Media, Inc. Terms of Use | Privacy Statement