Auto-email Reminder

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

KaizerDragoon

Thread Starter
Joined
Oct 7, 2008
Messages
8
Hi everyone. I am currently setting up a database that will hold employer contact information. This document is going to be used to keep track of when a person called the employer, the part that will require some effort and code is setting up a reminder. In this database I need to add a counter or some form of counter that keeps track of how many days its been since the employer has been contacted.

So in one field we have a spot left for Date Contacted. So based off of the information in that Date Contacted, say I contacted an employer today, what I need is for that counter to basically automatically send someone an email when its reached a predetermined amount of days since that employer has been contact for arguments sake lets just say 5 days.

IF anyone can help me with this I would be grateful, Im not very MS access savey. Currently I am working off of MS Access 2003.
 
Joined
Oct 20, 2004
Messages
7,837
Any code will require we know what email program you are using. Outlook, Outlook Express, something else...?
Also, I assume you have the emails in the database as well?
 
Joined
Apr 7, 2007
Messages
439
How is good is Access, at using non-MS based email programs, out of interest?

Welcome to the forums KaizerDragoon.
 
Joined
Oct 20, 2004
Messages
7,837
About the same as Excel - it can be done, but some (e.g. Thunderbird) require a bit of a work-around. I can't speak about all of them, though.
 

KaizerDragoon

Thread Starter
Joined
Oct 7, 2008
Messages
8
Well I work at a college and im not really sure what kind of email they use, its an edu emailing system, but I know that the person recieving the email does use outlook, so its possible.
 
Joined
Oct 20, 2004
Messages
7,837
What the receiver uses is irrelevant. The college probably uses something like Microsoft Enterprise, what matters is, what email client pops open when you want to send an email?
 
Joined
Jul 25, 2004
Messages
5,458
Ding. Nope. Slurp, I don't have time, but check out Ron de Bruin's website. I know, it's Excel, but he's got a routine for sending via CDO. Awesome. Generally and usually works. Although it's difficult as all heck to setup and get working right. There's no GUI and even less ways to check if it works (i.e. error handling sucks). You know it works if you receive the email! LOL!

Also, sounds a lot like something I did for Excel (think the title was something like "set email reminders in Excel"). Don't know if that'd be relevant or not, but sounds very similar. The solution was quite involved.

CDO link: http://www.rondebruin.nl/cdo.htm

Couple related links:
http://forums.techguy.org/business-...-conditions.html?highlight=set+reminder+excel

http://forums.techguy.org/business-...-base-excel.html?highlight=set+reminder+excel (I think more relevant..)
 

KaizerDragoon

Thread Starter
Joined
Oct 7, 2008
Messages
8
Well is there a soultion for doing this with Microsoft Outlook Web Access?? If not or if its too complicated what about setting the access database to send the email to the persons personal email say they have a yahoo account??

Im just thinking of different options.
 
Joined
Oct 20, 2004
Messages
7,837
MS Outlook Web Access is part of (as I suspected) Microsoft Exchange Server, and I think any commands (but not sure) written to call Outlook would work for it also.
I will see if someone I think knows more about this is online.
 

jimr381

Jim
Joined
Jul 20, 2007
Messages
4,193
A lot of the rules that you would setup would be client side only which means Outlook would need to be open and in use. OWA has you authenticate each time and sometimes is set to boot you out after inactivity. So basically it is highly unlikely that you will get this to work via OWA but you should be able to setup an Outlook account using their exchange server and get this to work. I am working on a database right now that will do something similiar to what you are doing, but I am out of the office all week in a MCDST class.
 
Joined
Oct 20, 2004
Messages
7,837
One nice thing about CDO is that it manages to bypass the security warnings you generally get. Could it be configured to bypass OWA? I read that OWA logs you out after a set amount of time of inactivity - could you set up a ping to awaken your account (or keep it active all the time), so to speak, prior to sending the email?
 

KaizerDragoon

Thread Starter
Joined
Oct 7, 2008
Messages
8
Well this isn't something that I need to get done immediately, but sometime within the next week or so would be really nice, because then i need to start actually entering in the information I'm supposed to gather.
 

jimr381

Jim
Joined
Jul 20, 2007
Messages
4,193
I will have to check out the CDO website and see if that is a better option for us. The only problem I will have is that the Access DB or Excel sheet would have to be open right?
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top