| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send Email from Excel - but only to people in range
hi all,
am new to coding, any help appreciated. have tried google etc to no avail. List of names in A1:A100 List of either Yes or No in B1:B100 respectively I would like to send an email to everyone in Range A1:A100 that has a 'No' next to their name in column B eg Create a text string of names that meet the 'No' criteria of column B and pass it to Outlook. Any help/code greatly appreciated tia Steve |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Send Email from Excel - but only to people in range
Ron de Bruin's site
http://www.rondebruin.nl/sendmail.htm http://www.rondebruin.nl/index.html an Article by Ron on MSDN: http://msdn.microsoft.com/library/en...odc_xlmail.asp Dick Kusileka's site http://www.dicks-clicks.com You should be able to find most of what you need. -- Regards, Tom Ogilvy Steve wrote in message ... hi all, am new to coding, any help appreciated. have tried google etc to no avail. List of names in A1:A100 List of either Yes or No in B1:B100 respectively I would like to send an email to everyone in Range A1:A100 that has a 'No' next to their name in column B eg Create a text string of names that meet the 'No' criteria of column B and pass it to Outlook. Any help/code greatly appreciated tia Steve |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Send Email from Excel - but only to people in range
Can you do a sort by column B? Then eliminate the No's and send the rest to Outlook
I'm a rookie so perhaps I don't know what I'm talking about |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Send Email from Excel - but only to people in range
http://www.rondebruin.nl/sendmail.htm#message
Perfect Tom...much appreciated thanks steve "Tom Ogilvy" wrote in message ... Ron de Bruin's site http://www.rondebruin.nl/sendmail.htm http://www.rondebruin.nl/index.html an Article by Ron on MSDN: http://msdn.microsoft.com/library/en...odc_xlmail.asp Dick Kusileka's site http://www.dicks-clicks.com You should be able to find most of what you need. -- Regards, Tom Ogilvy Steve wrote in message ... hi all, am new to coding, any help appreciated. have tried google etc to no avail. List of names in A1:A100 List of either Yes or No in B1:B100 respectively I would like to send an email to everyone in Range A1:A100 that has a 'No' next to their name in column B eg Create a text string of names that meet the 'No' criteria of column B and pass it to Outlook. Any help/code greatly appreciated tia Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Send a range via email | Excel Discussion (Misc queries) | |||
| send email to each customer email in excel sheet. | Excel Discussion (Misc queries) | |||
| How to send email to a list of people in excel sheet? | Excel Discussion (Misc queries) | |||
| Trying to send an email with body text, to a range of cells | Excel Discussion (Misc queries) | |||
| body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) | |||
![Steve[_57_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
