Date format in Merge field

[Roy Challen]

Thank you in advance for all help supplied.

I am in the UK. I have my Regional settings in the
control panel set to English UK.

I am trying to Mail Merge data from an Excel spreadsheet
that includes a DATE column. I have the DATE column set
in English format dd/MM/yy. When Merging with Word
document the date defaults to US. MM/dd/yy. I find that
you cannot toggle the field code and put in a "/@" switch
on a merge field. PLEASE PLEASE - how can I set these
dates to UK format.

Thank you

Roy

 

[Pete Harrison]

Roy,

Not sure if this will fix your problem, but talking with
several support guy's recently, they told me of a problem
with the Regional Settings not properly changing all date
formats internally.

The fix is very easy. Change the regional settings to
something very different to the UK (I picked Estonian).
Shut down your computer. Restart it and change the
settings back to UK English. Shut Down your computer.
Restart it and check that it is UK in the regional
settings then try your merge again.

As I say, this wasn't specifically to do with merging, but
I did find the date formats worked correctly for me.

Regards
Pete

 

[Doug Robbins - Word MVP]

Hi Roy,

See the "Dates: day/month reversed" item under the "Mailmerge in Word 2002"
section of Fellow MVP, Cindy Meister's web site at:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Doug Robbins - Word MVP]

Hi Jeffrey,

If you create the mailmerge main document as a template with a {
CREATEDATE } field in it and then use File>New and select that template when
you want to execute the mailmerge, the main document that is used for the
execution will display the date that it was created.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP