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. ...
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.
