Date formating in letters using Mailmerg

Solved/Closed
seekermay Posts 28 Registration date Wednesday January 27, 2010 Status Member Last seen May 27, 2013 - Feb 3, 2010 at 11:26 AM
seekermay Posts 28 Registration date Wednesday January 27, 2010 Status Member Last seen May 27, 2013 - Feb 8, 2010 at 07:35 AM
Hello,
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 slolution on this.

Regards....seekermay
Related:

3 replies

seekermay Posts 28 Registration date Wednesday January 27, 2010 Status Member Last seen May 27, 2013 5
Feb 8, 2010 at 07:21 AM
Can date be merged in this format like "February 03, 2010" or "January 03, 2010" or "March 03, 2010"???

Regards...seekermay
0
seekermay Posts 28 Registration date Wednesday January 27, 2010 Status Member Last seen May 27, 2013 5
Feb 8, 2010 at 07:35 AM
got it. following format code will resolve my problem.
\@"MMMM dd, yyyy"
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 3, 2010 at 12:28 PM
click on the date merged field on the document
then right click and click on toggle the field code
then after the field name, add the formatting in this format \@"dd-MMM-yyyy" or what ever format you want
-1