Code to clear certain fields in Outlook Form

D

Delnang

I have a text box for employee number. This field is used to address the CC
field. If the employee number is typed incorrectly and therefore cannot be
resolved and error message show. What I'd like to do is after the message is
acknowledged by the user the employee number field, To, and CC fields are
cleared. Is there code I can add to the jscript to clear those fields?

Angie
 
D

Delnang

The code reads as follows:
Function Item_Send()
Const olCc = 2
Set objRecip = Item.Recipients.Add
(Item.UserProperties("ManagerEmployeeNumber2"))
If objRecip.Resolve Then
objRecip.Type = olcc
Else
MsgBox "Manager Employee Number is either not valid or blank. Please enter
a valid employee number."
Item_Send = False
End If
End Function

The error message would be what's in the MsgBox line of code.

Thanks,
Angie
 
S

Sue Mosher [MVP]

If the recipient doesn't resolve, you should be able to call
objRecip.Delete. If you want to clear all recipients (which would seem to
make more work for the user), set the value of the To and CC properties to
"".

And that's VBScript code that an Outlook form uses, not JScript.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
 
D

Delnang

Sue - Thank you!!! I'll remember that...VBScript not JScript. I think I
have one last question. The VBScript I have now is as follows:

Function Item_Send()
Const olCc = 2
Set objRecip = Item.Recipients.Add
(Item.UserProperties("ManagerEmployeeNumber2"))
If objRecip.Resolve Then
objRecip.Type = olcc
Else
MsgBox "Manager Employee Number is not valid, blank or contains the ""e"".
Please enter a valid employee number."
Item_Send = False
objRecip.Delete
Item.UserProperties("EmployeeNumber")= ""
End If
End Function

What is happening now, is that I can enter a valid Employee Number, but all
other fields (except the Memo field) is locked (won't let me backspace or
highlight/edit). If I were to click in the Memo field then one of the other
fields, I can edit their content. Is there a way the fields can be editible
without having to click the Memo field first?
Angie
 
D

Delnang

From a user's perspective, it is right after he/she clicks the message box
which would read, "Manager Employee Number is not valid..." Once the OK
button on the "error" is clicked, their cursor goes to the employee number
field. User is allowed to type a new value in Employee Number. However, all
other fields are "locked" meaning one could put their cursor in a field /
backspace or highlight and click delete but nothing happens. However, if
(the user) clicks within the Memo field then out to one of the other fields
(i.e. name, d.o.b) the field is "unlocked" editable and one can put their
cursor in a field and backspace or highlight and click delete.
 
S

Sue Mosher [MVP]

I have no idea why other controls would be responsive, unless you have some
code on the item that sets those controls to read-only.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top