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 / March 2005

Tip: Looking for answers? Try searching our database.

Change Case (Title Case)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kbreiss - 15 Mar 2005 23:23 GMT
I have changed my mail merge fields to "Title Case" since all my data is
comming in from the DB in all caps.  I save my changes of "Title Case", but
when I merge my data to the document it reverts back to all upper case (the
way it came from the database) Is there anyway to correct this so my merged
fields are in "Title Case"  Thanks in advance,

Kacy
Graham Mayor - 16 Mar 2005 09:18 GMT
You need a formatting switch on the field eg

{Mergefield fieldname \*Caps}

\* Caps
The first letter of each word. For example, { FILLIN "Type your name:" \*
Caps } displays "Julie Tanner" even if the name is typed in lowercase
letters.
\* FirstCap
The first letter of the first word. For example, { COMMENTS \* FirstCap }
displays "Weekly report on sales".

Signature

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

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

> I have changed my mail merge fields to "Title Case" since all my data
> is comming in from the DB in all caps.  I save my changes of "Title
[quoted text clipped - 4 lines]
>
> Kacy
kbreiss - 16 Mar 2005 22:33 GMT
Thanks Graham Mayor...that is exactly what I was needing.
Thanks Again!

> You need a formatting switch on the field eg
>
[quoted text clipped - 16 lines]
> >
> > Kacy
Graham Mayor - 17 Mar 2005 09:05 GMT
You are welcome :)

Signature

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

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

> Thanks Graham Mayor...that is exactly what I was needing.
> Thanks Again!
[quoted text clipped - 27 lines]
>>>
>>> Kacy
 
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.