I need to email every week , but start date i dont know..it might be tomorrow or 2 days after . when i met my condition from then bot should email every week

Help Activities
, ,
1

I had one coloum in excel , where count =30 , then i need to email from that day every week.
loop is count=count +1

so email should go after 7 days ie : 37 ,
again next 42nd day. so on

1 Like
2

Hey @MitheshBolla

You mean the count value mentioned is the day ?

Thanks
#nK

1 Like
3

yes , if it reaches 30 i need to email that day and next weeks if count is 37 . some times it can go back to 1 also … so i should wait for 30

4

I’m sorry. kindly explain as it’s not clear enough !

1 Like
5

i had column name DayCount with numbers.suppose Daycount = 25
after 5 days it will become 30 . i kept +1 for each day
daily bot will run it will increase.

Once DayCount =30 , i need to send email…
later after 7 days if its 37 i need to send another mail…
again next week check the count if it is 42 i need to send mail , if its < 30 i need not send…

6

Hi @MitheshBolla,

Wouldn’t it be more appropriate to create a condition with today’s date without keeping count?

Regards,
MY

1 Like
7

I had date column , it will keep current date , so i cant send email for next week, i want to keep condition on count itself

8

If we think that it will work every day, you should have an excel related to this line in the temp excel and check the count there before starting every work.

1 Like
9

Hey @MitheshBolla

Now what I can understand is not will send email when,

  1. Count is greater than or equal to 30

  2. Count is +7 everytime greater than 30

Is that correct please ?

Thanks
#nK

1 Like
10

count = 30 , i will send mail

after 30 for + 7 i need to send mail . ie : 37

next at 44 .

but not at 31,32,33,34,35,36,38,39,40,41,42,43,

1 Like
11

i had excel sheet , i am sending 1 st mail, base on conditions , later i need to send +7 after (ie weekly once).this logic how to write?
image

12

Perfect, So you need have the condition in If like this.

Count = 30 OrElse (Count > 30 AndAlso (Count - 30) mod 7 = 0)

If the above is true, you do the mail part.

Hope this helps

1 Like