Excel to Outlook macro

[KFL012]

Hi,

I'm looking for a way to connect Excel to Outlook. I have 5 identical sheets, each with one graph and an e-mailadress in cell A2. I want to build a macro that pastes the graph into an e-mail and sends it to the address included in that sheet, and then does the same for the next sheet, etc.

Copying and re-iteraring the process for the next sheet should be fine, but I'm not sure how to get Excel to interact with Outlook.
Does anyone know if this can be done? And if not, if there is some kind of a workaround?

Thanks!

 

[James006]

Hi,

For this topic, do not hesitate to dive into Ron's excellent site ...!!!

https://www.rondebruin.nl/win/section1.htm

Hope this will help