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

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
769
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