Previous Topic Next Topic

Date formating in letters using Mailmerg

Solved/Closed
seekermay Posts 28 Registration date Wednesday 27 January 2010 Status Member Last seen 27 May 2013 - 3 Feb 2010 à 11:26
seekermay Posts 28 Registration date Wednesday 27 January 2010 Status Member Last seen 27 May 2013 - 8 Feb 2010 à 07:35
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 responses

Réponse 1 / 3
seekermay Posts 28 Registration date Wednesday 27 January 2010 Status Member Last seen 27 May 2013 5
8 Feb 2010 à 07:21
Can date be merged in this format like "February 03, 2010" or "January 03, 2010" or "March 03, 2010"???

Regards...seekermay
Réponse 2 / 3
seekermay Posts 28 Registration date Wednesday 27 January 2010 Status Member Last seen 27 May 2013 5
8 Feb 2010 à 07:35
got it. following format code will resolve my problem.
\@"MMMM dd, yyyy"
Réponse 3 / 3
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
3 Feb 2010 à 12:28
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