email vba script

Hi,

I have very little knowledge of VBA but have managed to scrape my way through to getting the end product I need. Basically Within a sheet I have email addresses and within cells B9, B11, B13 there is a file path to a file that will attach when the vba is executed.

The problem is that sometimes a file attachment will not be required and when the cell values in either/all cells B9, B11, B13 are blank the vba script will not run because the error states that there is no file to attach.

Is there a way for teh script to check if there is a file location, if not then skip it to the next file and so on until it sends just a blank email if required.

Hope that makes sense. Code is below. Main issues are around the

Please Login or Register  to view this content.

Full Code is here:

Please Login or Register  to view this content.

Hope someone can help!

Thanks

Can someone please advise?