Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Email sent based on data
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Email sent based on data
Have you tried the following:
1. Install ELM/PINE/Sendmail or any GNU email app on the desktop 2. Specify the SMPT server for your outgoing email 3. Inside your Excel file write an Auto Open macro that parses the data and identifies the records tha are more than two days old into a text file then zips the txt file as soon as it is written out 4. Invokes a DOS shell and runs a dos command to email the ZIP file (use Shell function in VBA) 5. MS Windows comes with a scheduler (or use an AT scheduler in Windows) to start the Excel file at a certain time of the day/night Hope that helps, -Neil -----Original Message----- I have a spreadsheet which records when certail work comes in to the 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 was completed. What i want to do is when L date is more then 2 days to the issue date (colunm b) is the macro creates an e-mail and sends it to the person it was issued to and also there manager. Also i want it to send an email is blank and there is a 2day differnece between the issue date and todays date. The ammount of data we are looking at varies but there is about 30 orders which come in each day. Is this possible to do? --- Message posted from http://www.ExcelForum.com/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Email sent based on data
I should have quted that my knowledge of macros is limited i have a goo
understanding of some functions but when it comes to more advance procedures i am at a loss. If you can guide me a website that explains this better or display som of the code that would be great. Am a pain i know! -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Email sent based on data
Hi pauluk
Try out this example http://www.rondebruin.nl/sendmail.htm#message Add a function in the C column that produce a "yes" if you want to send the mail -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "pauluk " wrote in message ... I should have quted that my knowledge of macros is limited i have a good understanding of some functions but when it comes to more advanced procedures i am at a loss. If you can guide me a website that explains this better or display some of the code that would be great. Am a pain i know!! --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |