How to send an email from access

[slacey825]

Ok so I have done a minimal amount of vba coding for access and really need some help. I am using access and outlook 2007.

I have a database that I need to send a automatic email one time each time a project completion date is surpassed.

The table name is tbl_Consultant_Contact and the date I have put in is ConsultantCompletionDate. I have also included a yes/no check box for when the project has been completed so an email wont need to be sent again.

I need an email to be sent for each project when and if the consultantcompletiondate is pasted the current date there are alot of projects not just one. I only need this email to send to 2 people can someone please help me with the vba coding.

 

[jedraw]

There is a sample here, that you can study and download.

http://www.blueclaw-db.com/access_email_send_outlook.htm

 

[slacey825]

Thank you I am having most of the problem with trying to figure out how to only send the email when the day has lapsed I ran a query to show me which ones were over due but that makes them -1 so they wont show up on a form anymore. I guess I am kinda lost I dont no where to go for help

 

[jedraw]

So, if I understand, if the completion date is Today(Date), then send the email and set the checkbox.

The general logic is something like

If the CompletionDate = Date AND Checkbox is NOT checked
then
--send the email
--set/check the checkbox

or are you saying, don't send it when the CompletionDate and date are equal, wait 1 more day (after the day has lapsed)?

So you could say

If the CompletionDate = Date - 1 AND Checkbox is NOT checked

 

[assets]

What email is it going to be for.

Outlook is easier.

With MAPI like GroupWise then it harder. If it GroupWise I can provide code. It will attatch.

Never give up never give in.

There are no short cuts to anything worth doing