Email different Tabs to different recipients with cc' and bcc' options with single click

[jhy271]

I'd like to be able to email 10 different tabs to 10 different email recipients within excel with a click of a single button, with cc' and bcc' features.

For example, ideally I would have each tab with the following inputs in four cells:
- from email address
- to email address
- cc' email address
- bcc' email address

then once I click a magical "SEND" button, I'd like to email that very tab ( and tab very tab only) to the recipients listed in the above four cells. Is there an existing thread that has this coded?

My company only uses Gmail (not outlook)

[maniacb]

Here is some Gmail code I got somewhere online. It is a start. To set up the logic, it would be good to see your workbook.

Please Login or Register  to view this content.