In Word, select Options from the Tools menu and then go to the General tab
and check the box for "Confirm conversions at open"
Then, re-attach the data source to the mail merge main document and when you
are presented with a dialog asking you for the method by which the
connection should be made, select the DDE option. Old technology, but will
probably solve the problem.
As to why some fields are being treated differently, the reason is probably
because with the conversion method that was being used, Word considers the
first 8 or so records and from them, determines the type of data that is
contained in each field and applies that determination to the rest of the
records, which may not be correct thing for it to do.
--
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
