Generate a standard e-mail within a drop down.

**steve mullin** · 11-14-2012, 08:55 AM

Hi guys
what I would like to do is generate an atomatic email when I choose fron a drop down list.
When I select D1 return to supplier I want to generate the email. I have tried to add a hyperlink in the list but it wont work . Can some one help please, also if you could copy the path that would be great.
Steve.
2012-11-14 12-51-09_Microsoft Excel - Book1.png

**JBeaucaire** · 11-14-2012, 11:29 AM

It would require VBA to actually generate an email from the selection change in a Data Validation cell.

You can use the HYPERLINK function in an adjacent cell to create a clickable link that would generate the email, that would be doable, but that's not exactly "automatic". You would select "D1 Return to vendor" then click the link that appears, perhaps in B4.

=IF(A4="D1 Return to supplier", HYPERLINK(“mailto:[email protected]?subject=Return To Supplier”, “Send Email”), "")

Here'a a little more indepth look at that technique:
http://datapigtechnologies.com/blog/...link-function/