A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

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



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old August 1st 08, 01:14 AM posted to microsoft.public.outlook.program_forms
Mr Reorg
external usenet poster
 
Posts: 4
Default Help needed to auto populate Subject field -Outlook 2003 custom ms

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  
Old August 1st 08, 01:56 PM posted to microsoft.public.outlook.program_forms
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Help needed to auto populate Subject field -Outlook 2003 custom ms

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  
Old August 1st 08, 03:16 PM posted to microsoft.public.outlook.program_forms
Mr Reorg
external usenet poster
 
Posts: 4
Default Help needed to auto populate Subject field -Outlook 2003 custo

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  
Old August 1st 08, 07:53 PM posted to microsoft.public.outlook.program_forms
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Help needed to auto populate Subject field -Outlook 2003 custo

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  
Old August 1st 08, 08:51 PM posted to microsoft.public.outlook.program_forms
Mr Reorg
external usenet poster
 
Posts: 4
Default Help needed to auto populate Subject field -Outlook 2003 custo

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  
Old August 1st 08, 10:52 PM posted to microsoft.public.outlook.program_forms
Mr Reorg
external usenet poster
 
Posts: 4
Default Help needed to auto populate Subject field -Outlook 2003 custo

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  
Old August 2nd 08, 04:41 PM posted to microsoft.public.outlook.program_forms
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Help needed to auto populate Subject field -Outlook 2003 custo

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
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


All times are GMT +1. The time now is 11:14 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.