(First published by Linda on 24/10/2019)
Every now and then when I’m running Excel courses I get asked the question ‘I have a problem when using Excel data in a Word mail merge; can you help?’. The problem invariably is the same thing; the date field appear in the US instead of the UK format when merged; despite the fact that the dates are in UK format in the Excel source data file! This is because Microsoft are using a different ‘engine’ to drive the mail merge and the result is the data often appears in the wrong format. There is a hidden solution to this and in the hopes that this may help even one or two of you I have attached a pdf document (link below) containing the solution. Feel free to share this using the social media links below.