![]() |
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
|
|||
|
|||
![]()
I am creating an Outlook 2003 custom form for the very first time. I've
searched for the answer but either cannot find it or may not understand an answer which discusses scripting. I do not know VB Script or any other programming. I have a Message type form where I want the Subject field auto populated by data (values) that will be provided from other fields selected or input by the user/sender: 1 - Event Type - is a Combo Box with a drop down selection (which initial value on the Properties tab is set to be the first selection, namely, "Select Event Type") 2 - Expiration Date - is a text box with no initial value set. (When running/opening the form, the field is popuilated as "none" - I assume because there isn't yet a date value input). 3 - Description - is a text box with no initial value set. (When running/openning the form, the field is blank). I have the initial value on the Properties tab of the Subject field set with the following formula: [Event Type] + " " + "Expiring" + " " + [Expiration Date] + ":" + [Description] When I run/open the form, before any user/sender input, the Subject line says: "Select Event Type Expiring None:" There are no changes to the Subject line (field) after making a selection from the drop down list, inputing a date and a "description" in the resepective fields on the form. The receipient of the form (myself, for testing purposes) see the Subject of the message (custom form) as: ""Select Event Type Expiring None:" Is there a way to do this without scripting? Please help me. |
#2
|
|||
|
|||
![]()
Make sure the radio control under "set initial value" is set to "Calculate
this formula automatically" on the Value tab of the control. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech.com/products.htm "Mr Reorg" wrote in message ... I am creating an Outlook 2003 custom form for the very first time. I've searched for the answer but either cannot find it or may not understand an answer which discusses scripting. I do not know VB Script or any other programming. I have a Message type form where I want the Subject field auto populated by data (values) that will be provided from other fields selected or input by the user/sender: 1 - Event Type - is a Combo Box with a drop down selection (which initial value on the Properties tab is set to be the first selection, namely, "Select Event Type") 2 - Expiration Date - is a text box with no initial value set. (When running/opening the form, the field is popuilated as "none" - I assume because there isn't yet a date value input). 3 - Description - is a text box with no initial value set. (When running/openning the form, the field is blank). I have the initial value on the Properties tab of the Subject field set with the following formula: [Event Type] + " " + "Expiring" + " " + [Expiration Date] + ":" + [Description] When I run/open the form, before any user/sender input, the Subject line says: "Select Event Type Expiring None:" There are no changes to the Subject line (field) after making a selection from the drop down list, inputing a date and a "description" in the resepective fields on the form. The receipient of the form (myself, for testing purposes) see the Subject of the message (custom form) as: ""Select Event Type Expiring None:" Is there a way to do this without scripting? Please help me. |
#3
|
|||
|
|||
![]()
Thanks, I changed that (on the Subject properties) and now when I (the
user/sender) make a selection from the combo box, it appears on the subject line. BUT when I input values in the other two text boxes, their values DO NOT appear in the Subject field. However, if I change the selection in the combo box, the change IS NOT reflected in the Subject field; it remains the initial selection. What else might I be missing? Is the formula I am using for the Subject field correct? Sorry if these are very basic things, but I am a complete noob at this and I need a lot of help. I made sure that the "Ken Slovak - [MVP - Outlook]" wrote: Make sure the radio control under "set initial value" is set to "Calculate this formula automatically" on the Value tab of the control. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech.com/products.htm "Mr Reorg" wrote in message ... I am creating an Outlook 2003 custom form for the very first time. I've searched for the answer but either cannot find it or may not understand an answer which discusses scripting. I do not know VB Script or any other programming. I have a Message type form where I want the Subject field auto populated by data (values) that will be provided from other fields selected or input by the user/sender: 1 - Event Type - is a Combo Box with a drop down selection (which initial value on the Properties tab is set to be the first selection, namely, "Select Event Type") 2 - Expiration Date - is a text box with no initial value set. (When running/opening the form, the field is popuilated as "none" - I assume because there isn't yet a date value input). 3 - Description - is a text box with no initial value set. (When running/openning the form, the field is blank). I have the initial value on the Properties tab of the Subject field set with the following formula: [Event Type] + " " + "Expiring" + " " + [Expiration Date] + ":" + [Description] When I run/open the form, before any user/sender input, the Subject line says: "Select Event Type Expiring None:" There are no changes to the Subject line (field) after making a selection from the drop down list, inputing a date and a "description" in the resepective fields on the form. The receipient of the form (myself, for testing purposes) see the Subject of the message (custom form) as: ""Select Event Type Expiring None:" Is there a way to do this without scripting? Please help me. |
#4
|
|||
|
|||
![]()
I don't know if this is standard but I've had problems picking up values
like that unless I used an intermediate control, like a textbox that isn't visible. I set the textbox to take the selection from the list and then use the textbox contents in the formula. See if that helps. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech.com/products.htm "Mr Reorg" wrote in message ... Thanks, I changed that (on the Subject properties) and now when I (the user/sender) make a selection from the combo box, it appears on the subject line. BUT when I input values in the other two text boxes, their values DO NOT appear in the Subject field. However, if I change the selection in the combo box, the change IS NOT reflected in the Subject field; it remains the initial selection. What else might I be missing? Is the formula I am using for the Subject field correct? Sorry if these are very basic things, but I am a complete noob at this and I need a lot of help. I made sure that the |
#5
|
|||
|
|||
![]()
Any thoughts on this:
However, if I change the selection in the combo box, the change IS NOT reflected in the Subject field; it remains the initial selection. "Ken Slovak - [MVP - Outlook]" wrote: I don't know if this is standard but I've had problems picking up values like that unless I used an intermediate control, like a textbox that isn't visible. I set the textbox to take the selection from the list and then use the textbox contents in the formula. See if that helps. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech.com/products.htm "Mr Reorg" wrote in message ... Thanks, I changed that (on the Subject properties) and now when I (the user/sender) make a selection from the combo box, it appears on the subject line. BUT when I input values in the other two text boxes, their values DO NOT appear in the Subject field. However, if I change the selection in the combo box, the change IS NOT reflected in the Subject field; it remains the initial selection. What else might I be missing? Is the formula I am using for the Subject field correct? Sorry if these are very basic things, but I am a complete noob at this and I need a lot of help. I made sure that the |
#6
|
|||
|
|||
![]()
I should have also asked you, in regard to you previous reply about the radio
button - you meant only for the Subject field, correct? I presumed you weren't telling me to do that for ALL of the related fields that are suppose to populate the Subject field. Please confirm, Thanks. "Ken Slovak - [MVP - Outlook]" wrote: I don't know if this is standard but I've had problems picking up values like that unless I used an intermediate control, like a textbox that isn't visible. I set the textbox to take the selection from the list and then use the textbox contents in the formula. See if that helps. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech.com/products.htm "Mr Reorg" wrote in message ... Thanks, I changed that (on the Subject properties) and now when I (the user/sender) make a selection from the combo box, it appears on the subject line. BUT when I input values in the other two text boxes, their values DO NOT appear in the Subject field. However, if I change the selection in the combo box, the change IS NOT reflected in the Subject field; it remains the initial selection. What else might I be missing? Is the formula I am using for the Subject field correct? Sorry if these are very basic things, but I am a complete noob at this and I need a lot of help. I made sure that the |
#7
|
|||
|
|||
![]()
Anything that needs to be updated when the field or a subfield used to
populate that field changes should have that setting. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech.com/products.htm "Mr Reorg" wrote in message ... I should have also asked you, in regard to you previous reply about the radio button - you meant only for the Subject field, correct? I presumed you weren't telling me to do that for ALL of the related fields that are suppose to populate the Subject field. Please confirm, Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Populate Message field based on custom field | Kryer | Outlook - Using Forms | 8 | September 7th 07 10:19 PM |
Populate Outlook 2003 Custom Form from Access 2003 | Kujp Sucisv | Outlook - Using Forms | 1 | May 21st 07 09:20 PM |
Custom Subject field in Outlook 2003 | pmt82 | Outlook - Using Forms | 3 | April 4th 07 12:04 AM |
Use field in outlook custom form to populate excel sheet | Jade | Outlook - Using Forms | 1 | November 29th 06 09:38 PM |
Populate Company field from Contact field in custom task form | Sue Mosher [MVP-Outlook] | Outlook - Using Forms | 0 | January 20th 06 07:37 PM |