Skip to next record in For...Next Loop if condition not met

Hi,

I am writing a code that will go down a column C in worksheet Data containing Customer IDs, starting at row 3 and going down to the last populated row
If a cell contains an ID, I find the row in the Master (worksheet SUBS) for the customer having that ID
Column P of worksheet SUBS contains the email address of the customer.
Using this, an email is generated to the customer.

After finding the customer, if the email address in column P in worksheet SUBS is blank, I want to skip this customer and go to the next row in Worksheet Data.

The Code I have written is as follows:

Please Login or Register  to view this content.

I tried using Exit For, but this exits the loop. I tried to use Resume Next. This gave me an error "Resume without error"

How do I get the For...Next Loop to continue ? Any help will be greatly appreciated

Anand