These files are in vb6 I think. Can't say for sure, but I cannot open them in Visual Studio.Net 2003, and I never used VB6 before.

This issue has been cross posted on other forums as well with no resolution because the project cannot be opened to check out what it going on.

#1) This line here:
VB Code:
  1. ActiveSheet.Cells.Copy ' copy the contents of the ActiveSheet

Where is this coming from? The code above appears to instantiate Outlook, but then all of a sudden you are trying to copy the cells from an Excel file somewhere, but I don't know if you even have an Excel workbook open because the code that this is running in (guessing here) doesn't seem to be in an Excel file.

This issue needs resolved, is there an Excel workbook open when you press this button?