Loop & Accumilate e-mail addresses to send to

[Les Stout]

Hello, i need to loop down a sheet and collect all e-mail addresses to
send an e-mail to the relevant people, is this possible in Excel ??

Les Stout

 

[Ron de Bruin]

Hi Les

Do you have more information ?

If you want to collect all addresses from a worksheet and put it in a list
so you can use this range with e-mails in your mail macro then try this

http://www.rondebruin.nl/find.htm#Copy

 

[Les Stout]

Hi Ron, i have 3 columns(N, O & P) with different names in but names can
be duplicated, variable in length. I need to gather one e-mail address
for each instance of a name to store as a variable for the "TO" of the
e-mail.

Les Stout

 

[Ron de Bruin]

Why not use Date>Advance filter Les to create a list with unique e-mail addresses

Then use the range with unique e-mail addresses in your macro.
There is example code on my site that show you how you can do this

 

[Les Stout]

Hi Ron, sorry for ignorance, but i am not a programmer and this is
rather daunting...
Can you give me some more pointers, i do not find that on your site,
thanks...

Les Stout

 

[Ron de Bruin]

After you used Data>Advanced filter
http://www.contextures.com/xladvfilter01.html#FilterUR

You can see here how you can use the range in my mail examples

SendMail examples
http://www.rondebruin.nl/mail/tips1.htm

Outlook object model examples
http://www.rondebruin.nl/mail/tips2.htm

 

[Les Stout]

Thanks Ron, will tackle in the morning...

Les Stout