Hi folks...
I have been reading other threads and other locations online, but they are all assuming I know a lot about VBA, and I do not.
I would appreciate step by step help...
I want to use outlook, and I do not want excel to have to be open to send alerts, but should work when open as well.
I have 100+ customer tabs. Each has 15 target dates. A target date cell and an empty actual date cell.
I would like to send a reminder email, for example, 1 day before target date.
I would like to send a email when the actual date is entered.
I would like to send an email when the activity is past due, past the target date.
Can I sent to multiple email addresses or a distribution list?
How is the text or email commentary added?
I already have this code in as well, and if it needs to be combined, will need help there, too.
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Range("D7").Select
End Sub
Thanks!
I have been reading other threads and other locations online, but they are all assuming I know a lot about VBA, and I do not.
I would appreciate step by step help...
I want to use outlook, and I do not want excel to have to be open to send alerts, but should work when open as well.
I have 100+ customer tabs. Each has 15 target dates. A target date cell and an empty actual date cell.
I would like to send a reminder email, for example, 1 day before target date.
I would like to send a email when the actual date is entered.
I would like to send an email when the activity is past due, past the target date.
Can I sent to multiple email addresses or a distribution list?
How is the text or email commentary added?
I already have this code in as well, and if it needs to be combined, will need help there, too.
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Range("D7").Select
End Sub
Thanks!
