| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send email based on date value
Hi all,
I have a spreadsheet that stores re-certification details for people. What I need to be able to do is look in a cell in a row, and if the date in that cell is within 90 days of todays date, send an email using an email address stored in another cell of the same row. I have the code for the email worked out okay, but I can't figure how to select which people (rows) to send the email to Thanks in advance for your help. Cheers |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Send email based on date value
hi Billie
For example this http://www.rondebruin.nl/mail/folder3/message.htm In column C :yes or no ( if the value is yes it will create a mail) In column C use a formula like this with the dates in D for example =IF((D1-TODAY())90,"No","Yes") -- Regards Ron De Bruin http://www.rondebruin.nl "Billie Mac" wrote in message ... Hi all, I have a spreadsheet that stores re-certification details for people. What I need to be able to do is look in a cell in a row, and if the date in that cell is within 90 days of todays date, send an email using an email address stored in another cell of the same row. I have the code for the email worked out okay, but I can't figure how to select which people (rows) to send the email to Thanks in advance for your help. Cheers |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Send email based on date value
Ron,
Thanks very much for your help ... it works like a dream. I have now got it set up so that when the spreadsheet is open, code runs and pops up a message box telling me there are x staff requiring recert, and asking if I want to send reminder emails. If I select yes, the rest of the code runs and puts "Yes" in and "Email Sent?" cell, so that the same record won't get picked up by the msgbox on next startup. Thanks again, "Ron de Bruin" wrote: hi Billie For example this http://www.rondebruin.nl/mail/folder3/message.htm In column C :yes or no ( if the value is yes it will create a mail) In column C use a formula like this with the dates in D for example =IF((D1-TODAY())90,"No","Yes") -- Regards Ron De Bruin http://www.rondebruin.nl "Billie Mac" wrote in message ... Hi all, I have a spreadsheet that stores re-certification details for people. What I need to be able to do is look in a cell in a row, and if the date in that cell is within 90 days of todays date, send an email using an email address stored in another cell of the same row. I have the code for the email worked out okay, but I can't figure how to select which people (rows) to send the email to Thanks in advance for your help. Cheers |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Send email based on date value
Thanks for the feedback
I think I add a example like this also on my page -- Regards Ron De Bruin http://www.rondebruin.nl "Billie Mac" wrote in message ... Ron, Thanks very much for your help ... it works like a dream. I have now got it set up so that when the spreadsheet is open, code runs and pops up a message box telling me there are x staff requiring recert, and asking if I want to send reminder emails. If I select yes, the rest of the code runs and puts "Yes" in and "Email Sent?" cell, so that the same record won't get picked up by the msgbox on next startup. Thanks again, "Ron de Bruin" wrote: hi Billie For example this http://www.rondebruin.nl/mail/folder3/message.htm In column C :yes or no ( if the value is yes it will create a mail) In column C use a formula like this with the dates in D for example =IF((D1-TODAY())90,"No","Yes") -- Regards Ron De Bruin http://www.rondebruin.nl "Billie Mac" wrote in message ... Hi all, I have a spreadsheet that stores re-certification details for people. What I need to be able to do is look in a cell in a row, and if the date in that cell is within 90 days of todays date, send an email using an email address stored in another cell of the same row. I have the code for the email worked out okay, but I can't figure how to select which people (rows) to send the email to Thanks in advance for your help. Cheers |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Send email based on date value
Done
http://www.rondebruin.nl/mail/folder3/message.htm -- Regards Ron De Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Thanks for the feedback I think I add a example like this also on my page -- Regards Ron De Bruin http://www.rondebruin.nl "Billie Mac" wrote in message ... Ron, Thanks very much for your help ... it works like a dream. I have now got it set up so that when the spreadsheet is open, code runs and pops up a message box telling me there are x staff requiring recert, and asking if I want to send reminder emails. If I select yes, the rest of the code runs and puts "Yes" in and "Email Sent?" cell, so that the same record won't get picked up by the msgbox on next startup. Thanks again, "Ron de Bruin" wrote: hi Billie For example this http://www.rondebruin.nl/mail/folder3/message.htm In column C :yes or no ( if the value is yes it will create a mail) In column C use a formula like this with the dates in D for example =IF((D1-TODAY())90,"No","Yes") -- Regards Ron De Bruin http://www.rondebruin.nl "Billie Mac" wrote in message ... Hi all, I have a spreadsheet that stores re-certification details for people. What I need to be able to do is look in a cell in a row, and if the date in that cell is within 90 days of todays date, send an email using an email address stored in another cell of the same row. I have the code for the email worked out okay, but I can't figure how to select which people (rows) to send the email to Thanks in advance for your help. Cheers |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Send email based on date value
"Ron de Bruin" wrote: Done http://www.rondebruin.nl/mail/folder3/message.htm -- Regards Ron De Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Thanks for the feedback I think I add a example like this also on my page -- Regards Ron De Bruin http://www.rondebruin.nl "Billie Mac" wrote in message ... Ron, Thanks very much for your help ... it works like a dream. I have now got it set up so that when the spreadsheet is open, code runs and pops up a message box telling me there are x staff requiring recert, and asking if I want to send reminder emails. If I select yes, the rest of the code runs and puts "Yes" in and "Email Sent?" cell, so that the same record won't get picked up by the msgbox on next startup. Thanks again, "Ron de Bruin" wrote: hi Billie For example this http://www.rondebruin.nl/mail/folder3/message.htm In column C :yes or no ( if the value is yes it will create a mail) In column C use a formula like this with the dates in D for example =IF((D1-TODAY())90,"No","Yes") -- Regards Ron De Bruin http://www.rondebruin.nl "Billie Mac" wrote in message ... Hi all, I have a spreadsheet that stores re-certification details for people. What I need to be able to do is look in a cell in a row, and if the date in that cell is within 90 days of todays date, send an email using an email address stored in another cell of the same row. I have the code for the email worked out okay, but I can't figure how to select which people (rows) to send the email to Thanks in advance for your help. Cheers |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Send email based on date value
This is for Outlook, can you please advise for Lotus Notes.
"Ron de Bruin" wrote: Done http://www.rondebruin.nl/mail/folder3/message.htm -- Regards Ron De Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Thanks for the feedback I think I add a example like this also on my page -- Regards Ron De Bruin http://www.rondebruin.nl "Billie Mac" wrote in message ... Ron, Thanks very much for your help ... it works like a dream. I have now got it set up so that when the spreadsheet is open, code runs and pops up a message box telling me there are x staff requiring recert, and asking if I want to send reminder emails. If I select yes, the rest of the code runs and puts "Yes" in and "Email Sent?" cell, so that the same record won't get picked up by the msgbox on next startup. Thanks again, "Ron de Bruin" wrote: hi Billie For example this http://www.rondebruin.nl/mail/folder3/message.htm In column C :yes or no ( if the value is yes it will create a mail) In column C use a formula like this with the dates in D for example =IF((D1-TODAY())90,"No","Yes") -- Regards Ron De Bruin http://www.rondebruin.nl "Billie Mac" wrote in message ... Hi all, I have a spreadsheet that stores re-certification details for people. What I need to be able to do is look in a cell in a row, and if the date in that cell is within 90 days of todays date, send an email using an email address stored in another cell of the same row. I have the code for the email worked out okay, but I can't figure how to select which people (rows) to send the email to Thanks in advance for your help. Cheers |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Send email based on date value
This is for outlook, can you please let me know this for Lotus Notes
"Ron de Bruin" wrote: Done http://www.rondebruin.nl/mail/folder3/message.htm -- Regards Ron De Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Thanks for the feedback I think I add a example like this also on my page -- Regards Ron De Bruin http://www.rondebruin.nl "Billie Mac" wrote in message ... Ron, Thanks very much for your help ... it works like a dream. I have now got it set up so that when the spreadsheet is open, code runs and pops up a message box telling me there are x staff requiring recert, and asking if I want to send reminder emails. If I select yes, the rest of the code runs and puts "Yes" in and "Email Sent?" cell, so that the same record won't get picked up by the msgbox on next startup. Thanks again, "Ron de Bruin" wrote: hi Billie For example this http://www.rondebruin.nl/mail/folder3/message.htm In column C :yes or no ( if the value is yes it will create a mail) In column C use a formula like this with the dates in D for example =IF((D1-TODAY())90,"No","Yes") -- Regards Ron De Bruin http://www.rondebruin.nl "Billie Mac" wrote in message ... Hi all, I have a spreadsheet that stores re-certification details for people. What I need to be able to do is look in a cell in a row, and if the date in that cell is within 90 days of todays date, send an email using an email address stored in another cell of the same row. I have the code for the email worked out okay, but I can't figure how to select which people (rows) to send the email to Thanks in advance for your help. Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I get excel to send an email based on a cell result? | Excel Discussion (Misc queries) | |||
| Can Excel auto-send an email on a given date? | Excel Discussion (Misc queries) | |||
| Send Email Based on Spreadsheet Criteria | Excel Programming | |||
| automatically send email in excel based on value/macro guru stuff | Excel Programming | |||
| Using VBA to send email based on form response | Excel Programming | |||
![Billie Mac[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
