send email to selected cells, pull values from selection

[Armitage2k]

Hi,

I would need some help to make a little project work. Currently I am having a worksheet with names and email addresses of people. I would like to have excel start a macro to generate an email with a pre-written text and then send it to the each person in the selection. Further, the macro should pull details such as the name from the related column and insert it into the email.

A sample of my worksheet is attached, below the sample code I use to send emails at the moment:

Please Login or Register  to view this content.

Would be nice if I could get some help on this.
Thanks a lot,
A2k

[Armitage2k]

really no clue anyone?

Thanks,
A2k

[jaslake]

Hi Armitage2k

Here's one way. Double click on any name in Column F. Let me know of issues.