YYYY-MM-DD from Access is converted into DD-MM-YYYY in MailMerge doc

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J.Fandango - 25 Jun 2004 17:42 GMT

Hi!
When MailMerging a document from Access table, and Access
colum DATE is yyyy-mm-dd, as well as the Regional Settings
on My Computer, the same field is format inverted when in a
MailMerge document, such as dd-mm-yyyy.

I'd like to keep the same format at destination as the
source one.

What am i missing?

Thanks for any help.

Cheers,
J.F.

Reply to this Message

Cindy M -WordMVP- - 26 Jun 2004 15:02 GMT

Hi J.Fandango,

> When MailMerging a document from Access table, and Access
> colum DATE is yyyy-mm-dd, as well as the Regional Settings
[quoted text clipped - 5 lines]
>
> What am i missing?

Which version of Word are we dealing with?

I suspect this is due to the connection method (2002 or 2003
with OLE DB would be my best guess). This means you'll either
need to
- change to a DDE connection
- add a formatting switch to the merge field
- use a query in Access, with the FORMAT function, to
pass a literal string to Word

You'll find more information in the Mail Merge FAQ section of
my website.

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

J.Fandango - 26 Jun 2004 15:59 GMT

Thanks for your help, Cindy.
I'll have a look on it.
Cheers,
JF

>-----Original Message-----
>Hi J.Fandango,
[quoted text clipped - 32 lines]
>
>.

Reply to this Message