I have a list of emails in one sheet & the email draft in another.
I need a code to automatically send the email draft from sheet 2 to every 5 members in the list provided in sheet 1.
Once the first 5 are sent, the code should tag them as "Sent" in a new dedicated column & then wait for 60 seconds before sending out the next set of 5 emails.
The code should run until the end of the entire list.
The code can use outlook to send out the mails from the default profile in outlook.
Let me know in case if you need any more clarifications