I have a spreadsheet that I am using to mail-merge with a Word template document. The mail merge is triggered by VBA code. I have some dates which come out correctly in the mail-merge and others that show incorrectly.
The Word-doc merge field is formatted thus: {MERGEFIELD DUE@"dd MMM yyyy...