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

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/

.

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

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/