Excel Mailto Hyperlink including validation

[guerillaexcel]

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

Please Login or Register  to view this content.

Anyone able to help?
Cheers

[DonkeyOte]

Probably overlooking something but wouldn't it just be:

Please Login or Register  to view this content.

[guerillaexcel]

yep thats perfect, cheers!
So if I wanted to select and email a range could I just change the individual cells to a range e.g. & A:A & ?

[DonkeyOte]

You will need to clarify - do you mean a range of recipients or a range of cells to be included in the Body ?