LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic populate Sheet2 with data from Sheet1 based on criteria. Saurabh Khanna. Excel Discussion (Misc queries) 2 December 30th 08 01:19 PM
Automatic email based on date Excel Help! Excel Discussion (Misc queries) 3 April 21st 08 06:34 PM
Auto-generate OUTLOOK email based upon EXCEL Workbook data Henn9660 Excel Discussion (Misc queries) 3 April 11th 08 08:05 PM
Automatic data entry in alternate cells based on drop-down menu se silence13 Excel Worksheet Functions 3 March 23rd 07 03:15 AM
Automatic Email Link Seorges Excel Discussion (Misc queries) 1 September 5th 06 01:08 AM


All times are GMT +1. The time now is 01:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"