Changing the Date Format of a Merge Field in Mail Merge

Here are a few examples of different date formats that you can use in the Mail Merge Master Template.

The Date format switch (@) specifies the display of a date. Press Alt + F9 to
display and edit the merge codes.

For example, if using the Master Template you would change the current field { MERGEFIELD Merge_Date } which, by default, is formatted as MM/dd/yyyy and displayed as 01/01/2010 to { MERGEFIELD Merge_Date \@ "dddd, MMMM d, yyyy" } the display would be Monday, January 1, 2010.

Another example would be { MERGEFIELD Merge_Date \@ "MMM. d, yyyy" } which would display as Jan. 1, 2010.

Below is an explanation of how you could create even more formats. This information can be accessed through the help link in Microsoft Word by entering "format fields" as the search criteria and then selecting "Insert and format field codes."

The letter M must be uppercase to distinguish months from minutes.

  • M - This format item displays the month as a number without a leading 0 (zero) for single-digit months. For example, January is 1.
  • MM - This format item displays the month as a number with a leading 0 (zero) for single-digit months. For example, January is 01.
  • MMM - This format item displays the month as a three-letter abbreviation.
    For example, January is Jan.
  • MMMM - This format item displays the month as its full name.

The letter d displays the day of the month or the day of the week. The letter d can be either uppercase or lowercase.

  • d - This format item displays the day of the week or month as a number without a leading 0 (zero) for single-digit days. For example, the sixth day of the month is displayed as 6.
  • dd - This format item displays the day of the week or month as a number with a leading 0 (zero) for single-digit days. For example, the sixth day of the month is displayed as 06.
  • ddd - This format item displays the day of the week or month as a three-letter abbreviation. For example, Tuesday is displayed as Tue.
  • dddd - This format item displays the day of the week as its full name.

The letter y displays the year as two or four digits. The letter y can be either uppercase or lowercase.

  • yy - This format item displays the year as two digits with a leading 0 (zero) for years 01 through 09. For example, 1999 is displayed as 99, and 2006 is displayed as 06.
  • yyyy - This format item displays the year as four digits.

Was this article helpful?