1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Auto-email Reminder

Discussion in 'Business Applications' started by KaizerDragoon, Oct 7, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. KaizerDragoon

    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.
     
  2. slurpee55

    slurpee55

    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?
     
  3. MRdNk

    MRdNk

    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.
     
  4. slurpee55

    slurpee55

    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.
     
  5. KaizerDragoon

    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.
     
  6. slurpee55

    slurpee55

    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?
     
  7. KaizerDragoon

    KaizerDragoon Thread Starter

    Joined:
    Oct 7, 2008
    Messages:
    8
    Microsoft Outlook Web Access
     
  8. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    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..)
     
  9. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
  10. KaizerDragoon

    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.
     
  11. slurpee55

    slurpee55

    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.
     
  12. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    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.
     
  13. slurpee55

    slurpee55

    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?
     
  14. KaizerDragoon

    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.
     
  15. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    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?
     
  16. Sponsor

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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/757008

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice