how do I stop mail merge recipient list from defaulting to date f.

D

Derekbemused

Please How can I stop mail merge recipient list from formating dates as US
style mmddyy when excel data source is UK style ddmmyy. XP is set to English
UK. and programs are MS office 2003
 
D

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
 
D

Derekbemused

Advice and guidence from Doug Robbins was most helpful in solving the problem
and I now have mail merge working correctly by saving the excel database in
text comma deliniated format and using this as the database to merge with
word. Also tried the other option of formating the word mail merge document
tables and using excel directly however this seemed a more cluttered approach.
Thanks again

Derekbemused
 
Top