Date Format with Word 2007 mail merge

Discussion in 'Software' started by mike142sl, Jun 24, 2010.

  1. mike142sl

    mike142sl

    Joined:
    Dec 17, 2009
    Messages:
    49
    I'm having trouble displaying dates as per the windows regional settings i have set on my laptop when I use mail merge.

    I'm set up as per UK settings so when using every programme inc Outlook, Excel, Word, dates display as DD/MM/YYYY, however when ever I merge dates into a Word doc they display as MM/DD/YYYY

    Does anyone know how I can get this to display as per my regional setting?

    Thanks

    Mike
    mike142sl, Jun 24, 2010
    #1
  2. mike142sl

    TrainableMan ^ The World's First ^ Moderator

    Joined:
    May 10, 2010
    Messages:
    7,680
    Location:
    PA, USA
    I found this from on the web from 2004 regarding the date issue ...
    http://happyelearning.websitetoolbox.com/post?id=225477
    I am not familiar with mail merge myself so this may be worthless to you but as it hasn't gotten any replies I offer that your solution may be similar except you would probably use [FONT=Verdana, Arial, Helvetica, sans-serif]"date" \@"dd/mm/yyyy"[/FONT]
    TrainableMan, Jul 15, 2010
    #2
    mike142sl likes this.
  3. mike142sl

    mike142sl

    Joined:
    Dec 17, 2009
    Messages:
    49
    Thanks

    Thanks TrainableMan, that is the answer. I've just made the change in my document and it works. (I'm using Office 2007)

    To complete this thread for anyone else who has found it the solution is:
    1. All you need to do is add some extra code to change the formatting. Presuming your original table field is called 'Date', the merge field will currently be {MERGEFIELD "date"}
    2. To change the mailmerge date field format you need to change the relavent merge field by changing the view to show the field codes.
    3. To do this right click on the merge field and select toggle field codes.
    4. You need to add the following formatting data \@"dd MMMM yyyy"
    5. So your field will now look like this {MERGEFIELD "date"\@"dd MMMM yyyy"}
    6. Note: you may need to add " marks before and after the table field as well and the code is case sensitive, so putting mmmm will not work.
    7. Right click the file again to revert to the field name view. When you preview the document you will see that dates are now formatted in the long date format.
    Hope it helps
    mike142sl, Jul 15, 2010
    #3
    TrainableMan and Kalario like this.
  4. mike142sl

    mike142sl

    Joined:
    Dec 17, 2009
    Messages:
    49
    mike142sl, Jul 16, 2010
    #4
    TrainableMan likes this.
  5. mike142sl

    Lucky101

    Joined:
    Oct 15, 2012
    Messages:
    1
    Unfortunately this doesn't work if the original date is not in American format!
    I have already tried this on raw data for the October date of 07-10-12 and Word converts this into 10 July 2012. Any ideas how to fix this? Windows is set with the UK date format and Word default language is set as English (United Kingdom).
    Last edited: Oct 15, 2012
    Lucky101, Oct 15, 2012
    #5
  6. mike142sl

    theivanka

    Joined:
    Mar 20, 2013
    Messages:
    1

    I have managed to use the appropriate raw data format by following your instructions and using the preserve format across updates options. So, my merged field looks like this:
    MERGEFIELD date \@ "dd.MM.yyyy" * MERGEFORMAT


    Prediction is very difficult, especially if it's about the future. Niels Bohr[/SIZE]
    theivanka, Mar 20, 2013
    #6

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. mike142sl

    Word 2007 - save as PDF add on

    mike142sl, Jan 7, 2010, in forum: Software
    Replies:
    0
    Views:
    1,672
    mike142sl
    Jan 7, 2010
  2. g0jwe

    Mail Merge

    g0jwe, Jan 23, 2010, in forum: Windows 7 Support
    Replies:
    0
    Views:
    1,057
    g0jwe
    Jan 23, 2010
  3. tripwire45

    Word 2007 stops working

    tripwire45, Feb 11, 2010, in forum: Software
    Replies:
    2
    Views:
    1,188
    DallasDad
    Feb 11, 2010
  4. Rose

    Window 7 with Word 2007

    Rose, Apr 4, 2010, in forum: General Discussion
    Replies:
    2
    Views:
    830
  5. Mitch Bujard
    Replies:
    1
    Views:
    223
    Mitch Bujard
    Jul 9, 2013
Loading...

Share This Page