Wrong Date Format in Mail Merged Word Document

You set the date in the excel file to a certain format say DD-MM-YYYY but when you finished mail merging with word document the date format becomes something else. How do you fix this problem to make sure the mail merge document has the same date format as the data in the excel file?

Date formatting in Excel is a property of the cell containing the date value, not a property of the data itself. To have it render the way you want it, right-click the date field in your Word main document & select Edit Field. Click the Field Codes button, then add the following mask at the end of the MERGEFIELD [field_name]:

\@ “d-mm-yyyy”