| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Loop & Accumilate e-mail addresses to send to
Thanks Ron, will tackle in the morning... :)
Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bypass: A program is trying to send mail using Item.Send prompt | Excel Discussion (Misc queries) | |||
| A program is trying to send mail using Item.Send | Excel Programming | |||
| How to send specific cell ranges to multiple e-mail addresses | Excel Programming | |||
| How send e-mail to a group of addresses on Excel worksheet? | Excel Discussion (Misc queries) | |||
| loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
![Les Stout[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
