Windows 7 Forums


Reply
Thread Tools

Date Format with Word 2007 mail merge

 
 
mike142sl mike142sl is offline
Member
Join Date: Dec 2009
Posts: 46
Thanked: 2
 
      06-24-2010
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
 
Reply With Quote
 
 
 
 
TrainableMan TrainableMan is offline
^ The World's First ^
TrainableMan's Avatar
Join Date: May 2010
Location: PA, USA
Posts: 4,654
Thanked: 887
 
      07-15-2010
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 "date" \@"dd/mm/yyyy"
 
Reply With Quote
 
mike142sl mike142sl is offline
Member
Join Date: Dec 2009
Posts: 46
Thanked: 2
 
      07-15-2010
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
 
Reply With Quote
 
mike142sl mike142sl is offline
Member
Join Date: Dec 2009
Posts: 46
Thanked: 2
 
      07-16-2010
Now that I know what I've been looking for, I've also found this page which gives info about other options for changing Field Switches

http://www.gmayor.com/formatting_word_fields.htm
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Window 7 with Word 2007 Rose General Discussion 2 04-05-2010 01:46 AM
word 2007 stopped working after opening any menu krispeq Software 2 02-11-2010 01:24 PM
Word 2007 stops working tripwire45 Software 2 02-11-2010 06:04 AM
Mail Merge g0jwe Windows 7 Support 0 01-23-2010 01:17 PM
Word 2007 - save as PDF add on mike142sl Software 0 01-07-2010 12:58 PM


All times are GMT +1. The time now is 06:09 AM.
W7Forums is an independent website and is not affiliated with Microsoft Corporation.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33