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/

.