Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date Mail Merge
I have 5 date fields in a document, merged from Excel. I am using the same
date switch - { MERGEFIELD DOB_Child_2 \@ "d/M/yyyy" \* MERGEFORMAT } €“ for all 5. Two of the date fields merge correctly but the others are displayed as the Excel date code, e.g. 39128 (for 15/2/2007). This is reflected in the €śMail Merge Recipients€ť dialogue. The first two columns of dates in my list show correctly formatted dates e.g 8/9/1998 and 11/11/2001, but the third, fourth and fifth are 39128, 38225 and 38435 Ive checked my source data in Excel and, as far as I can tell, its all formatted correctly i.e. it is all displayed as dates, not codes. So where is the formatting being €ślost€ť? Can I manipulate the Mail Merge Recipients data? Many thanks for your help (This may be an Excel issue. If it is invalid to repost in the Excel discussion group if I do not find a solution here, please let me know.) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
c# mail merge only showing date fields in merge | Mailmerge | |||
Word converts English date to USA date in mail-merge from Excel? | Mailmerge | |||
Mail Merge Date Format | Microsoft Word Help | |||
mail merge date | Microsoft Word Help | |||
Mail Merge - Date Format | Microsoft Word Help |