Hi Tony

Forgive me for sounding rude but i'm quite aware how to do a basic mailmerge. The problem i'm having as per my original post is that when I reach point 6 on your list and click open it brings up the error msg 'error has occured: external table is not in the expected format.' However, if the source spreadsheet is already open it does not bring up said error and allows me to proceed as normal. Keeping it open is an interim solution but does not get to the root of the problem.

After a bit of googling I have proceeded to post number 7 of this thread which is where I am still at now...