Date formating in letters using Mail Merge


I use mailmerg in Microsoftword to format various letters. data is imported from an excel sheet and letters are formatted in Microsoftword. Now problem is just that when date is imported from excel to word through mailmerg it looks like "2/3/2010" instead of "03-Feb-10" or "February 03, 2010".

Can any one pls give me some solution on this?


To solve this, just follow the steps below:

  • Click on the date merged field on the document
  • Right click and click on toggle the field code
  • Then after the field name, add the formatting in this format \@"dd-MMM-yyyy" or whatever format you want


Thanks to rizvisa1 for this tip on the forum.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « Date formating in letters using Mail Merge », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (