Using an IF statement in VBA - HELP

[gassiusmax]

Hi All,

I am really struggling with what I thought should be a straight forward Idea. I have a code to create and send an attachment that works over a range (this must be set, for ease of third party use). The code works well if an email address is present but when the range extends and their is no email address it creates blank emails. this is what I need to stop

So if in the range I have two columns of data - I only need to create two emails and not two emails and loads of blanks.

my thoughts were an if statement working through the range and if it had an email address then create email but if it were blank then skip to the next one.

Any Idea's on how

Please Login or Register  to view this content.

Thanks
Danny

[mehmetcik]

Please Login or Register  to view this content.