This is a strange problem (for me, at least). I am using word mailmerge function to print a form letter from vba code in excel. After a few attempts, I managed to implement this function using the code as follows

Please Login or Register  to view this content.
this code is called passing the cardnumber parameter, which identifies the record whose fields fill the formletter. The mechanism works fine, except that the Date fields appear SOMETIMES in the letter as numbers (e.g. 28/08/1937 ===> 13755), i.e. the unformatted date number. I am still trying to find if particular dates behave in this way, but at the moment the pattern (if any) escapes me. In any case, if I perform the mailmerge directly in word, using the same formletter and the same excel table source data, the thing works fine (dates display correctly). Any hint? Thank you
Robert