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

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/cindy...r/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
"RWN" wrote in message
...
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
-------------------------------------------------

Excellent.
(And at least I know it's not me!)
Thanks.
--
Regards;
Rob
------------------------------------------------------------------------
"Doug Robbins" wrote in message
...
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/cindy...r/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
"RWN" wrote in message
...
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
-------------------------------------------------