English/American date formatting in XP mail merge

[John Diston]

I'm having a problem with taking data from Excel and merging it into labels
using XP mail merge. The problem relates to Word reformatting dates from the
English format (dd/mm/yyyy), as it was entered in Excel, to the American
format (mm/dd/yyyy) when using mail merge. Can anybody let me know how I can
get round this as I really need the dates to stay in the English format?

Thanks very much.

 

[Doug Robbins]

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 respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP