Mail merge query re date formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yvonnepaterson@soundcontrol.co.uk - 23 Mar 2005 15:07 GMT

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)

Reply to this Message

Cindy M -WordMVP- - 24 Mar 2005 12:05 GMT

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
[quoted text clipped - 4 lines]
>
> 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 :-)

Reply to this Message