If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mailmerge changing date format
Mailmerge keeps changing date format to American format. I can't get it to
keep to English. ie: 26/01/2005. Version 5.1.2600 Service Pack 2 Build 2600. Microsoft Windows XP Professional |
#2
|
|||
|
|||
Depending on your data source, you either have to:
a. use DDE to get your data from Access or Excel. If it's Word 2002 or later, check Word Tools|Options|General|"Confirm conversion at open", go through the ocnnection processagain and select the DDE option when offered. It only works for Excel or Access data sources and requires Excel or Access on your machine. b. use date formatting switches in Word, e.g. change { MERGEFIELD mydate } to { MERGEFIELD mydate \@"DD/MM/YYYY" } If that still doesn't work (in particular, if it works for non-ambiguous dates where the day number cannot be mistaken for a month, but not otherwise) it is because of a fault in the provider/driver that gets the data. You may be able to get a patch from Microsoft Customer Services (I don't know of one that can be downloaded). Peter Jamieson "Diane@Adlam" wrote in message news Mailmerge keeps changing date format to American format. I can't get it to keep to English. ie: 26/01/2005. Version 5.1.2600 Service Pack 2 Build 2600. Microsoft Windows XP Professional |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I keep the date from changing format in a mail merge? | Brynn Wilson | General Discussion | 2 | February 1st, 2007 05:19 PM |
How do I keep the date from changing format in a mail merge? | Brynn Wilson | General Discussion | 1 | June 9th, 2005 06:44 PM |
Query for 'confirmation' | rogge | Running & Setting Up Queries | 8 | April 19th, 2005 03:26 PM |
Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |
Does date fall between two ranges? | MR | Worksheet Functions | 4 | January 14th, 2004 04:08 PM |