Hi All,

I'm trying to get to or reach a point where a tedious routine process could be automated.

Here's my challenge. I need to use a large xlsx file which has a client name and a corresponding Email ID. The sheet will have 10 rows for a client if there are 10 folks that need to be sent an email from the clients side or 1 row if there's just one on the list. It can vary. I use Google mail and each time an email is to be sent I have a specific text that needs to be relayed. For now, I have to create the email for each and client separately. I copy email address and save the drafts before finally adding the details.

I was hoping to get some valuable contribution from you experts on the way of creating a basic draft through some kind of automation wherein if I can get a single email per client created using my base sheet. There are at least 5 columns (3 need to go in the CC list and 2 in To field. The CC list is always the same in all rows per client but the To list is always separate per client. Is this doable?

Please help!