Email Contents of Sheets to Different Recipients Addresses

[hamidxa]

I have a workbook that has multiple sheets in it as per the attached example (the sheet names/ranges will likely vary week to week in the real file).

I am wondering if there is a good way to email the contents of the sheets to the recipients referenced on each of the respective sheets.

So for example, my attached file has the following 3 tabs: 1, 2, 3

I would like the contents of Sheet 1 to be sent to the email address specified on Sheet 1, cell H2
I would like the contents of Sheet 2 to be sent to the email address specified on Sheet 2, cell H2
I would like the contents of Sheet 3 to be sent to the email address specified on Sheet 3, cell H2

By contents, I mean to say, the various ranges of text contained under Body 1 through Body 6.

The subject will always be relative to each recipient and is defined in cell A2 of each sheet.

Essentially, Is there a way to
a) Starting with sheet "1"
b) copy the contents from Sheet "1" into an email (Outlook) to be included in the body, not as an attachment
c) send to the email address specified in Sheet "1" per the subject on same sheet
d) Loop through the rest of the sheets and repeat steps a-c with respect to those sheets?


A finished example of one such email is included in the last tab named Example1Email.

[Pepe Le Mokko]

Different solutions can be found at http://www.rondebruin.nl/win/s1/outlook/mail.htm

[hamidxa]

Different solutions can be found at http://www.rondebruin.nl/win/s1/outlook/mail.htm

Hi Pepe,

Thanks for sharing this link.
I've experimented with a few of the solutions on there, but can't figure out how to make them work for my specific use case.

Sufficed to say, I would definitely appreciate more help with a customized solution.