| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sending a email from inside Excel
What I have done is created a time sheet for a month, and it also gives me
the hours that are worked in a week. Do what I would like to do is when the week goes over 40 hours send a email, a pop-up or some kind of message that this person went over thier time. Can this be done? Thank you Kelly |
|
#2
|
|||
|
|||
|
Hi Kelly
Start here http://www.rondebruin.nl/mail/change.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Kelly Thompson" wrote in message ... What I have done is created a time sheet for a month, and it also gives me the hours that are worked in a week. Do what I would like to do is when the week goes over 40 hours send a email, a pop-up or some kind of message that this person went over thier time. Can this be done? Thank you Kelly |
|
#3
|
|||
|
|||
|
Thank you that is working great, Now how can I make it look at more cells.
Since my timesheets are in months and their are the 4 weeks in each month. Thank you for all the help "Ron de Bruin" wrote: Hi Kelly Start here http://www.rondebruin.nl/mail/change.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Kelly Thompson" wrote in message ... What I have done is created a time sheet for a month, and it also gives me the hours that are worked in a week. Do what I would like to do is when the week goes over 40 hours send a email, a pop-up or some kind of message that this person went over thier time. Can this be done? Thank you Kelly |
|
#4
|
|||
|
|||
|
hi Kelly
Try this If Not Intersect(Range("A1"), rng) Is Nothing Then If Range("A1").Value 200 Then MsgBox "Hi 1" End If If Not Intersect(Range("B1"), rng) Is Nothing Then If Range("B1").Value 200 Then MsgBox "Hi 2" End If -- Regards Ron de Bruin http://www.rondebruin.nl "Kelly Thompson" wrote in message ... Thank you that is working great, Now how can I make it look at more cells. Since my timesheets are in months and their are the 4 weeks in each month. Thank you for all the help "Ron de Bruin" wrote: Hi Kelly Start here http://www.rondebruin.nl/mail/change.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Kelly Thompson" wrote in message ... What I have done is created a time sheet for a month, and it also gives me the hours that are worked in a week. Do what I would like to do is when the week goes over 40 hours send a email, a pop-up or some kind of message that this person went over thier time. Can this be done? Thank you Kelly |
|
#5
|
|||
|
|||
|
Thank you so much for the help I just figured out how to do the other cells
myself. Thanks Again Kelly "Kelly Thompson" wrote: Thank you that is working great, Now how can I make it look at more cells. Since my timesheets are in months and their are the 4 weeks in each month. Thank you for all the help "Ron de Bruin" wrote: Hi Kelly Start here http://www.rondebruin.nl/mail/change.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Kelly Thompson" wrote in message ... What I have done is created a time sheet for a month, and it also gives me the hours that are worked in a week. Do what I would like to do is when the week goes over 40 hours send a email, a pop-up or some kind of message that this person went over thier time. Can this be done? Thank you Kelly |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I get email alerts when dates in excel are nearing? | Excel Discussion (Misc queries) | |||
| Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
| Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
| Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
| How do I cancel sending a spreadsheet by email? | Excel Discussion (Misc queries) | |||
Linear Mode
