Can this be done? mail to not go out on a predefined date i

winrz

Board Regular
Joined
Sep 4, 2002
Messages
106
Many thanks to those that have taken the time to answer my other questions out there.

I have a simple linear timeline set up with conditional formatting set to change the bar from green to red as the days progress.

What i would like to do - is automatically send a reminder email (subject only) to a recipient(s) when the due date comes for a handful of tasks so they wont forget. BUT, if they click a macro button under the task - indicating that the task has been completed - the email will NOT be sent. is this possible? I am not positive on writing the code to generate an email but i am getting bits and pieces here and there. what i dont know is how to stop a process from triggering.
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

ldmccracken

New Member
Joined
Oct 29, 2002
Messages
4
I use the DoCmd.SendObject to do emails in an access form. You can set up "If/thens" or what ever within the VB code. I've not done any VB in excel but if you think this might work I'll send you what I did
 

winrz

Board Regular
Joined
Sep 4, 2002
Messages
106
OK i created an email from within excel. Now my only question is - how do you trigger the email macro on a given date and interrupt it if a macro button is pushed? sorry about the Excel 101 questions.
 

Forum statistics

Threads
1,144,741
Messages
5,726,017
Members
422,653
Latest member
mntsiki

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
Top