Email Hyperlink command button

**damo_uk** · 06-14-2010, 01:00 PM

Hello,

I have created a document with a list of peoples emails.

I want to create a command button that will select a range and select all the email hyperlinks and set up a single email to send to them.

I can get the macro to select the range but it will only email the first one on the list, not the whole ground.

Code is below:

Please Login or Register  to view this content.

I want the email to be to all 13 people however the number after hyperlinks(x) corresponds to the person who will be emailed... i.e. 1 is first on the list, 13 is last.

Any ways round this? Simple as possible please!

Many thanks,

Damien

**salimudheen** · 06-15-2010, 07:29 AM

Hi Damien,

You can loop through the index from 5 to 17.

Please Login or Register  to view this content.

**damo_uk** · 06-15-2010, 10:14 AM

Many thanks, that's briliant.

I know similar threads have been created in the past but I can't quite find one that I'm after.

Is there a way to create a single new blank email addressed to all the selected range (rather than individual emails adressed).

I am designing a spreadsheet to act as a mailing list where we are holding events and want to create a command button to say email all (who meet condition) where the conditions are held in a spreadsheet.

Thanks in advance...

**salimudheen** · 06-16-2010, 04:46 AM

Hi,

As per my knowledge you can use "CDO.Message" object for sending email.

Look at the below link. It will help for you.

http://www.excelforum.com/excel-prog...nt-people.html