Emailing direct from Excel

[marcidee]

I have a workbook that has several sheets (one for each person) - is there a way that I could email the contents of each sheet directly from Excel to the 'body' of an email.

If this is feasible - where would the email addresses need to be located ( a separate sheet or on each individual sheet, (a separate sheet would be easier))

Thank you for your help

 

[jmacleary]

Hi there. There is a superb chap called Ron DeBruin, who has lots of guidance on things like this. Have a look at this page - one of his suggestions should do the trick for you. https://www.rondebruin.nl/win/section1.htm

 

[marcidee]

Thank you - I will check this out