A few words of thanks would be greatly appreciated.

Date formating in letters using Mail Merge

Latest update on February 3, 2010 at 03:24 PM by aakai1056 .

Issue
Solution
Note

Issue

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?

Solution

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

Note

Thanks to rizvisa1 for this tip on the forum.

Date formating in letters using Mail Merge
Mail merge date format dd/mm/yyyy - How-To - Excel
Thunderbird mail merge - How-To - Thunderbird
Date formating in letters using Mailmerg ✓ - Forum - Office Software
Conditional formatting merged cells ✓ - Forum - Excel
Letter dispatch register format in excel free download - Forum - Office Software

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 (ccm.net).

Word documents automatically save as Open Office format

Convert MS forms into tab-delimited text files

Issue

Solution

Note

Subscribe To Our Newsletter!