Hi, I have data in a row that I want to email when I click on a cell (I have the formula worked out for this)
Basically I want to be able to select from a dropdown (in Cell I2) a certain email address, then click "email data" and have the email address populate in my mail client (lotus)
attached is a sample file, for reference the validation list is in I2
Anyone able to help?=HYPERLINK("mailto:[email protected]?body=Here's the data%0AData1=" & A2 & ", Data2=" & B2 & ",Data 3=" & C2 & ",Data 4=" & D2 & ",Data 5=" & E2 & ",Data 6=" & F2,"Email data")
Cheers
Bookmarks