Excel email with three conditions

I have an email macro (Ron DeBruin) that works great. If the cell in column H = "NO" and if the corresponding cell in column L <> "SENT" the code will continue to loop until it finds a cell in column H = "NO" and a blank cell in column L. The code is as follows:

Please Login or Register  to view this content.

However, is it possible to modify this line so that the macro will still look to column H for a "NO" but will also look to column L for either a "SENT" or an "N/A"? My skills are scarce, at best and have had no luck on my own.

Any help would be most appreciated.

Thanks.

Cindy

Hi Cindy. Try this:

Please Login or Register  to view this content.

HTH

Jason

Hi, Jason:

Thanks for your suggestion. When I modified the code as suggested, it launched email for every row of the spreadsheet, whether there was anything in cell.Offset(0, 7) or not. Phew - quite a challenge shutting it down!

Good suggestion, just not the right one.

Thanks, anyways.

Solved - thanks for your efforts!