Date formatting / Mail Merge

[MUSAAB_TAKRITI]

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]

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.

[#3]

@MUSAAB_TAKRITI 

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.