custom form failed to open on outlook 2010

Status
Not open for further replies.
P

p.andrew



Hi there,

We have created a custom form (created with VBscript) that works ok with outlook 2003 and 2007.

here's how it works:
someone open up the form and fills in the details, send to the authorized officer the officer will then open up the form and decides whether to APPROVE or DENY if DENY, send notification to sender if APPROVE, forward the form to a contact called "Purchase Requests Approval"
but for Outlook 2010 client, this will return an error similar to this:

Item can't be opened due to invalid e-mail account

Any idea?

Below is the script:

Option Explicit

'
' Send only to the first person in the To field,
' Save other people in the To field into the RouteTo field.
'
Function Item_Send()
Dim i
Dim bDelete
Dim prpRouteTo
i = InStr(Item.To, ";")
If i = 0 Then
i = InStr(Item.To, ",")
End If
If i Then
Set prpRouteTo = Item.UserProperties("RouteTo")
prpRouteTo.Value = Mid(Item.To, i + 1)
bDelete = False
i = 1
While i <= Item.Recipients.Count
If Recipients.Item(i).Type = 1 Then ' olTo
If bDelete Then
Recipients.Item(i).Delete
Else
i = i + 1
bDelete = True
End If
Else
i = i + 1
End If
Wend

Else
Set prpRouteTo = Item.UserProperties("RouteTo")
prpRouteTo.Value = ""
End If
Item.UserProperties("RouteTo") = Item.UserProperties("RouteTo") + ";Purchase Requests Approval"
End Function

'
' Route message to people in the RouteTo field
'
Function Item_CustomAction(ByVal Action, ByVal NewItem)
Dim prpRouteTo
Dim i
Select Case Action.Name
Case "APPROVE"
Set prpRouteTo = NewItem.UserProperties("RouteTo")
If instr(prpRouteTo,"Purchase Request Approval") = 2 AND Item.UserProperties.find("Software").value = True then
newitem.cc = "helpdesk@domain.com"
End If
If prpRouteTo.Value <> "" Then
Item_CustomAction = True
NewItem.To = prpRouteTo.Value
prpRouteTo.Value = ""
Item.Delete
Else
Item_CustomAction = False
End If
Case "DENY"
NewItem.Body = "Your purchase request that started with " & item.userproperties.find("OrderQuantity1") & " " & item.userproperties.find("ItemRequested1") & " has been denied"
Item.Delete
Case Else
Item_CustomAction = True
End Select
End Function

 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
I Error saving screenshots in a custom form in outlook 2016, outlook 365 - ok in outlook 2013, outlook 2010 Outlook VBA and Custom Forms 5
M VbScript for Command Button on Contacts Custom Form Using Outlook 1
G Other users can't see P.2 with custom fields in Form Outlook VBA and Custom Forms 0
O Create a custom contact form - questions before messing things up... Outlook VBA and Custom Forms 4
L Custom Form Tutoral? Outlook VBA and Custom Forms 6
D Lost Access to Custom Form Outlook VBA and Custom Forms 4
M vCard does not have user-defined fields from my custom contact form (365) Using Outlook 1
S Outlook Custom Form Scripting only working when clicking on "Run this form" Outlook VBA and Custom Forms 2
Victor_50 Outlook 2013 Custom Contact Form starts with "E-mail 2" Outlook VBA and Custom Forms 2
C Custom Form (seperate layout pages and message reading pane) Outlook VBA and Custom Forms 0
C Reading Pane for Custom Form Outlook VBA and Custom Forms 2
N Custom Form Controls Not Visible To Recipient Outlook VBA and Custom Forms 3
Randy Redekopp How To Merge Contact Info to Email Custom Form Template Using Outlook 2
D Problem with custom form including _DocSiteControl1 Outlook VBA and Custom Forms 0
C Custom Outlook Form - Populate Information from Radio Button / Check Box Using Outlook 0
W Message class changes of a custom form changes to the default form Using Outlook 2
A Possible to hide ribbon with custom appointment form? Outlook VBA and Custom Forms 3
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
Andrew Quirl Custom form to route requests based on input criteria Outlook VBA and Custom Forms 1
D Using a VBA Custom Form to Send Reoccurring Email Upon Task Completion Outlook VBA and Custom Forms 4
W Setting up a custom form Outlook VBA and Custom Forms 2
A Greyed out checkbox in custom form Outlook VBA and Custom Forms 4
Z Outlook Custom Form: Adding Dropdown(Project Code) at the end of subject Outlook VBA and Custom Forms 0
Z Adding dropdown list using custom form Outlook VBA and Custom Forms 7
J autocomplete function in custom form Using Outlook 1
D Custom form with html hyperlink Outlook VBA and Custom Forms 7
D populating listbox on custom form from Access Outlook VBA and Custom Forms 7
D Custom Form Accept and Reject Command buttons Outlook VBA and Custom Forms 2
D create an html table in outlook custom form 2010 using vba in MsAccess Outlook VBA and Custom Forms 7
Potty Ash MS Outlook 2010 custom form - validation or formula to request user to check a checkbox Outlook VBA and Custom Forms 16
J Custom form code doesn't run Outlook VBA and Custom Forms 2
R Custom Contact Form how to update when loaded. Outlook VBA and Custom Forms 6
G Copy Contact field to Appointment Custom Form Field Outlook VBA and Custom Forms 2
S Custom form with dropdown Using Outlook 0
P Custom form reverts from task Outlook VBA and Custom Forms 1
L Create Custom Form Using Outlook 0
L Outlook Custom Form Using Outlook 2
Diane Poremsky The custom form cannot be opened. Outlook will use an Outlook form instead. New Slipstick.com Articles 0
Y Creating custom appointment request form with multiple mail recipients Outlook VBA and Custom Forms 5
J Can Click to Drag Custom Form Field But Cannot Drop When Designing in Outlook 2007 Outlook VBA and Custom Forms 2
A Custom form not showing when recurrence is set for a meeting Using Outlook 0
A Get shared calendar name or id in custom appointment form Using Outlook 0
A Updated custom form not showing with old items Outlook VBA and Custom Forms 2
C Custom Application Form send Email to Another User Using Outlook 1
G Adding a contact to Outlook with a custom form using Access VBA Outlook VBA and Custom Forms 1
A From box in custom outlook Form Outlook VBA and Custom Forms 0
M Recurring icon for custom form task item Outlook VBA and Custom Forms 6
X Help with custom form which is very similar to Tasks Outlook VBA and Custom Forms 6
T Create custom calendar entry form... Outlook VBA and Custom Forms 3
J Best approach for restarting custom task form development after seemingly corrupt form environment Outlook VBA and Custom Forms 0
Similar threads


















































Top