How to Update a cell in Excel

I have an excel with values, After sending a mail for each customer, i have to update the column email status to sent.

It has to update for each customer only when the email sent.

I got stuck after sending email part on how to update the column with status sent.

@Vishwanth_Raya, you can use Write Cell Activity for that matter.


but how to write only for that particular customer where i have sent an email.

@Vishwanth_Raya, I assume you are looping through customer, So you can use following steps within loop:

  1. Use Excel Application Scope activity
  2. Use Read Cell Activity to get customer name
  3. Use IF Activity to compare customer name
  4. If match, use Write Cell Activity to update cell

Hope this helps

Okay, Let me try this.