• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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


New Member
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



Marc L

Excel Ninja
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 !​