Results 1 to 3 of 3
  1. #1
    Enrightt is offline Novice
    Windows 8 Access 2007
    Join Date
    Oct 2015
    Posts
    10

    Access Form to Automatic Outlook E-mail Reminders

    Hello,



    I have a form with various client information and outstanding balances. I have already setup the code that writes out the Outlook e-mail with the outstanding balance and payment request.

    However, I am trying to take the level of automation one step further and want to integrate an automatic reminder e-mail. I am familiar with what is needed to set-up automatic reminders. Most importantly, I want the reminders to continue the original e-mail chain. I do not want to create a new chain every time an automated e-mail goes out to a client. Is this possible and if so, how? I have looked all over and have not found anything relating to this.

    Thanks! I have learned a ton from this forum and hopefully you guys can help me out with this.

    Peter

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,863
    I have not tried it, but I suspect it is possible. You will want to .Save your outgoing email and then move or copy it to a specific folder. Also, it sounds like you want to look for a reply message in your inbox. I would use unique values within the Subject to help the search for the correct email or if a relevant email exists in the Inbox. I would use tables to log email activity.

    Here is some info that might help you get started working with the MAPIFolder object.
    https://www.accessforums.net/forms/c...tml#post292342

  3. #3
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,859
    Some good suggestions there. The identifier in the subject is probably very important in that it should increment (ABCD456-01, -02, etc.) so you can find the highest in the sequence. Perhaps BCC yourself or a system account and let Outlook store the emails in a specified folder using an Outlook rule. I presume the emails would get too lengthy to just store the text in a memo field that you concatenate based on the identifier?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 11-24-2015, 04:31 PM
  2. Replies: 3
    Last Post: 01-27-2015, 07:40 PM
  3. Replies: 3
    Last Post: 11-12-2014, 11:52 AM
  4. How to e-mail from access to outlook
    By hogue@montana.com in forum Programming
    Replies: 5
    Last Post: 02-17-2012, 12:33 PM
  5. Replies: 16
    Last Post: 03-15-2010, 12:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums