Forum Discussion
MUSAAB_TAKRITI
Mar 19, 2023Copper Contributor
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 previe...
Charles_Kenyon
Mar 20, 2023Bronze Contributor
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.