My Bot is executing from evening 6 p.m to morning 6 a.m. The trigger is set to execute every 5 mins and reads incoming emails, sends replies to emails, and creates an excel file in which successful emails are recorded. Now it is sending the summarised report as email every 5 mins as per the trigger, which is not to be done that way.
I want to capture all the recorded successful emails from 6 pm to 6 am and send a single summarised report email to the client.
How can this be achieved?
Write a condition in your initialize process …when now > Cdate(Now.ToString("MM/dd/yyyy") + " 05:55:00") And now < Cdate(Now.ToString("MM/dd/yyyy") + " 06:00:00") and create a boolean variable bool_sendemail…and set this to true on then side and false on else side…
Now use this in end process to create the report with another if condition with bool_sendemail variable…on the then side…either get all reports and combine…or if you have queue items get all queue items from 6 pm previous day to now …using filters in get queue items activity…then send it
Hope this helps
Cheers
@Anil_G, is it necessary to use a queue, I mean to ask for processing I’m using the excel file not using orchestrator queue.
Will it still work with the above-mentioned suggestion?
Its not necessary to use wueue…as mentioned…if for each run you can only create a excel file …and then in the final one…you can combine all of them together and send in email…make sure you have a good naming convention or have all the current reports in separate folder so that its easy to access and move them once email is sent
So it will still work
Cheers
Will try and let you know.
Thanks.