Send Smtp Mail.....Depends on color

Help Studio
, ,
1

I have 2 excel sheet…In 1 st no. of column from that In 1 column there is some cell color is in red…
If the cell color is red then send the mail…the mail id is in second sheet…
Please help…

2
  1. Use the Get Cell Color activity to get the cell’s color.
  2. Use the If activity to see if the color is Red. If so - use the Read Cell or Read Range activity on the second excel sheet. This depends on your Excel sheet’s structure.
  3. Apply your application and business logic and send your email using the Send SMTP Mail Message activity.