Outlook 2003 - Custom Templates for Public Folders

[Sue Mosher [MVP-Outlook]]

You must use the field names, not control names. Drag the Subject property to a custom page on your form. Right-click the resulting text box, and choose Properties. On the Value tab, at the bottom, click the Edit button to open the formula builder. I strongly suggest you use the Field button to choose fields rather than risk typos by typing them in. You'll also want to set the option on the Value tab to "Calculate the formula automatically.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

So you mean something like the following? Would that link the three
textboxes together?

[textbox1]& " " &[textbox2]& " " &[textbox3]

If that's correct and they're linked, how do I tie them to the "Subject"
property?

If you use the formula editor to pick the fields, you'll see the field syntax that formulas take. After that, it's simple string operators.

[YourField] & " " & [YourOtherField]

etc.

Any suggestions on where to find examples for the formula to concatenate my
other textboxes' properties to the Subject property's textbox?

:

You need to bind each text box to a separate property, creating new ones as needed. Once you've done that, you can set a formula on the Subject property's text box to concatenate those new properties' values to build the Subject.

Thank you for your response, patience, and guidance.

I've tried using textboxes bound to the "Subject" property, but the problem
I keep experiencing is the following. Since all of my textboxes are bound to
the "Subject" property, if I type "Test" into one of the textboxes , they
will all become filled with "Test." Is there a way to maintain the "Subject"
field's properties, but differentiate them so that they do not copy each
other's contents?

Thanks again.


At this point, what might be the simplest solution is to use textboxes bound to custom Outlook properties and then set the value of the Subject property using a formula. To do that, you'd need to add Subject to a custom form page, so you can get to its control Properties, but that can be on a hidden page.

 

[Scott07]

Got it working! Thanks so much!

You must use the field names, not control names. Drag the Subject property to a custom page on your form. Right-click the resulting text box, and choose Properties. On the Value tab, at the bottom, click the Edit button to open the formula builder. I strongly suggest you use the Field button to choose fields rather than risk typos by typing them in. You'll also want to set the option on the Value tab to "Calculate the formula automatically.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

So you mean something like the following? Would that link the three
textboxes together?

[textbox1]& " " &[textbox2]& " " &[textbox3]

If that's correct and they're linked, how do I tie them to the "Subject"
property?

If you use the formula editor to pick the fields, you'll see the field syntax that formulas take. After that, it's simple string operators.

[YourField] & " " & [YourOtherField]

etc.

Any suggestions on where to find examples for the formula to concatenate my
other textboxes' properties to the Subject property's textbox?

:

You need to bind each text box to a separate property, creating new ones as needed. Once you've done that, you can set a formula on the Subject property's text box to concatenate those new properties' values to build the Subject.

Thank you for your response, patience, and guidance.

I've tried using textboxes bound to the "Subject" property, but the problem
I keep experiencing is the following. Since all of my textboxes are bound to
the "Subject" property, if I type "Test" into one of the textboxes , they
will all become filled with "Test." Is there a way to maintain the "Subject"
field's properties, but differentiate them so that they do not copy each
other's contents?

Thanks again.


At this point, what might be the simplest solution is to use textboxes bound to custom Outlook properties and then set the value of the Subject property using a formula. To do that, you'd need to add Subject to a custom form page, so you can get to its control Properties, but that can be on a hidden page.