There is a known problem here but only with some versions of Word
a. which version of Word? (can you provide the full version number from the
Help|About box?
b. you may be able to fix the problem using a "date format switch" in your
mail merge main document. Use Alt-F9 to display the underlying field codes
and if your date field is called mydate, Word will have something like
{ MERGEFIELD mydate \*Mergeformat }
type \@"DD/MM/YYYY" in there to give you
{ MERGEFIELD mydate \@"DD/MM/YYYY" \*Mergeformat }
and try again. Make really sure that ambiguous dates such as 05/06/2006 are
coming through the right way round
c. if that does not work, you may be able to work around by checking Word
Tools|Options|General|"Confirm conversion at open", then going through the
connection process again and selecting the DDE option when offered (NB, the
DDE method is obsolescent and doesn't pass through Unicode characters if you
happen to be using them). Again, be sure that ambiguous dates such as
05/06/2006 are coming through the right way round.
Peter Jamieson
> Hello, I am trying to sort out a problem for my sister, we live in the UK,
> and her regional settings are configured to display dates as British dates
[quoted text clipped - 6 lines]
>
> Any Ideas? Please?
Joe Black - 30 Jan 2007 12:19 GMT
Hi Peter I am having the same problem. can you please help. Word version
Office Pro 2003 Sp2. on Win Xp SP2.
> There is a known problem here but only with some versions of Word
> a. which version of Word? (can you provide the full version number from the
[quoted text clipped - 29 lines]
> >
> > Any Ideas? Please?
Peter Jamieson - 30 Jan 2007 12:52 GMT
If you've already tried using the formatting switches and that hasn't
worked, try working through the suggestions and links in the following
article (and adapt for the UK date sequence):
http://support.microsoft.com/kb/304387/en-us
Peter Jamieson
> Hi Peter I am having the same problem. can you please help. Word version
> Office Pro 2003 Sp2. on Win Xp SP2.
[quoted text clipped - 43 lines]
>> >
>> > Any Ideas? Please?
Doug Robbins - Word MVP - 30 Jan 2007 15:52 GMT
See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
> Hi Peter I am having the same problem. can you please help. Word version
> Office Pro 2003 Sp2. on Win Xp SP2.
[quoted text clipped - 43 lines]
>> >
>> > Any Ideas? Please?