Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / July 2004

Tip: Looking for answers? Try searching our database.

Change Case during Mail Merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Diane OConnor - 07 Jul 2004 21:32 GMT
I'm downloading a file from the AS/400 which has the
customer's name and address in CAPS.  I need to merge this
into a Word document but I want to change the case--  Is
there a way to do this?  Thanks, Diane
Doug Robbins - 08 Jul 2004 01:10 GMT
Use Alt+F9 to toggle on the field codes in the mailmerge main document and
add a \* Caps switch inside the closing }

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested.   Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> I'm downloading a file from the AS/400 which has the
> customer's name and address in CAPS.  I need to merge this
> into a Word document but I want to change the case--  Is
> there a way to do this?  Thanks, Diane
Graham Mayor - 08 Jul 2004 11:52 GMT
You should be able to achieve what you want with a \*Caps formatting switch
on the mergefield(s)

eg {Mergefield Address1 \*Caps}

This will capitalize the first letter of each Word. There are other
formatting switches - see Word help.
and for more complex options - see
http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I'm downloading a file from the AS/400 which has the
> customer's name and address in CAPS.  I need to merge this
> into a Word document but I want to change the case--  Is
> there a way to do this?  Thanks, Diane
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.