Setting subject in calendar custom form

[robert.a.pierce]

Good afternoon.

We have a custom form in a public folder calendar folder, on Exch.
2003 that we're using for scheduling.

I'd like to set it so that the user can enter information into the
form, and have the subject automatically be set to a concatenation of
several fields, e.g.

subject = [Vendor] + [PONumber] + [Comments]

where the [xx] items are custom fields in the form.

I'd like the subject text to change when the user tabs or clicks out
of the text field, and be updated if the user changes any of the text
fields.

I see that there's an "Initial Value" formula bar, but that doesn't
work for changing text values.

What would be the easiest way to do this?

Thanks,

Rob Pierce

 

[Sue Mosher [MVP-Outlook]]

You need not an initial value formula but the second formula option -- one that is automatically evaluated always. Also, you should use & for the concatenation character and reserve + for addition, if just to make the formula more readable.

 

[robert.a.pierce]

We have a custom form in a public folder calendar folder, on Exch.
2003 that we're using for scheduling.

I'd like to set it so that the user can enter information into the
form, and have the subject automatically be set to a concatenation of
several fields, e.g.

subject = [Vendor] + [PONumber] + [Comments]

You need not an initial value formula but the second formula option -- onethat is automatically evaluated always. Also, you should use & for the concatenation character and reserve + for addition, if just to make the formula more readable.

--
Sue Mosher, Outlook MVP
   Author of Microsoft Outlook 2007 Programming:
     Jumpstart for Power Users and Administrators
   http://www.outlookcode.com/article.aspx?id=54

Thanks!

I have it set to

subject = [Vendor] & " " & [PONumber] & " " & [Comments]

and that works perfectly. The quoted spaces add space between the
fields in the subject.

Thanks very much,

Rob Pierce