Code to send an e-mail. Don't send if attachment not found

**thedon_1** · 07-18-2012, 08:29 AM

I found some code on the internet which e-mails some stuff based on what you have in cells.
It works really well and attaches a file based on the file path and name being in a cell.

One thing I want to change is that if the file is not found, don't send the e-mai and give me an error message. Better yet, ask me if I still want to send the e-mail.

Right now if I type the file path and name, but i type something wrong, it sends the e-mail but with no attachement.

Here's the code.

Thanks

Please Login or Register  to view this content.

**thedon_1** · 07-19-2012, 09:34 AM

Any ideas?

**thedon_1** · 07-24-2012, 07:29 AM

Last bump. ANyone got any ideas?

**Chippy** · 07-24-2012, 05:41 PM

Try this:

Please Login or Register  to view this content.

I've included the complete code to reproduce your requirement. I wondered why you are using On Error Resume Next, as this shouldn't be necessary in this code. Therefore I've commented out that line and the On Error GoTo 0 statement.