View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Conditional Formatting?

See your other thread - you cannot copy/paste fields.
You must use CTRL+F9 for each set of fields brackets.

--

Graham Mayor - Word MVP

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


JethroUK© wrote:
Hi

Thanks for that - I tried copy/pasting but i don't think i'm doing
right - it just stays as plain text - it doesn't even have the
right-click menu for fields: Update, Edit Toggle field codes

I've even tried pasting each parameter into the 'IF' wizard seperately


"macropod" wrote in message
...
Hi Jethro,

Try:
{IF{MERGEFIELD "CSCS_Test_DateTime" \@ YYYYMMDD} {DATE \@ YYYYMMDD}
{MERGEFIELD "CSCS_Test_DateTime" \@ "d MMM YYYY" \*Charformat}
{MERGEFIELD "CSCS_Test_DateTime" \@ "d MMM YYYY" \*Charformat}}
where you format the 'M' in the last two occurrences of 'MERGEFIELD'
as you want the output to appear. Change the "d MMM YYYY" strings to
match your preferred date format (eg "dddd, d MMM YYYY", "d/M/YY",
etc) Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"JethroUK©" wrote in message
...
I am using excel as a datasource and merging this to create some
appointments for some students

{MERGEFIELD "CSCS_Test_DateTime"}

I need to make the appointments pending very distinct from the
history (in RED maybe?)

Any way i can do this?

{IF {Mergefield "CSCS_Test_DateTime"} Now()