Mail merge from Excel file changes date formatting

[Colin in RSA]

I have create a word document using an Excel worksheet as my database. The
date format in the worksheet is dd/mm/yyyy but comes out as mm/dd/yyyy using
the sql query function or yyyy/mm/dd if the data source is ODBC. How do I get
the format I require with out making the 'date field' in the worksheet a text
field??

 

[Anne Troy]

Try this, Colin:
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[Doug Robbins - Word MVP]

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

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

 

[Colin in RSA]

Thanks 1,000,000 Anne & Doug for the assistance - you saved me from going bald.

 

[Anne Troy]

You're welcome, Colin!
************
Hope it helps!
Anne Troy
www.OfficeArticles.com