Creating an Outlook Email from Excel

I found a template for a code online to auto-generate an Outlook e-mail from a spreadsheet. The code is working perfectly (displays exactly what I want in the e-mail), but if I hit "send" or change .display to .send, it gives me an error (and I can't find out what error it is, as my msgbox returns "0:"). Any ideas on what is causing this?

Please Login or Register  to view this content.

You can't assign a value to the Error Object like that, and why would you? The Error is set by VBA when an error occurs, you can query it but you cannot'set' it by assigning a value.

The whole logic of the lines I quoted is a bit warped. You should remove all 'On Error...' statements and the line starting with the label 'Here'. Run the code and see what happens. If it errors then fine, that can be handled but you need to know if it errors or not, first.

I was just attempting to see if the code resulted in the generation of an Error number.

I did what you said, and there no longer seems to be an error, but pressing "send" still is not having any effect.

OK. Sorry but I can't help with that at the moment - don't have a copy of Excel to hand. I only replied because the 'On Error Goto Here' followed immediately by the label 'Here' didn't really make any sense. There was no opportunity for an error to occur between those 2 lines...

Perhaps a basic intro to error handling might be useful for you?

Alright thank you! I'll have a look at that.