Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
incorrect date format in mail merge
Date appears OK in Access table ( 15 Jun 2005)but appears incorrectly in word
doc. (6/15/2005) Regional settings are OK Help please! |
#2
|
|||
|
|||
Hi Mark,
You can solve this by adding a date switch to your MERGEFIELD. If you select the field and press Shift-F9, you'll see something like: {MERGEFIELD AccessDate} If you add: \@ "dddd, d MMMM yyyy" to this so that you have: {MERGEFIELD AccessDate \@ "dddd, d MMMM yyyy"} and press F9, your dates will output like 'Monday, 1 January 2001'. Other date switch formats you might like to experiment with include: \@ "d MMMM yyyy" \@ "d-MMM-yyyy" \@ "dd/MM/yyyy" \@ "d/MM/yy" and so on. Cheers "mark P" mark wrote in message ... Date appears OK in Access table ( 15 Jun 2005)but appears incorrectly in word doc. (6/15/2005) Regional settings are OK Help please! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I edit the format of a mail merge field after it has been. | Mailmerge | |||
Mail Merge Zip Code will not format correctly | Mailmerge | |||
Mail Merge - Date Format | Microsoft Word Help | |||
Why does the date format change when I mail merge from Access? | Mailmerge | |||
mail merge using excel spread looses the format for social securit | Mailmerge |