[Dave Baxandall]

I'm using Excel and Word 2003 on XP. I've created an Excel spreadsheet that
uses macros to call macros in a Mail Merge template document. After the mail
merge document is created I close the template and all that is left is the
new document and the Excel spreadsheet.

My problem is that this works fine the first time but if I close the new
merge document, make changes to the spreadsheet and rerun the excel macros
the changes to the spreadsheet are not displayed. It seems like the data is
in memory somewhere and the Word doesn't bother to re-connect to the
spreadsheet again. I've even but in a save and wait command in Excel but it
makes no difference.

--
Thanks in advance
Dave Baxandall