require help with excel to email

[dougers1]

Hi

is it possible for my sheet to sends emails out automatically to the right person depending on the area.

Hospital & Wards tab

for instance Beatson-Ward B3 (REG) Oncol would send the data from sheet 1 (which is the data from pivot) to the email address that matches Beatson-Ward B3 (REG) Oncol in the contact tab

if you can help this would save me loads of time at work

Thanks

[noboffinme]

Hi dougers1,

If you know some VBA, you could use the info from your workbook to be the 'To', 'From', 'Subject' and Body.

Here's a useful link;
https://www.makeuseof.com/tag/send-emails-excel-vba/

[dougers1]

Hi Thanks for the link, I have no knowledge of VBA - but will have a look to see if I can pick it up a little.

any help is appreciated