Mail Merge Date Format

  • Thread starter sancell \(removethis\)
  • Start date
S

sancell \(removethis\)

When merging in Word with Access the date format is US
rather than UK how can I change this.
 
M

macropod

Hi Sancell,

You can fix this by adding a UK date format switch to the merge field, eg:
{MERGEFIELD AccessDate \@ "dddd, d MMMM yyyy"}, or
{MERGEFIELD AccessDate \@ ", d MMMM yyyy"}, or
{MERGEFIELD AccessDate \@ "d MMM yyyy"}, or
{MERGEFIELD AccessDate \@ "dd/MMM/yyyy"}, or
{MERGEFIELD AccessDate \@ "d-MM-yy"}
etc

Cheers
 
Top