Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jim Johnson
 
Posts: n/a
Default 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?
  #2   Report Post  
Abdul Hameed
 
Posts: n/a
Default

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?



  #3   Report Post  
Jim Johnson
 
Posts: n/a
Default

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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel should not delete document after trying to send email 4rs Excel Discussion (Misc queries) 0 January 14th 05 04:39 AM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 07:18 AM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM
Is there a way to link a received outlook email to a cell? Robert Kaplan Excel Worksheet Functions 1 October 31st 04 08:22 AM
VLookup resulting in a blank cell... KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM


All times are GMT +1. The time now is 09:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"