[Andy Roberts]

Peter this is exactly what I needed once I managed to get my head around
it - thank you ever so much

Can I have the merge field display blank when the data source contains a
specific text string. Looking through the information you pointed me to it
seems I can add additional text information etc but there is no example
where for example I have dates in my data source but for some reason a date
value isnt applicable so we input N/A. This then comes through on the mail
merge, but can I set a switch which means that if the Date_required field
contains N/A then nothing is displayed?

--
Regards

Andy

Andy Roberts
Win XP, Office 2007
"Peter Jamieson" wrote in message
...
macropod has an example of this in his Word Date Calculation Tutorial, at:
http://lounge.windowssecrets.com/ind...owtopic=249902
or
http://www.gmayor.com/downloads.htm#Third_party

(He generally says "Do read the document's introductory material.")

Last time I looked the example was titled

"Insert A Date with Ordinal Numbering"

Peter Jamieson

http://tips.pjmsn.me.uk

On 25/03/2010 08:43, Andy Roberts wrote:
This may not be possible very easily.

I have a sentence in a mail merge doc which reads "Thank you for your
letter
dated 21st August 2009..." with the date being a mail merge field from
Excel.

The format of the mail merge field is {MERGEFIELD Date Required\@"DD MMMM
YYYY"}which gives me 21 August 2010. Is it possible to :-

1. Have the "st" or "th" inserted after the day (i.e 21st or 19th)
2. Have it appear super script like it does if it is typed in word.