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

    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.

    Thanks

    John

  2. #2
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    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)
    Code:
    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") & "@uk.agimedia.com"
                    .Subject = "job overdue: " & rs("DecriptionBrief")
                    .Body = rs("DescriptionFull")
                    .Send
                End With
                rs.MoveNext
            Wend
            rs.Close
        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
  •