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.
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?
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.
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?
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.
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??
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.
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.
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?
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.
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?
Yep, but I think that you can use scheduled tasks to have it open Access automatically - say each time you boot up - although you would have to set that database to automatically open as soon as Access was open.
For instance, to start the Northwind db you would write
"C:\Program Files\Microsoft Office\Office11\MSAccess.exe" "C:\Program Files\Microsoft Office\Office11\Samples\Northwind.mdb"
So does anyone have any ideas for this yet, if so I could use some assistance on implementing it, I will not be shy about saying I know next to nothing about Access 2003.
We have just been told that we are moving to 2007 in less than a month, which in turns means I need to develop courseware and get an action plan. I doubt I will be able to look at this anytime soon.
I thought I would stop by and see if anyone had a chance to look at this yet?? I have for the most part completed my database so all I really need is to implement this feature.
To break it down to any newcomers.
I have a database that a person will use as a contact sheet, they will put the date they contact the employer on the sheet in a field. After a predetermined amount of time, say 5 days, I want the program to email the person who entered the date contacted a reminder to have them contact that employer again.
The school I got to, who I am trying to set this up for, uses Microsoft Outlook Web Access.
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!