Emailing User when Status of Call gets updated.

Reply

Rob Atkinson replied on 01-28-2010 9:28 AM

rated by 0 users

yes just ensure the users email address is in their profile, and ensure you have

Under the admin section

 as this is already programmed in

Reply

jmeiklejohn replied on 01-29-2010 1:22 AM

rated by 0 users

Hi

The emails get sent out when we update the call with additional information. What we now want to do is have an email sent out when we change the status (e.g. from "Open" to "Being Investigated").

I think it is that we need to add something into this bit of code but I'm not sure what we need to put in or where in this section it should go:

If status <> rstDesc("status") Then
          Dim newStat, oldStat
          Set newStat = SQLQuery(cnnDB, "SELECT sname FROM status WHERE status_id=" & status)
          Set oldStat = SQLQuery(cnnDB, "SELECT sname FROM status WHERE status_id=" & rstDesc("status"))
          strChangeNotes = strChangeNotes & Lang(cnnDB, "STATUS_2") & ": " & oldStat("sname") & " => " & newStat("sname") & vbNewLine
          newStat.Close
          oldStat.Close
        End If
    End If

Does this clarify our problem?

Thanks, Jo

Reply

Rob Atkinson replied on 01-29-2010 1:32 PM

rated by 0 users

Hi There,

Now I get you!!

The only problem is that if you update the call as well as change the status it might get a bit messy, so we will need to check if its an update or status change and act accordingly.

Will have a play later and get back to you.

Best

Rob