![]() |
How do I build a feature into a cell that would send an email rem.
I have a spreadsheet that tracks the processing of orders from creation to
shipment. At one point in the process, I have to fax shipping notifications. The date this must be done depends on the state where the order is being shipped. First, can I simply set up Excel to send me an email reminder to fax the notification? Second, if the reminder can be done, can I specify when to send it based on state regulations? For example, one state might require a 2-day notification while another requires a 5-day notification. How difficult would it be to customize the reminders (assuming it can be done in the first place) to the requirements of the respective state? |
You can do it by using Microsoft Outlook instead of Outlook Express.
Microsoft Outlook has the functionality of SCHEDULE AND REMINDERS and you can also write comments with the reminder. Abdul Hameed "Jim Johnson" wrote in message ... I have a spreadsheet that tracks the processing of orders from creation to shipment. At one point in the process, I have to fax shipping notifications. The date this must be done depends on the state where the order is being shipped. First, can I simply set up Excel to send me an email reminder to fax the notification? Second, if the reminder can be done, can I specify when to send it based on state regulations? For example, one state might require a 2-day notification while another requires a 5-day notification. How difficult would it be to customize the reminders (assuming it can be done in the first place) to the requirements of the respective state? |
Hi Abdul,
Our company doesn't use Microsoft Outlook. We use Lotus Notes. Is there a way to do this with any email address but not with Outlook? Thanks, Jim "Abdul Hameed" wrote: You can do it by using Microsoft Outlook instead of Outlook Express. Microsoft Outlook has the functionality of SCHEDULE AND REMINDERS and you can also write comments with the reminder. Abdul Hameed "Jim Johnson" wrote in message ... I have a spreadsheet that tracks the processing of orders from creation to shipment. At one point in the process, I have to fax shipping notifications. The date this must be done depends on the state where the order is being shipped. First, can I simply set up Excel to send me an email reminder to fax the notification? Second, if the reminder can be done, can I specify when to send it based on state regulations? For example, one state might require a 2-day notification while another requires a 5-day notification. How difficult would it be to customize the reminders (assuming it can be done in the first place) to the requirements of the respective state? |
All times are GMT +1. The time now is 04:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com