[JethroUK©]

Strange phenomena but that's cured it thanks


"Graham Mayor" wrote in message
...
From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then
when you attach the data source to the mail merge main document, you will
be given the option of using the DDE method of connection which should
read the data as you have it formatted in the table.

This should also fix your later problem.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




JethroUK© wrote:
I have now included the year:

Sat 20/Oct/2007 11:00 AM

And it is merged as:

Sun 20/Oct/2007 11:00 AM

?

Im in UK (probably the problem) Vista HP on my ol Office 2002




"JoAnn Paules" wrote in message
...
Are you sure it's looking at the correct year?

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375
"JethroUK©" wrote in message
...
I have a date/time field in excel formatted as:

Sat 20 Oct 11:00 AM


After merging to word with no formatting options it reads:

Sun 20 Oct 11:00 AM

?????