S
s_smith_iet
I need a macro that will send an email to people if:
sheet Main in workbook NPI data entry form has the number 45 in Cell
A3
I need the email to say something like this:
Attention:
The chamber now has ran 45 cycles since last maintenance.
ALso I need another macro that sends an email once the maintenance is
completed..they would click a button that brings up a bunch of dialog
boxes that put the machine name, the maintenance performed, the date,
and the person who complete the task in sheet maintenance 1 A2, B2,
C2, D2, and E2.
Any help would be great
sheet Main in workbook NPI data entry form has the number 45 in Cell
A3
I need the email to say something like this:
Attention:
The chamber now has ran 45 cycles since last maintenance.
ALso I need another macro that sends an email once the maintenance is
completed..they would click a button that brings up a bunch of dialog
boxes that put the machine name, the maintenance performed, the date,
and the person who complete the task in sheet maintenance 1 A2, B2,
C2, D2, and E2.
Any help would be great