Mail merge query re date formatting

[yvonnepaterson]

I am using Excel as the source document for a mail merge in Word. This
includes dates, but when merged they always appear in the American format of
month, date then year.
How do I get these in the European format of day, month & year.

I have tried reformatting the source document to no avail.

This did not happen in earlier versions of Word. (Using 2003 version)

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?eXZvbm5lcGF0ZXJzb25Ac291bmRjb250cm9sLmNvLnVr?=,

I am using Excel as the source document for a mail merge in Word. This
includes dates, but when merged they always appear in the American format of
month, date then year.
How do I get these in the European format of day, month & year.

I have tried reformatting the source document to no avail.

This did not happen in earlier versions of Word. (Using 2003 version)

You'll find information on this in the Word 2002/2003 section of my website's
mail merge FAQ. Basically, you need to either use the previous data connection
technology or add formatting switches to the merge fields.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail