Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Aberdeen, Scotland, UK

    Unanswered: More Email Questions

    I think email questions should get their own forum. There's certainly enough of them.....

    Anyway. We are running Novell GoupWise 6. Is anyone aware of how to send emails though GroupWise? When I try standard methods like "SendObject" I get an error saying "Error stated in previous message" but there was no previous message.

    Has anyone had any experience in this field? I'm using Access 97 but am willing to use 2002 if it's necessary.



  2. #2
    Join Date
    Oct 2002
    Leicester - UK
    if groupwise comes with a vb command librar you can do it the long method
    this example is for outlook but if you've got the library the command shouldn't be too different (i will freely admit that i've never even seen GW)
    Private Sub Form_Open(Cancel As Integer)
        Dim rs As DAO.Recordset
        Dim email As Outlook.MailItem
        If datetest.Value < Now() - 7 Then
           Set email = CreateObject("Outlook.Application").CreateItem(olMailItem)
           Set rs = CurrentDb.OpenRecordset("Overdue", dbOpenSnapshot, dbReadOnly)
            DoCmd.RunSQL ("UPDATE OverdueTest SET OverdueTest.[datetest] = Date();")
            While Not rs.EOF
                With email
                    .To = rs("firstname") & "." & rs("surname") & ""
                    .Subject = "job overdue: " & rs("DecriptionBrief")
                    .Body = rs("DescriptionFull")
                End With
        End If
    End Sub
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

Posting Permissions

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