Microsoft Office Forums Change Mail Merge Date Format from US to UK

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-06-2013, 06:03 AM
Evanaught Evanaught is offline Change Mail Merge Date Format from US to UK Windows XP Change Mail Merge Date Format from US to UK Office 2010 64bit
Novice
Change Mail Merge Date Format from US to UK
 
Join Date: Sep 2013
Posts: 1
Evanaught is on a distinguished road
Question Change Mail Merge Date Format from US to UK

Hi,



When I merge the data source with the document, the date format changes from UK format: 25/01/1984 (as it is entered in the Excel data source), to the US format: 01/25/1984, when it appears in the document. It's a big problem, as I'm creating multiple documents and I can't keep manually changing it everytime I need to. Very time consuming!

Is it possible to change the format?? I've tried just about everything (or so I think...)

Your help would be much appreciated

Evan
Reply With Quote
  #2  
Old 09-29-2013, 08:02 PM
macropod's Avatar
macropod macropod is offline Change Mail Merge Date Format from US to UK Windows 7 32bit Change Mail Merge Date Format from US to UK Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,675
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

To get the date format you want, you can add a formatting picture switch as follows:
• select the mergefield;
• press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD MyDate} where 'MyDate' is your mergefield's name;
• delete anything appearing after the mergefield's name and add '\@ "d MMMM yyyy"' to the field, as in {MERGEFIELD MyDate \@ "d MMMM yyyy"}. With this switch your date will come out as '2 August 2008'.
• position the cursor anywhere in this field and press F9 to update it;
• run your mailmerge.

Other possible date formatting switches include:
. \@ "dddd, d MMMM yyyy";
. \@ "ddd, d MMMM yyyy";
. \@ "d MMM yyyy";
. \@ "dd/MMM/yyyy";
. \@ "d-MM-yy".
Note: You can swap the d, M, y expressions around, but you must use uppercase 'M's for months - lowercase 'm's are for minutes.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Tags
mail merge date format

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Mail Merge Date Format from US to UK mail merge treating CITY as DATE woody Mail Merge 6 01-30-2013 03:22 PM
Issue with date format in mail merge document walshjod Mail Merge 4 11-28-2012 04:46 AM
Change format of date when using Now function in VB code Bondai Excel Programming 2 03-02-2012 05:09 PM
Change Mail Merge Date Format from US to UK Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
Change Mail Merge Date Format from US to UK Date not transfering to mail merge correctly tonywatsonmail Mail Merge 1 07-01-2011 05:30 AM


All times are GMT -7. The time now is 05:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft