I'm using VB codes as below for automatically email the respective recipients when conditions in EXCEL are satisfied.

'SENDER DETAILS

    EM.Reset
    EM.Clear True
    EM.Domain = "engineer.com"
    EM.From = "[email protected]"
    EM.FromAddr = "[email protected]"
    EM.Replyto = "[email protected]"
    EM.HTML = True
    EM.MailServer = "10.8.0.100"

    'THE SUBJECT
    EM.Subject = "ALERT: Gas CO in ABC123 will be expiring soon - Reported on :" & Now
    EM.LicenseKey = "This control licensed to LSI Logic only. " & _
    "Registration#6970037994f2. (c)1997 Quiksoft Corporation. All Rights " & _
    "Reserved. Unauthorized use prohibited. This text can not be duplicated " & _
    "without license."
    EM.AutoWrap = True


EM.AddRecipient "mukhzeer", "[email protected]", 1

The problem here is , few emails need to be sent out, BUT I dont want to put it manually in VB code as above. Can someone help me in writing codes so that it can read email address written in EXCEL

I think you will find all of the answers here > http://www.rondebruin.nl/sendmail.htm.

Kieran