Mail merge date format change

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter - 13 Apr 2004 12:54 GMT

I am having problems maintaining the international date
format in a mail merge. In my Excel database the entries
are in UK format but when I merge them into a Word
document the formatting is changed to US. I can't find
anyway to change stop this from happening; have tried
using the \*MERGEFORMAT field codes, have tried changing
the default Word document language to English (UK).....No
Luck! Any help greatly appreciated!

Reply to this Message

Doug Robbins - Word MVP - 13 Apr 2004 13:09 GMT

Hi Peter,

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

--
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

> I am having problems maintaining the international date
> format in a mail merge. In my Excel database the entries
[quoted text clipped - 4 lines]
> the default Word document language to English (UK).....No
> Luck! Any help greatly appreciated!

Reply to this Message