Simple Email automation

Help Activities
, ,
1

Hi All,

I have this email automation here. Pretty straight forward, just couldnt get it right. To Loop through the table, check if days to send email is 30, Email sent date is empty and send email.After which apply a =today() on email sent date and copy/paste over it.

Email

Picture of the workflows as below:

Pic1
Pic1588×506 32.5 KB

Pic3

The condition doesnt work and there is no error? I realise that at times, when you paste in the file path. it does not work. Only if you select it using the “+”, it worked. Any advise ?

Pic4
THe writecell function went to loop through all rows. How come the writecell function does an entire looping of the entire column without considering the if condition.

Pic5
There is no error. But, it doesn’t copy and paste at all. the File path is typed in.

Appreciate your advise. Thanks

2

Hey @TTYF ,

Change CurrentRow.ByField(“Days to send email”)=30 to CINT(CurrentRow.ByField(“Days to send email”))=30 and then try. This way it may get entered to the loop.

Thanks,
Sanjit

3

Hi SanJit,

After entering Cint(), there were no error. But the code went ahead to write cell loop through all rows and add today() (pic4) and the copy/range (pic5) also dont work

Thanks

4

Instead of doing the copy paste, write the value directly to the required cell, why you are trying the copy paste?