Wd '03-Date formats from Excel changed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RWN - 08 Jul 2005 00:30 GMT

Converted a Mail Merge template from '97.
Source file is an Excel WkBk (one sheet).
The workbook is on a network drive.
Dates on the XL records are formatted as yy-mm-dd
The merge insists on changing then to mm-dd-yy.
How can I "carve the format in stone"?

Also, why does the (annoying safety feature) tell me the source file is from "ICP$"
whenever I change the source?

This used to be so simple!

Regards;
Rob
-------------------------------------------------

Reply to this Message

Doug Robbins - 08 Jul 2005 05:19 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

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

> Converted a Mail Merge template from '97.
> Source file is an Excel WkBk (one sheet).
[quoted text clipped - 12 lines]
> Rob
> -------------------------------------------------

Reply to this Message

RWN - 08 Jul 2005 15:34 GMT

Excellent.
(And at least I know it's not me!)
Thanks.

Signature

Regards;
Rob
------------------------------------------------------------------------

> See the "Dates: day/month reversed" item under the "Connection methods"
> topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
[quoted text clipped - 17 lines]
> > Rob
> > -------------------------------------------------

Reply to this Message