|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
September 15th 06, 09:43 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
Outlook form with vbscript
I have a form that has check boxes. If I send the form, the blackberry
doesn't get any information about the checkboxes that were selected on the form. Therefore, we created a vbscript that put the checked "checkboxes" into the message area. It works great! However, If I insert my signature into the form, or the signature is automatically in the form due to the signatures being turned on, all of my checkbox info drops itself "after" the typed message and signature. Is there a way to paste it at the beginning of the message area? 
|
|
#2
September 15th 06, 09:57 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Outlook form with vbscript
Show the code that inserts the data, please
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Corey H." Corey wrote in message ... I have a form that has check boxes. If I send the form, the blackberry doesn't get any information about the checkboxes that were selected on the form. Therefore, we created a vbscript that put the checked "checkboxes" into the message area. It works great! However, If I insert my signature into the form, or the signature is automatically in the form due to the signatures being turned on, all of my checkbox info drops itself "after" the typed message and signature. Is there a way to paste it at the beginning of the message area?
|
|
#3
September 15th 06, 10:15 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Outlook form with vbscript
Sub Item_Send()
strBody = Item.Body If Item.UserProperties("Telephoned") = True Then strBody = strBody & vbCrLf & "Telephoned" End If If Item.UserProperties("PleaseCall") = True Then strBody = strBody & vbCrLf & "Please Call" End If If Item.UserProperties("Confidential") = True Then strBody = strBody & vbCrLf & "Confidential" End If If Item.UserProperties("WantstoSeeYou") = True Then strBody = strBody & vbCrLf & "Wants to See You" End If If Item.UserProperties("CameToSeeYou") = True Then strBody = strBody & vbCrLf & "Came To See You" End If If Item.UserProperties("ReturnedYourCall") = True Then strBody = strBody & vbCrLf & "Returned Your Call" End If If Item.UserProperties("WillCallAgain") = True Then strBody = strBody & vbCrLf & "Will Call Again" End If If Item.UserProperties("Rush") = True Then strBody = strBody & vbCrLf & "RUSH!" End If Item.Body = strBody End Sub "Sue Mosher [MVP-Outlook]" wrote: Show the code that inserts the data, please -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Corey H." Corey wrote in message ... I have a form that has check boxes. If I send the form, the blackberry doesn't get any information about the checkboxes that were selected on the form. Therefore, we created a vbscript that put the checked "checkboxes" into the message area. It works great! However, If I insert my signature into the form, or the signature is automatically in the form due to the signatures being turned on, all of my checkbox info drops itself "after" the typed message and signature. Is there a way to paste it at the beginning of the message area?
|
|
#4
September 15th 06, 10:33 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Outlook form with vbscript
Your code appears to be doing exactly what you told it, appending everything to the existing Item.Body content, e,g.
strBody = strBody & vbCrLf & "Telephoned" Instead, you might want to build strBody from the custom field data, then prefix it to Item.Body: Item.Body = strBody & Item.Body -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Corey H." wrote in message ... Sub Item_Send() strBody = Item.Body If Item.UserProperties("Telephoned") = True Then strBody = strBody & vbCrLf & "Telephoned" End If If Item.UserProperties("PleaseCall") = True Then strBody = strBody & vbCrLf & "Please Call" End If If Item.UserProperties("Confidential") = True Then strBody = strBody & vbCrLf & "Confidential" End If If Item.UserProperties("WantstoSeeYou") = True Then strBody = strBody & vbCrLf & "Wants to See You" End If If Item.UserProperties("CameToSeeYou") = True Then strBody = strBody & vbCrLf & "Came To See You" End If If Item.UserProperties("ReturnedYourCall") = True Then strBody = strBody & vbCrLf & "Returned Your Call" End If If Item.UserProperties("WillCallAgain") = True Then strBody = strBody & vbCrLf & "Will Call Again" End If If Item.UserProperties("Rush") = True Then strBody = strBody & vbCrLf & "RUSH!" End If Item.Body = strBody End Sub I have a form that has check boxes. If I send the form, the blackberry doesn't get any information about the checkboxes that were selected on the form. Therefore, we created a vbscript that put the checked "checkboxes" into the message area. It works great! However, If I insert my signature into the form, or the signature is automatically in the form due to the signatures being turned on, all of my checkbox info drops itself "after" the typed message and signature. Is there a way to paste it at the beginning of the message area?
|
|
#5
September 15th 06, 10:19 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Outlook form with vbscript
Also, I have a combination field linked to the subject line. When it's
inserted, the person on the receiving end is getting an error stating "form cannot be opened". Corey "Sue Mosher [MVP-Outlook]" wrote: Show the code that inserts the data, please -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Corey H." Corey wrote in message ... I have a form that has check boxes. If I send the form, the blackberry doesn't get any information about the checkboxes that were selected on the form. Therefore, we created a vbscript that put the checked "checkboxes" into the message area. It works great! However, If I insert my signature into the form, or the signature is automatically in the form due to the signatures being turned on, all of my checkbox info drops itself "after" the typed message and signature. Is there a way to paste it at the beginning of the message area?
|
|
#6
September 15th 06, 10:31 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Outlook form with vbscript
When what's inserted?
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Corey H." wrote in message ... Also, I have a combination field linked to the subject line. When it's inserted, the person on the receiving end is getting an error stating "form cannot be opened". I have a form that has check boxes. If I send the form, the blackberry doesn't get any information about the checkboxes that were selected on the form. Therefore, we created a vbscript that put the checked "checkboxes" into the message area. It works great! However, If I insert my signature into the form, or the signature is automatically in the form due to the signatures being turned on, all of my checkbox info drops itself "after" the typed message and signature. Is there a way to paste it at the beginning of the message area?
|
|
#7
September 15th 06, 11:08 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Outlook form with vbscript
Sorry, let me rephrase.
I have a combination field linked to the subject line. When the combination field is inserted onto the form; and the form then sent out, the person on the receiving end is getting an error stating "form cannot be opened". If I remove the combination field from the form, the form opens correctly, however the combination function is no longer there. What would be causing this? Corey "Sue Mosher [MVP-Outlook]" wrote: When what's inserted? -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Corey H." wrote in message ... Also, I have a combination field linked to the subject line. When it's inserted, the person on the receiving end is getting an error stating "form cannot be opened". I have a form that has check boxes. If I send the form, the blackberry doesn't get any information about the checkboxes that were selected on the form. Therefore, we created a vbscript that put the checked "checkboxes" into the message area. It works great! However, If I insert my signature into the form, or the signature is automatically in the form due to the signatures being turned on, all of my checkbox info drops itself "after" the typed message and signature. Is there a way to paste it at the beginning of the message area?
|
|
#8
September 15th 06, 11:25 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Outlook form with vbscript
It might help if you provided the formula for the combination field.
Also, what about using a regular text field and setting its value in the Item_Send event handler? -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Corey H." wrote in message ... Sorry, let me rephrase. I have a combination field linked to the subject line. When the combination field is inserted onto the form; and the form then sent out, the person on the receiving end is getting an error stating "form cannot be opened". If I remove the combination field from the form, the form opens correctly, however the combination function is no longer there. What would be causing this? Also, I have a combination field linked to the subject line. When it's inserted, the person on the receiving end is getting an error stating "form cannot be opened". I have a form that has check boxes. If I send the form, the blackberry doesn't get any information about the checkboxes that were selected on the form. Therefore, we created a vbscript that put the checked "checkboxes" into the message area. It works great! However, If I insert my signature into the form, or the signature is automatically in the form due to the signatures being turned on, all of my checkbox info drops itself "after" the typed message and signature. Is there a way to paste it at the beginning of the message area?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to Find a Item using VBScript in Outlook/Exchange | Andrew Sampels | Outlook - Using Forms | 5 | August 8th 06 10:54 PM |
| how to stop vbscript to travel with the form? | [email protected] | Outlook - Using Forms | 5 | June 5th 06 04:16 PM |
| Can you generate Outlook tasks using VBScript? | [email protected] | Outlook - General Queries | 2 | May 25th 06 09:25 AM |
| Outlook form with VBScript saved as an OFT? | Sydney | Outlook - Using Forms | 1 | March 24th 06 06:51 AM |
| VBscript support Outlook forms | Peter S | Outlook - Installation | 0 | March 6th 06 05:15 PM |
Hybrid Mode
