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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASK Field Formatting 1
Anchor issue with inserting a shape for letterhead 1
Mail Merge skipping records/sending one at a time 0
Width of document changes when merging 1
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Merging from an Excel file with graphics 1
Windows 2016- Unable to do mail merge with my secondary email accounts 1
Mail Merge Directory Conditional Page Break 0

Top