Sending a email via VBA error

[pauldaddyadams]

I have a code to email the active spreadsheet however I have an error with it which prevents the file from being sent.

Once the macro is activated it opens an email up with the correct to:, CC:, Subject and Body text but when I click send I get the error message (in outlook):

''The operation cannot be performed because the object has been deleted''

Anyone know why this would be?

Ideally I would like a Macro that:
Saves the spreadsheet
Sends an email to set people with a subject and body text
closes the spreadsheet


Paul

[Andy Pope]

Hard to tell without seeing any code.

Perhaps this will help
http://www.rondebruin.nl/mail/folder1/mail2.htm

[pauldaddyadams]

The code is below - I am unable to wrap it - Ill amend the post when i have access to another pc tonight - I am restricted on this network to wrap code/attach files etc

Please Login or Register  to view this content.

This code does not include the Save and Close actions I want to include