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

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.
 
K

Ken Slovak - [MVP - Outlook]

Make sure the radio control under "set initial value" is set to "Calculate
this formula automatically" on the Value tab of the control.
 
M

Mr Reorg

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.
 
K

Ken Slovak - [MVP - Outlook]

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.
 
M

Mr Reorg

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.
 
M

Mr Reorg

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.
 
K

Ken Slovak - [MVP - Outlook]

Anything that needs to be updated when the field or a subfield used to
populate that field changes should have that setting.
 

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