• 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

    Hui...

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

Send email based on condition

coolkiran

Member
Hello All

I have an excel sheet, i need to go each row and to check if exception 1 and exception 2 column is "NO". If its no then , i need to copy subject in Column M, and search in Outlook mails, if mail already sent, if sent then reply all with one table which is in excel workbook.

If mail not exist, then create new mail and add excel table to mail body and send to column "C".

Once mail sent go to next row..

Please advise how we can proceed.
 

Attachments

  • Chandoo.xlsm
    11.1 KB · Views: 4
coolkiran
Did You upload a correct file?
or
Something not match with Your texts ... hmm?
= have You tried to do this manually with those texts?
 
coolkiran
Did You upload a correct file?
or
Something not match with Your texts ... hmm?
= have You tried to do this manually with those texts?

Vletm

Its correct file. Just now checked again... column C will have email address, for every user we will add "@gmail.com" at the end.
 
Back
Top