Email from Excel?

[UnluckyXIII]

Hey,

Hoping someone might be able to assist me with this one, I'm trying to setup an email function within my spreadsheet but I seem to be a little out of my depth (Excel isn't my strong point).

What I'm trying to achieve is that as my spreadsheet is updated that a cell can be clicked to send an email to a person selected from a data validation list (email address located in a different sheet in the same workbook), I seem to be able to setup the email function fine when everything is located together in the same sheet and the value isn't something that changes but as soon as I introduce the data validation list I just can't seem to figure out how to get this to work.

Hopefully the above makes sense and someone knows where I'm trying to go with this, although if you need more details or I haven't explained this very well please let me know.

Thanks in advance
XIII

 

[DRSteele]

I don't quite understand what your issue is, so I tinkered around. I was able to set it up. On Sheet1 I have a list of email addresses. On Sheet2 I set up Data Validation | List with Source equal to the list on the other sheet. Then on Sheet2 I used the data validation drop-down arrow to select one of the addresses. It did so, but it was not a hyperlink. So I put into edit mode with f2 and then pressed Enter, which turned it into a hyperlink that opened up my email functionality when clicked. Subsequent selections with the drop-down arrow did not require the step of creating the hyperlink.

 

[UnluckyXIII]

I appear to have figured this out.

First I added a VLOOKUP in a hidden cell to pull the email address from the other sheet based on the information entered by the data validation list. Then with this in place I was able to use a HYPERLINK to reference the hidden cells email address and populate the email to notify the correct person that an action had been assigned to them in the team planning board.