Generate outlook email from excel list of recipients via sigle click

Hi,

I would like to generate a blank email with a list of recipients (no more than 40) in the 'To' field. I would like to do this in a single click on a cell with the text 'newsletter group' in it (cell B17). The recipients email addresses are in the format of one complete email address per cell in a column starting at C17 (C17, C18, C19, etc...). Any ideas? I thought I had found a way to do this (using the hyperlink function I think, but can't quite remember)but it turned out you could only string together about 8 email address before the function stopped working.

Also just to be clear, I don't want to send the workbook to the recipients.

Thanks

Rick

Hi,
give a try to this code..

Please Login or Register  to view this content.

sorry, typo error in my code
please read this If rngCell = "" Then Exit For
as If rngeCell = "" Then Exit For