Mailmerge date fault!!!

[Dewi...]

Hello

I have recently notice an annoying fault or feature

When I do a merge from Excel to Word, the date seems to be have been
changed to mmddyy and not the ddmmyy I want.

I'm using Word and Excel 2003
PC is set to Uk with the date format correct
Excel date column is formatted to show ddmmyy
Word language is set to UK

Any pointers?

Thanks

 

[Dave Peterson]

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"ddmmyy")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg>.)

 

[Dewi...]

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
   http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx


- Show quoted text -

The article nearly got me there...


The code looks like this {mergefield "DoB" \@ "dd/mm/yy"} but the
month shows as 00 in Word. Day and Year is correct(25/00/73)

any pointers?

:-(

 

[Dave Peterson]

I don't use this enough to help debug the problem.

If you don't get a response here, you can try asking in an MSWord newsgroup.