Hi
first can I say hello to everyone ,I am new to this site. and am hopimg that there are loads of friendly users that will be able to help me with my skill development.
anyway I am wondering if it's 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