Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet that feeds from an Access Database.
Only certain records are shown, it refreshes every minute and the column "TIMER" shows the minute difference between the time the call came in and NOW(). What I'm trying to do is send and email when a record reaches 15 minutes...like if it's been on the spreadsheet for 15 minutes, an email goes to a particular address. I need an "IF" statement to do this. There are usually 1 to 5 records on the spreadsheet. I need something like: If any cell in TIMER column = 15 then send the Range of that record (like A4:K4) to with "NOC TIMER" in the subject line. Help? Thank you in advance for any help you can give me. Gee. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
send email to each customer email in excel sheet. | Excel Discussion (Misc queries) | |||
Excel VBA macro to send email attachment from default email client | Excel Programming | |||
Send data from Excel in email from specific email address | Excel Programming | |||
send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
send email with email addresses in a range of cells | Excel Programming |