Reply
 
Thread Tools Display Modes
  #1   Report Post  
Johnc
 
Posts: n/a
Default How do I keep English date format when using mail merge?

When using Excel and Access as the data file and merging into Word the date
format changes from English to US. How can I stop this and retain the
English format?
  #2   Report Post  
MeDog
 
Posts: n/a
Default

{MERGEFIELD MYDATE \@ "dddd, dd MMMM yyyy"}


Insert the Merge Field and then edit it, show that is look like above


Regards,


John A

Melbourne , Australia

"Johnc" wrote in message
news
When using Excel and Access as the data file and merging into Word the
date
format changes from English to US. How can I stop this and retain the
English format?



  #3   Report Post  
Johnc
 
Posts: n/a
Default

Many thanks. It works a treat.

"MeDog" wrote:

{MERGEFIELD MYDATE \@ "dddd, dd MMMM yyyy"}


Insert the Merge Field and then edit it, show that is look like above


Regards,


John A

Melbourne , Australia

"Johnc" wrote in message
news
When using Excel and Access as the data file and merging into Word the
date
format changes from English to US. How can I stop this and retain the
English format?




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Bug in Word 2003 (mail merge & date format)? Joao Luis Rita Mailmerge 3 June 23rd 05 07:24 PM
Wrong mail merge date format sam Mailmerge 1 June 8th 05 01:23 PM
Mail Merge date format problem with Word 2003 Thang New Users 1 May 2nd 05 01:55 PM
Mail Merge - Date Format Kilinski Microsoft Word Help 0 December 7th 04 01:13 PM
Why does the date format change when I mail merge from Access? Alex Mailmerge 1 December 6th 04 02:25 PM


All times are GMT +1. The time now is 03:31 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"