I have been using mailmerge with an Excel data source for 3 years. I created
a new worksheet for 2005 and something has gone wrong.
First, opening the Word doc no longer automatically opens the Excel file.
In fact unless I open the Excel file before the Word file, it says the Excel
file is locked for editing - although it's not apparently open at all. The
other way round , it's ok.
Secondly, there are 2 date fields in the data source, with custom format. I
enter eg 1/9 (UK order) and the worksheet correctly shows September 1. The
mailmerge letter/email also used to show September 1. But now it shows 9/1
(US order). I cannot imagine how this has happened or work out how to fix
it. HELP!