Hi all
I have a spreadsheet that I need to be able to click a button and open an Email template based on the information on the row and input data into the body of an Email, Subject and Send To, When the button is clicked I need it to also change the "Date 3 Month Reminder Email Sent" date to Todays date and the "Staff Replied" to No anyone able to help with this? I have attached an example Email (JPG) and also the Excel spreadsheet.
Bookmarks