I have a large sheet (2k+ rows) that I need to send emails to individuals listed on each row of the sheet. Due to compliance, I am limited to sending no more than 20 emails at a time.
I don't need to add additional information to the email being sent, I just need to automate the sending process in 20-email groups. I am hoping I can use mail merge to do this in 20 row groups and I am assuming I will be using VBA. There are scripts all over that I can use to do automate the mail merge, but I don't know how to automate it to do a limited number of rows at a time.
Any help with how to do this is an automated manner would be greatly appreciated!
Thanks.
I don't need to add additional information to the email being sent, I just need to automate the sending process in 20-email groups. I am hoping I can use mail merge to do this in 20 row groups and I am assuming I will be using VBA. There are scripts all over that I can use to do automate the mail merge, but I don't know how to automate it to do a limited number of rows at a time.
Any help with how to do this is an automated manner would be greatly appreciated!
Thanks.