Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
how to get english date formats when mailmerging from excel?
I am using Office 2007 and mailmerging data from an Excel source. The date
fields are NOT being shown in English format - how can I solve this? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
how to get english date formats when mailmerging from excel?
Hi David,
To get the date format you want, you can add a formatting picture switch. In Word: .. 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'. Other possible date formatting switches include: . \@ "dddd, d MMMM yyyy"; . \@ "ddd, d MMMM yyyy"; . \@ "d MMM yyyy"; . \@ "dd/MMM/yyyy"; . \@ "d-MM-yy"; Note: Note: you can swap the d, M, y expressions around, but you must use uppercase 'M's for months. .. position the cursor anywhere in this field and press F9 to update it; .. run your mailmerge. -- Cheers macropod [Microsoft MVP - Word] "DAvid-R" wrote in message ... I am using Office 2007 and mailmerging data from an Excel source. The date fields are NOT being shown in English format - how can I solve this? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word converts English date to USA date in mail-merge from Excel? | Mailmerge | |||
Date format in Word 2003 mailmerging from excel file. | Mailmerge | |||
How can I maintain Excel date formats in a mail merge? | Mailmerge | |||
Excel serial date formats | Mailmerge | |||
Wd '03-Date formats from Excel changed | Mailmerge |