How do I keep the date from changing format in a mail merge?
 

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?

use a date switch in Word. See "Date-Time Picture (\@) field switch" in
Word Help.

For instance, if the XL field is named MyDate,

{ MERGEFIELD MyDate \@ "MMMM d, yyyy" }

In article ,
Brynn Wilson <Brynn 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?

How do I keep the date from changing format in a mail merge?
 

Finally.
Thanks for gicing me this merge date solution.
I'vebeen trying to merge Swedish dates frm Engling Excel into English Word,
and the dates have been formated in US style, not Swedish.
Thanks to you, I now got it right.
Thanks a lot
/Kia

"JE McGimpsey" skrev:

use a date switch in Word. See "Date-Time Picture (\@) field switch" in
Word Help.

For instance, if the XL field is named MyDate,

{ MERGEFIELD MyDate \@ "MMMM d, yyyy" }

In article ,
Brynn Wilson <Brynn 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?