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
.To = rs("firstname") & "." & rs("surname") & "@uk.agimedia.com"
.Subject = "job overdue: " & rs("DecriptionBrief")
.Body = rs("DescriptionFull")
Definition of a Beginner, Someone who doesn't know the rules.
Definition of an Expert, Someone who knows when to ignore the rules.