English Date Changing to American During Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Ward - 03 Oct 2003 12:58 GMT

When merging dates (in a UK format) from Excel, Word mail
merge changes the format to American during the process of
using the 'Merge Recipient List'.

Is there a way to stop this?

Reply to this Message

Cindy Meister -WordMVP- - 03 Oct 2003 14:41 GMT

This is essentially a bug in the OLEDB Providers Microsoft
provides, and Word 2002 uses by default.

See the Word 2002 information in the mail merge FAQ on my
website for how to use something other than OLEDB to
connect to your data.

Note that Microsoft has provided a hotfix for this that you
should be able to get by calling support. But I think it
was also included in the most recent SP (Service Pack) that
you should be able to download from microsoft.com

Cindy Meister

Signature

INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jan 24 2003)
http://www.mvps.org/word

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

Word Heretic - 03 Oct 2003 14:53 GMT

G'day "Michael Ward" <sailorboyward@aol.com>,

check yer language settings for the style and document.

"Michael Ward" <sailorboyward@aol.com> was spinning this yarn:

>When merging dates (in a UK format) from Excel, Word mail
>merge changes the format to American during the process of
>using the 'Merge Recipient List'.
>
>Is there a way to stop this?

Steve Hudson

Word Heretic, Sydney, Australia
Tricky stuff with Word or words for you.
Email steve@wordheretic.com
Products http://www.geocities.com/word_heretic/products.html

Replies offlist may require payment.

Reply to this Message

Suzanne S. Barnhill - 03 Oct 2003 16:13 GMT

If this is Word 2002, see
http://homepage.swissonline.ch/cindymeister/MM2002/MM2002.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)

Signature

Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> When merging dates (in a UK format) from Excel, Word mail
> merge changes the format to American during the process of
> using the 'Merge Recipient List'.
>
> Is there a way to stop this?

Reply to this Message