Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Serbia and Montenegro (Yugoslavia)
    Posts
    342
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SendObject and attach file (MS Access 97)

    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?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SendObject and attach file (MS Access 97)

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

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Serbia and Montenegro (Yugoslavia)
    Posts
    342
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SendObject and attach file (MS Access 97)

    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?

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SendObject and attach file (MS Access 97)

    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![email]) Then
    sText = Me![uFrmContactSUB].Form![email]
    End If

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

    End Sub
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SendObject and attach file (MS Access 97)

    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 <A target="_blank" HREF=http://www.quiksoft.com/>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.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •