Help needed to auto populate Subject field -Outlook 2003 custom ms

  • Thread starter Thread starter Mr Reorg
  • Start date Start date
M

Mr Reorg

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.
 
Make sure the radio control under "set initial value" is set to "Calculate
this formula automatically" on the Value tab of the control.
 
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 - said:
Make sure the radio control under "set initial value" is set to "Calculate
this formula automatically" on the Value tab of the control.




Mr Reorg said:
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.
Click to expand...
Click to expand...
 
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.
 
Any thoughts on this:



Ken Slovak - said:
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.
Click to expand...
 
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.
 
Anything that needs to be updated when the field or a subfield used to
populate that field changes should have that setting.
 
Back
Top