Draft bulk mails automatically on Gmail from Excel 2007. Doable?

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!

Bump! Please don't let this go in Dump:-)

Please assist. Thanks!

Hi All,

I've attached a sample of how my database is set-up along with the requested solution.

Hoping for some help on this. Would realy appreciate

Thank you!

Isn't this possible? Please advise.

Thank you! I'll stay tuned. Hoping for the best. Cheers:-)

Thank you xladept!

I'm not sure if the link will / does have any information by way of which I can Draft bulk mails automatically on Gmail from Excel 2007.

My preliminary run of site doesn't suggest that, unless I'm missing anything.

Please suggest / comment.

Cheers!

Absolutely, will do! Thanks a ton:-)

Stay connected and Stay blessed.

Once again Merry Christmas.

Hi All,

I need some help on this. Please assist.

Thanks!

Experts,

I need some help on this please. Would greatly appreciate if you could help me automate this piece.

Hoping for a positive reply!

Thanks in advance

I am still badly stuck here. Can someone assist me please...

I really appreciate your inputs. Please help!

Thanks,
ILI