SendObject and attach file (MS Access 97)

Topic

New Reply

I have an Access 97 application running on a locked down NT system. On this system they now have Netscape. I’ve used the Outlook object to create robust emails, but Outlook is not on this system and Netscape doesn’t appear to have any objects that it exposes. If I try to use the Outlook object it tells me a required DLL is missing.

The SendObject method appears to be very limited. I need to send an email with an attachment, and I appear to only have SendObject available to me to do this. Is there a way to accomplish this?

Reply | Quote

Replies

You may have to resort to SMTP. Netscape is an Internet Mail Access Protocol version 4 (IMAP4) client.

Reply | Quote

Okay, so I’m definitely barking up the wrong protocol with Netscape. You mention STMP, am I going to have to have an Outlook object in order to make that work?

Reply | Quote

Here’s a little stub that I use in an application. On my system (before I loaded LookOut as an experiment…), it would launch my preferred email (Pegasus). On the client’s machine (he uses LookOut ), it would launch his preferred email software. Hope it works for you:

Private Sub cmdEmail_Click()
Dim sText As String

If Len(Me![uFrmContactSUB].Form!) Then
sText = Me![uFrmContactSUB].Form!
End If

If Len(sText) Then
sText = “mailto:” & sText
Call ShellExecute(Me.Hwnd, “open”, sText, _
vbNullString, vbNullString, 1)
End If

End Sub

Reply | Quote

No, SMTP is an internet protocol. You should be able to use it with Netscape as well. Here’s a link to a article that contains a definition and links on SMTP. It might be of some use to you. You might also want to take a look at Quiksoft.com. They have a product called EasyMail Objects, which contains an SMTP COM object that you can easily address in code to send internet mail messages.

Reply | Quote