Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet which records when certail work comes in to th
office. So it is as so A=ref b= date c=time d =request method e intials of person issued to. in colume L is the date the order wa completed. What i want to do is when L date is more then 2 days to the issue dat (colunm b) is the macro creates an e-mail and sends it to the person i was issued to and also there manager. Also i want it to send an email is blank and there is a 2day differnec between the issue date and todays date. The ammount of data we are looking at varies but there is about 3 orders which come in each day. Is this possible to do -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic populate Sheet2 with data from Sheet1 based on criteria. | Excel Discussion (Misc queries) | |||
Automatic email based on date | Excel Discussion (Misc queries) | |||
Auto-generate OUTLOOK email based upon EXCEL Workbook data | Excel Discussion (Misc queries) | |||
Automatic data entry in alternate cells based on drop-down menu se | Excel Worksheet Functions | |||
Automatic Email Link | Excel Discussion (Misc queries) |