Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto generate email
Hi All, I have a register of items stored in an excel file. Each of the items has a different date associated with them and I would like to be able to get Excel to generate emails (all to the same address) notifying someone of the item number once the date is within X days. I am fairly familiar with excel so I have no problem in writing formulas which identify when the X (currently 30, but could change in the future) days warning period has started. The problem is that currently someone must open the workbook and examine the lookup page to see if any actions are required. It would save a lot of time if I could get the workbook to generate emails. All help warmly received... Cheers. -- Phil P ------------------------------------------------------------------------ Phil P's Profile: http://www.excelforum.com/member.php...o&userid=35316 View this thread: http://www.excelforum.com/showthread...hreadid=550928 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto generate email
Phil P wrote:
Hi All, I have a register of items stored in an excel file. Each of the items has a different date associated with them and I would like to be able to get Excel to generate emails (all to the same address) notifying someone of the item number once the date is within X days. I am fairly familiar with excel so I have no problem in writing formulas which identify when the X (currently 30, but could change in the future) days warning period has started. The problem is that currently someone must open the workbook and examine the lookup page to see if any actions are required. It would save a lot of time if I could get the workbook to generate emails. All help warmly received... Cheers. Take a look at http://www.rondebruin.nl/sendmail.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generate Auto Order Number | Excel Discussion (Misc queries) | |||
sending email from excel not working | Excel Discussion (Misc queries) | |||
Auto Email | Excel Discussion (Misc queries) | |||
Move a Column of 500 Email Addresses into BCC Field of an Email | Excel Worksheet Functions | |||
body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) |