Mail merge date

[Anna Churchill]

I have a letter that includes a merge field
called "meeting date." I am merging from an Excel file.
I formatted the dates in Excel so that the month is
spelled out, for example, "May 15, 2003." When I merge
into Word, the date is shown as "5/15/03." In Word, I
went to Insert Date/Time and set the default to "May 15,
2003" but it still merges wrong. Please help!

 

[macropod]

Hi Anna,

In your word document, change the "meeting date"
mergefield by adding the required date switch, eg:
{mergefield meeting_date \@ "MMMM d, yyyy}

Cheers