Help: Send email to people where expiry date is missing in column H & I

[A9kurs]

Hi Guys,

I am looking for some help in this .
I am trying to send emails using VBA, in attach worksheet there are some email address written in column F. When i am pressing button "send email" email will be send to email address as in column f.
I don't want to send email to all email address . If expiry date is present in both columns H & I then person should not receive email & if there is no date in any column H & I should receive email

Thanks

 

[Marc L]

Hi,​

​

according to any forum rules - a must read ! - when you do cross posting you must add a link for each other forum​

where you have created the same thread and thus on every forum !​

​