Capitalizing Surnames on Mail Merge Printouts
Learn how to use the mail merge field code to capitalize surnames in merged documents.
August 28, 2006
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
About the Author
You May Also Like