Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Auto send message when date from form is reached.

Posted on 2003-03-25
Medium Priority
Last Modified: 2013-12-18
I have a form which I would like to have an automatic email reminder message sent to a person listed from the form 2 days before a date field from that form is reached. I also would like this to be disabled if the person marks this task as complete before the date of the reminder is reached.

Thanks all.
Question by:DWR
LVL 24

Accepted Solution

HemanthaKumar earned 1000 total points
ID: 8206126
Create agent, that will run daily

Click Add Search button, and Choose "By Field", And then the date field to look for, select "is in the Last" and set value as 2. Again click Add Search button and choose "By Field" and now the field representing task and choose "Does not contain" and the value.

Now in program pane, choose simple actions and Add Action, choose Send Mail Message . Fill out necessary information and save it and Monitor.


Author Comment

ID: 8218132
Thanks, Worked great.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question