Notifying Outlook users of dates entered in Access 1

[hleighmc]

I am designing a database in a construction department where important dates are being missed. I would like to be able to, once start and finish dates for a project are entered in Access, for a notification either in the Calendar, by e-mail or by tasking to be sent to Outlook. Is this possible?

 

[LonnieJohnson]

You can send an email in Access thru a macro or VBA code using the SendObject command.

B-) ljprodev@yahoo.com
ProDev, MS Access Applications

http://www.galaxymall.com/software/PRODEV

 

[nomus1]

I have done a lot with sending e-mail notifications. If you do this, I recommend setting up a user group that you send the e-mail to and not hardcoding the names in the code. I have also done something similar and posted it directly to the users outlook calendar (this would work if you set up a group calendar)

Dim outobj As Outlook.Application
Dim outappt As Outlook.AppointmentItem

If Len(Me.txtDateFollowUP & "&quot > 0 Then
Set outobj = CreateObject("outlook.application&quot
Set outappt = outobj.CreateItem(olAppointmentItem)

With outappt
.start = Me!txtFollowUP & " " & TimeValue("08:00&quot
.Duration = "15"
.subject = "Follow Up Call Scheduled with " & Me.Customer
.ReminderMinutesBeforeStart = "15"
.ReminderSet = True
.Save
End With

Set outobj = Nothing
msgbox "Appointment Added to Outlook!"

End If

Hope this helps

 

[hleighmc]

To Nomus1: That sounds perfect! I'm just not sure where I am supposed to enter the information. Any help would be appreciated. Thanks.

 

[nomus1]

I have always added this code behind either the onexit or after updateevent for the text box where the date is being entered.

Hope this helps