Loop & Accumilate e-mail addresses to send to
 

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

*** Sent via Developersdex http://www.developersdex.com ***

Loop & Accumilate e-mail addresses to send to
 

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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Les Stout" wrote in message ...
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

*** Sent via Developersdex http://www.developersdex.com ***

Loop & Accumilate e-mail addresses to send to
 

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

*** Sent via Developersdex http://www.developersdex.com ***

Loop & Accumilate e-mail addresses to send to
 

Why not use DateAdvance 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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Les Stout" wrote in message ...
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

*** Sent via Developersdex http://www.developersdex.com ***

Loop & Accumilate e-mail addresses to send to
 

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

*** Sent via Developersdex http://www.developersdex.com ***

Loop & Accumilate e-mail addresses to send to
 

After you used DataAdvanced 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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Les Stout" wrote in message ...
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

*** Sent via Developersdex http://www.developersdex.com ***

Loop & Accumilate e-mail addresses to send to
 

Thanks Ron, will tackle in the morning... :)

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***