Send Email When...

nhbartos

Board Regular
Joined
May 23, 2015
Messages
148
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!
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Forum statistics

Threads
1,226,693
Messages
6,192,471
Members
453,726
Latest member
JoeH57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top