address a new email to recipients gotton from an excel cell range

**tommes9000** · 04-11-2012, 08:45 AM

Hi there,

I have an excel spreadsheet listing contact persons in a specific column. From time to time lines will be inserted or removed.
I would like to write a macro, that creates a new outlook mail and inserts all email addresses from that column into the recipient list.

I know how to create emails address to a fixed amount of hard coded cells.
What I think about is to make a selection via mouse and then start the macro which addresses to the recipients listed in the marked cells. Is that easy possible?

thanks,

Thomas

**DGagnon** · 04-11-2012, 08:59 AM

if you wish to use a selected area you can use something like this

Please Login or Register  to view this content.

then in your code to send the e-mail, just reference that variable in your .To section.

**tommes9000** · 04-11-2012, 11:23 AM

thanks a lot, works great!

I noticed, there are lots of duplicate email addresses. Is there an easy way to filter out the duplicates?
Do I have to assign the inputs into an array instead of a string, then sort it and compare each item with the one before?
Is there any easy trick to get this done?
I am not really familiar with vbsscript. In unix shells there are two commands to achieve this:-)

cheers, THomas

**DGagnon** · 04-11-2012, 11:47 AM

based on my experience with VBA that is how you would have to do it.. although once you have the values in an array you can use JOIN to make it into one string.