View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pauluk[_8_] pauluk[_8_] is offline
external usenet poster
 
Posts: 1
Default 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