Question about automatic replies when task is complete

kf4ape
kf4ape used Ask the Experts™
on
I have a form setup in public folders so that everyone can see the status of tasks placed in there, I have it set up with a rule so that when an item is placed in there it shoots back an email stating that the order has been placed...my question is that is there an easy way to shoot an email stating the order is complete and ready for pickup??? I would have used task request however they dont like going to public folders...
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You could create a custom eform. The users could use the eform to submit tasks. The form could contain vbscript to send an email to the person who originally submitted the task when it is marked as complete. I have designed a similar eform based helpdesk application which notifies the user when there task has been completed.

Author

Commented:
Eform??? I created a custom form if that is what you are talking about, forgive me I am a novice in VB...can you shoot me an example??
Sure. I have a control on my form call "Current Status". Here is the portition of code that sends the user a message when the "Current Status" field has been set to "Completed". This is placed under Sub Item_write()

If (Item.UserProperties.Find("Current Status").Value = "Completed") Then
          Set MyItem = Application.CreateItem(0)
          MyItem.Subject = "Task # " & Item.UserProperties.Find("TicketID1").Value & " has been completed"
          MyItem.Body = "Problem Details " & Item.Body & chr(13) & chr(10) _
               & chr(13) & chr(10) _
               & "Assigned To: " & Item.Userproperties.Find("Assigned To").Value & chr(13)& chr(10) _
               & "Actual Hours: " & Item.UserProperties.Find("Actual Hours").Value & chr(13)& chr(10) _
               & "Completion Date: " & Item.UserProperties.Find("Date Complete").Value & chr(13)& chr(10)
          MyItem.To = Item.UserProperties.Find("Submitted By").Value
          MyItem.Send
     End If
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
I have got to be the biggest idiot...I have been trying this for the last hour...and no joy...tossed a couple of message boxes in it and still nothing...ie

If XXX then
msgbox "good"
else
msgbox "bad"
end if

Author

Commented:
I have got to be the biggest idiot...I have been trying this for the last hour...and no joy...tossed a couple of message boxes in it and still nothing...ie

If XXX then
msgbox "good"
else
msgbox "bad"
end if
kf4ape:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
I believe I answered this question.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial