Exception Handling of invalid email address

Hi,

I am trying to email a list of people using Macro. I have the list in a column and I am looping through the column to email each one with a specified message coming from another column on the same worksheet.

I do have the email macro going well but I have a question. If the email is incorrect, the macro halts on that email. I want to do some exception handling for the same. Can you suggest something ?

Also I am a newbie to the excel macro world, so i am pasting my code for your verification and suggestion for modification and enhancement.

Please Login or Register  to view this content.

Can you tell me when i use a cells.find and if the value is not found how to do the error handling ?

Also, what does this do

If Not c Is Nothing Then c.Select

c is defined as range

Thanks Leith,

I am sure your enhancements are very apt and I have learnt from it.

I do have a question though.

In the "for" loop, once the email is ready to be sent, what happens is that if the email address is incorrect, the macro will hang, because there is a lotus notes error (saying something like the email address is not found or something similar to that). How can I trap that exception and handle it appropriately.

Ideally, what I would want is to open a new sheet and copy that row with incorrect address onto a new sheet in the same workbook, and continue with the next PI_Name

Can you explain how this works and how should I incorporate it into my code