Mail Merge Date fields

[Fi]

I have an excel datasource with dates formatted to show e.g. 5th June 2007.

However when I merge the datasource in Word and insert the date field it
shows as 06/05/2007.

I am using Office 2003 on XP. My regional settings are set to UK. Is this
common to set the date to American format. Is there a way to edit the mail
merge field format to show the correct date format?

 

[Peter Jamieson]

Is this

common to set the date to American format.

It is certainly what usually happens in this particular case.

In this case you should be able to change a mergefield such as

{ MERGEFIELD mydate }
to
{ MERGEFIELD mydate \@"DD/MM/YY" }

(use Alt-F9 to display the field codes so you can edit them. You can usually
reasonably safely delete "\*Mergeformat" if you see it)

I'd then verify that "ambiguous" dates where the day number is 12 or below
are not reversed.

Peter Jamieson