Forum Discussion
Date formatting / Mail Merge
Hi everyone!
Does anyone know to keep the date format the same as in the source?
I'm mail merging from an excel list in which I have the date format set at dd/mm/yyyy,
however, when I preview results in Word, it will preview mm/dd/yyyy.
Is there any way around to fix that?
2 Replies
Amplifying Doug's correct answer:
In a mailmerge, Word pays no attention to the formatting in the source of the data.
You can modify your merge field in Word for the date with a picture switch.
\@ "dd/mm/yy"
The page Doug links gives more information.
- See "Formatting Word fields with switches" on Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm There is a section in that article on Mailmerge and Date Fields.
