Send Email via Lotus Notes From Access2000/97

[RobReid]

Hi anybody,
I am trying to send a message through email based upon contents of a form. I can get this to work with Outlook but client is using lotus notes as email carrier.
I have tried changing WIN.ini settings pointing to Mapivi32.dll but still does not want to work.
Outlook is also installed on the server.
Any ideas much appreciated.

 

[DougP]

Not sure what you mean "Can get it to work with Outlook"

What happens? does it show up in the outbox of Outlook???

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[RobReid]

Thanks for the enquiry DougP.
When I run my piece of code behind my button (shown below) I get all the details entered into the 'Compose Message' box of Outlook when I am using an Outlook only system.
With Lotus Notes I get nothing. Message disappears.

Code is:
Private Sub Command107_Click()
Dim callermail As String
Dim txtCallID As Integer
callermail = DLookup("CallerInternalEMail", "tblCallers", "CallerID = '" & Forms!frmCallsAdd!Caller & "'&quot
txtCallID = Forms!frmCallsAdd!CallID
DoCmd.SendObject acSendNoObject, , , callermail, , , "Help Desk Call Recorded", "Your call has been recorded in the Help Desk database. It will be dealt with as quickly as possible. Please quote Call Reference " & txtCallID & " when contacting the Help Desk", False
End Sub