Send email remnders from Access

[SpiritedAway]

Hi,

I'm building an appointment reminder db

The idea is that I have a form, [frmjob] - in the form are four fields
[scheduledate] - the date job is due to start
[jobdescription] - description of the job needed doing
[assignto] - email address of the person who will be assigned to do the job.

Can anyone advise or provide any links, references, demos on how the db can automatically send an email when a job is due.

Ideally, i'd like the access to pull the information from the form and populate the email.

So [scheduledate] to be in the emails subject,
[jobdescription] as the main body of the email,
and for access to send the email to the recipient in the [assignedto] field.


I would like the db to automatically send these emails, rather than having to send them manually as their are hundreds of jobs to schedule.


If anyone could give me a pointer in the right direction and give me some advice it would be greatly appreciated.

I'm using Access 2007 and the emails will be sent from Outlook 2007

Thanks once again for any ideas you have.


Spirited Away

 

[dbDamo]

See my post (#10) in this thread:- http://www.access-programmers.co.uk/...411#post923411

To install CDO, go to Start>Settings>Control Panel>Add or Remove programs. With "Change or Remove Programs" selected, scroll down the list of currently installed programs, highlight Microsoft Office and press "Change" - this opens up Microsoft Office Setup.

Select the "Add or Remove features" radio button and press "Next".

Press the + button next to Microsoft Outlook

Click on the drop down list next to "Collaboration Data Objects" and select "Run all from My Computer".

Press Update - this installs CDO.

Make sure to set your references after

 

[SpiritedAway]

Thanks dbDamo

I've looked at the thread - the code allows access to populate outlook email with subject, body message and email.

But will this code look for due date for example 06-Sept-2010 and automatically create an email with info pulled from the form and send to the recipient without any imput from me -

so that the end user will be sitting at his pc, get an email from the database saying such and such a job is due to be started today?

Thanks once again for your input on this.

 

[dbDamo]

No, the query you use as the source for the email will be filtered by due date, i.e. Due Date = Date()


If you want absolutely no involvement then you need to run this code through an AutoExec macro and use a scheduling program to open the Database every morning