Graham
I struggled with this problam until well after midnight this morning -
then posted to this NG and went to bed. Got up this morning to find
that two kind people, I assume in a quite different time zones, have
responded. Thanks to you and Peter Jamieson. You pointed me to a
number of URLs and I have now solved the problem. I have installed
Office XP SP3 and it now works well. That is a fix I needed.
On Tue, 24 Jan 2006 16:39:30 +0200, "Graham Mayor"
wrote:
Three possibilities:
1. See if the addition of a date switch will fix it eg {Mergefield
datefieldname \@ "d MMM yyyy"} (for more on switches - see
http://www.gmayor.com/formatting_word_fields.htm )
2. Connect to the Excel file using the DDE connection method - see the Excel
data section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm
3. There's some information about misread dates on Cindy's web site at
http://homepage.swissonline.ch/cindymeister
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
George Mathew wrote:
I am using MS Word 2002 and MS Excel 2002. My control panel Regional
& Language settings has the date format set d MMM yy. I am having
trouble merging date fields from the worksheet into a Word Document.
Other threads on a similar subject relate to formatting of the output.
My problem is that in some instances the data coming across from the
worksheet is being currupted, by being read as American format and
displaying as the wrong date. The date 11 01 2005 in the worksheet
comes across to the Word document as 1 November 2005 (it should be 11
January 2005) and I can display that November date in any one of
several formats using different date pictures but it will not display
as a January date. Interestingly, the date 17 01 2005 displays in
Word as a 17 January 2005 (correctly) because, it seems, it knows
there are only 12 months in a year so the 17 must be the day and the
other numer the month, I can actually solve the problem by changing
my regional date setting to MMM dd yyyy but then my whole computer is
set up using a format that is quite alien to me. Can anyone help me
to force the data to be read correctly.