dbTalk Databases Forums  

Email Notification/Reminders

comp.database.ms-access comp.database.ms-access


Discuss Email Notification/Reminders in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Susan
 
Posts: n/a

Default Email Notification/Reminders - 08-20-2003 , 02:32 PM






First, thank you for replies to last post, i havent gotten back
sooner, i apologize..but they have helped me tremendously.

Next question and i will try hard to describe what i am trying to
accomplish..

I have a form i have created in Access. In here we have all our
contact information on each client, physician, pharmaceutical company
etc. After someone from our company speaks with them, they update this
information in the "notes" section, with an area for initials and
date.

I would like to create a F/U (Follow up) section in here to for our
people to type in the date they would like to follow up with this
person.

Maybe I am going way beyond my abilities but ... is there a way to
have an email (or even some other notification reminder) sent on the
date that this follow up date becomes due?
Stumped again....THANKS again.
Susan

Reply With Quote
  #2  
Old   
me
 
Posts: n/a

Default Re: Email Notification/Reminders - 08-20-2003 , 04:52 PM






Yes, you can do that. You can use MAPI to send email from Access or any
other programming language.

I usually call it a BF (bring forward) for the record when you have to take
an action on a record on a specific date.

You will want to have a timer or process that runs on a daily basis in order
to check if any of the records are ready for processing.


"Susan" <swashington (AT) exodon (DOT) com> wrote

Quote:
First, thank you for replies to last post, i havent gotten back
sooner, i apologize..but they have helped me tremendously.

Next question and i will try hard to describe what i am trying to
accomplish..

I have a form i have created in Access. In here we have all our
contact information on each client, physician, pharmaceutical company
etc. After someone from our company speaks with them, they update this
information in the "notes" section, with an area for initials and
date.

I would like to create a F/U (Follow up) section in here to for our
people to type in the date they would like to follow up with this
person.

Maybe I am going way beyond my abilities but ... is there a way to
have an email (or even some other notification reminder) sent on the
date that this follow up date becomes due?
Stumped again....THANKS again.
Susan



Reply With Quote
  #3  
Old   
LWD
 
Posts: n/a

Default Re: Email Notification/Reminders - 08-22-2003 , 12:15 AM



Hi, 'me'

I'm interested in something similar to this but wouldn't have the slightest
idea where to begin to use MAPI.

Access Help shows absolutely nothing for the concept MAPI.

I haven't yet checked Google.

Is this something done directly from Access? directly from Outlook? via 3rd
party software? I'll start researching as well, of course.

L.



Reply With Quote
  #4  
Old   
Domster
 
Posts: n/a

Default Re: Email Notification/Reminders - 08-29-2003 , 07:04 PM



Try starting here:

http://support.microsoft.com/support.../q209/9/48.asp


Domster



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.