Generate Email from form problem

spilwayboy

Registered User.
Local time
Today, 19:52
Joined
Dec 17, 2002
Messages
17
I have a form that is set up with Company information as one tab and another tab at the top is contacts so that there can be multiple contacts for each company, anywho this is the problem. I have a field that is a text field holding email addresses for each contact and have the following code in the double click of the textbox containing the email address:

Private Sub EmailAddress_DblClick(Cancel as Integer)
On Error GoTo ErrorHandler
DoCmd.SendObject , , , Me.Form![EmailAddress], , , , , , True
ExitHere:
ErrorHandlerExit:
Exit Sub

ErrorHandler:
If Err.Number = 2501 Then
stdresponse = acDataErrContinue
Exit Sub
MsgBox Err.Description
Resume ErrorHandlerExit

Exit Sub
End If
End Sub

I added the outlook data reference library to the project and the code I have works in another database but in this database it gives the following error "A Problem occurred while access was communicating with the OLE server or Active X control". Can anyone point me in the right direction as to why this is happening in this database? Thank you for all of the help.

Spil
 
Last edited:

Users who are viewing this thread

Back
Top Bottom