VBA Excel Outlook Automation Run-time error

[dprayner]

HI people.

I was wondering if anyone know the most probable cause for the following error:

Run-time error '-214467259 (80004005)':The Operation Failed

This error gets hung up on the .Send line of code.

What the project does, is when the user opens the Workbook, a VB UserForm pops up. The user enters data which populates the spreadsheet. When the user clicks on a command button on the spreadsheet it automates with Outlook to send the Workbook as an attachment.

99% of the users are not experiencing any problem with this application and it's code, but at least one person is. I was wondering if this person's settings are off in either their Outlook or Excel. Maybe in their Tool References? Any thoughts? DAVE

 

[PHV]

What happen if you replace .Send with .Display ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dprayner]

Hi PHV. It is hard to test because everything works fine on my end. The person is unfortunately in another building. When I switched the .Send to .Display the message comes up, but you have to click send. DAVE