Mailing list sender date reversed?

[LMC]

By carrying out a "mailing list sender" in MSWord with the data contained in
an MSExcel file, one of the columns of the MSExcel file contains the date
with format DDMMYY but at the time to pass the data in the MSWord file the
system inserts the date into format MMDDYY and it is impossible to change
that.
I changed the attributes of the column dates in the MSExcel file and I put
it at text format but the problem it is that I have more than 3500
recordings and the date is posted in an incoherent format and change all
manually would take a considerable time.


Would someone have an idea?

Thank you for your answer.


LMC

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

See the article "Dates: day/month reversed" under the Connection methods
heading 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

 

[Tim Ferguson]

one of the columns of the MSExcel file contains the date
with format DDMMYY but at the time to pass the data in the MSWord file
the system inserts the date into format MMDDYY and it is impossible to
change that.

= DateSerial(CInt(Mid$(ExcelDate,5,2)) + 1900, _
CInt(Mid$(ExcelDate,1,2)), _
CInt(Mid$(ExcelDate,3,2)))

Does that help?


Tim F

 

[LMC]

Thank's for your answers.

In fact one of the solutions could be this one :



By default Word 2002 uses for fusion the OLE DB which seems to manage the
English dates.

Go to Tools, Options, General, check the box "Confirm conversions on
opening"

When the data source is opened, the system asks to confirm the conversion:
choose "DDE".



For more explanations go to :

Microsoft Knowledge Base Article - 304387



LMC