Forum Discussion
Coding to email
Hi- I am looking for help with coding an excel file to email. I have it set with pages but on this spreadsheet, I was hoping that each name entered in the cell would trigger an email to that person. So, if I typed in "Nick" a notification email would go to Nick's email. Each email for each person whose name would be on it.
I am not the best at coding and haven't done much coding since my teenage years. If someone could help steer me in the right direction on building the code, or how to edit the code I have to make it multiple names/emails, that would be awesome.
Thanks for your time!
3 Replies
I think the following video tutorial might be perfect for what you want:
https://www.youtube.com/watch?v=URF3ikW0Svc
Close, but not exactly! I did teach me some things I need for a different project. Thanks!
do you want active notifications like apps do using user_name might notify user_name of a mention? then you will need to use the Worksheet_Change function to continually monitor the new inputs and check against a list of users and then use another list of e-mail to send the e-mail. Is that what you are going for? That said, I think excel 365 already has this type of capability through the Comments section as long as the file is on onedrive/sharepoint.
