Hi Manjuts,
Thank You for your response.
Suppose if I have 3 subfolders under inbox and inbox has 16 mails then we have to move mails from inbox to subfolders one by one to each subfolder(1st mail will be moved to first sub folder and second mail will be moved to second sub folder and 3rd mail will be moved to 3rd subfolder and 4th mail have to move to 1st subfolder)
after moving each mail from inbox to subfolder excel file should get updated with subfolder name and assigned mail id(initially 1).
next time when we run the bot condition is subfolder with less count should get assigned(move mail from inbox to sub folder) first
for the first time in a day when we run the bot all subfolders will be without any mails(empty).