| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
email Notification from Excel
I have created a spreadsheet that flags up items that are due a service by a
certain date. The cell then changes to blue when the item is coming close to its due date and then changes to red if the item is overdue. Is there a way of linking this info to Outlook to send me an email or notice when the item is approaching its due date? Thanks in advance BT |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
email Notification from Excel
In the VBA editor (alt F11) make a link to the Microsoft Outlook 11.0 object library and then have a look in the help in "About using e-mail and Outlook features in Excel " -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=563167 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| some email addresses aren't blue keyed in Excel, why? | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Copy Name and email address from web sites to excel sheet | Excel Discussion (Misc queries) | |||
| How do I automatically send daily email of updated Excel workbook. | Excel Discussion (Misc queries) | |||
Linear Mode
