With Covid this year creating a socially distanced secret santa (WFH) I have created a spreadsheet that will select the person who the staff memeber is to buy for. What I would like to do is add to this sheet a VBA so that it emails the name in the list from column B to the email address in Column C inserting the name at the end of text "Your secret santa is......."
Is this possible or am I just looking at a pipe dream. I have looked at Ron de Bruin's solutions but unless I am missing something I dont think it can send a seperate cell to a corresponding cell address in the list.
Any help would be gratefully received
Thanks
Chris
Is this possible or am I just looking at a pipe dream. I have looked at Ron de Bruin's solutions but unless I am missing something I dont think it can send a seperate cell to a corresponding cell address in the list.
Any help would be gratefully received
Thanks
Chris