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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Derekbemused - 21 Oct 2004 17:24 GMT

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

Reply to this Message

Doug Robbins - 22 Oct 2004 00:53 GMT

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

Signature

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

> 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

Reply to this Message

Derekbemused - 01 Nov 2004 17:52 GMT

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

> 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

Reply to this Message