Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Peter is offline
external usenet poster
 
Posts: 111
Default format capitals in a merge field

I have a merge field drawing on a data source where the data is all in
capitals. I changed it to lower case using the \* Lower switch. But I need
the final result to be in title case, and \* Caps doesn't seem to produce
Title case when the data source is already fully capitalised. Is there
another format switch I could use? or perhaps a way of nesting the field so
it changes to lower case then to title case?

Thanks, Peter.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default format capitals in a merge field

Using the \* Caps switch alone will convert upper case text to Title Case.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Peter" wrote in message
...
I have a merge field drawing on a data source where the data is all in
capitals. I changed it to lower case using the \* Lower switch. But I
need
the final result to be in title case, and \* Caps doesn't seem to produce
Title case when the data source is already fully capitalised. Is there
another format switch I could use? or perhaps a way of nesting the field
so
it changes to lower case then to title case?

Thanks, Peter.


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Peter is offline
external usenet poster
 
Posts: 111
Default format capitals in a merge field

Aha...
For reasons that escape me, that option failed yesterday but works today
(which is a better result than the other way round).
Thanks for your help.

Peter.

"Doug Robbins - Word MVP" wrote:

Using the \* Caps switch alone will convert upper case text to Title Case.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Peter" wrote in message
...
I have a merge field drawing on a data source where the data is all in
capitals. I changed it to lower case using the \* Lower switch. But I
need
the final result to be in title case, and \* Caps doesn't seem to produce
Title case when the data source is already fully capitalised. Is there
another format switch I could use? or perhaps a way of nesting the field
so
it changes to lower case then to title case?

Thanks, Peter.


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I format a merge field to display the correct Time format KHaberwoman Mailmerge 2 May 11th 23 02:49 PM
Format Merge Field C Huff[_2_] Microsoft Word Help 2 February 10th 10 03:09 AM
format a % field in a mail merge Kevin Mailmerge 1 December 5th 07 12:25 AM
How do I format a merge field as Currency or %? hmj3b5 Mailmerge 1 February 22nd 05 08:07 AM
How merge a field with RTF format 1961JCAP Mailmerge 1 December 1st 04 02:30 PM


All times are GMT +1. The time now is 04:49 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"