Go to the word document and select the field that you are using for the date.
RIght click on it to toggle the field codes. You probably see something
like this:
{ MERGEFIELD "DATE" }
Change it to
{ MERGEFIELD "DATE" \@ "MMMM d, yyyy" }
Right click on the field to toggle field codes again.
"Brynn Wilson" wrote:
I have a document in Word and a document in Excel that I am using in a mail
merge. When I merge the documents the format that I have the date in does not
stay the same. I want the date to show up like, June 9, 2005 and what it
comes up with is 6/9/2005. Is there anything I can do about this? The only
thing I have found is to merge and then change the date format but then I
can't get the date that I want, there are certain options that I have to pick
from. Any ideas?
|