Hello, I'm trying to determine a formula that will enable an outgoing email through microsoft outlook. Essentially I am trying to find a way so that when I click on the 'email' on sheet5, it auto fills selected values from the sheet5 line 12 into the template_mail values (example would be sheet5 G12 is inserted to template_mail B12, sheet5 H12 goes into template_mail C12 etc. With this being said, each of the sheet5 columns for D each represent a different person represented by the 'names' sheet with a corresponding email address for each person. This way if I click the 'email' on sheet5 in the AC12 column, it will fill values into the template_mail template and automatically email to the persons email set in the names sheet column C2, if I click on email on sheet5 column AC13 it fills the line values and automatically emails the person in 'names' sheet column C3 and so forth. Is there a way to do this? There is a VBA script for generating the email, however currently I have to manually change the email To: address and insert the values manually, i'm trying to find a way to have this done automatically when clicking the 'email'. Thanks!test email.xlsm