Linking MS access to MS outlook

[jamespeters01]

Hi,

This might sound like a strange request.
In my database we log on customers orders with a Delivery required date. We would like either a message in Outlook or a message in Access to pop up at us on the date entered in the Requred date field.

Is this possible ? Any ideas ?


Cheers

James

 

[edge2000]

You could use a timer event on an Access form that is always open in the app ie Menu to check the table, but this requires the app to be running all the time.

Or

In the modules section goto references and find the Microsoft Outlook object library, this will then allow you to read and write data to most Outlook functions such as email & calendar.
~~ A sample
Dim olkmail As New clsOutlookMail

olkmail.StartOutlook True
olkmail.Recipients = Me!EMail 'txtRecipients
olkmail.Subject = "GDN Note From XXX " & Format(glGDNID)
strMsg = "Attachment Of GDN Note Requires Access Snapshot Viewer" & Chr$(10) & Chr$(13) & _
"If you do not have the viewer click

http://www.completebs.com/download/viewer97.exe"

& Chr$(10) & Chr$(13) & _ "to download and then install by running the program Viewer97." & Chr$(10) & Chr$(13)
olkmail.Body = strMsg 'txtBody
olkmail.Attachment = "C:\Temp\GDN" & Format(glGDNID) & ".SNP" 'txtAttachment
olkmail.SendMail
Dave
dab@completebs.com

http://www.completebs.com

See website for more info but we can develop most things for most people.