Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to suppress autotext US date format after typing current year | Microsoft Word Help | |||
Mailmerge in Word, date format in merged doc | Mailmerge | |||
date format change when using serial printing | Microsoft Word Help | |||
Date issue merging from Excel field in Date format to Word | Mailmerge | |||
Mail Merge - Date Format | Microsoft Word Help |