Automatically enter 'Subject' from form data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RogerC - 11 May 2004 18:01 GMT

I am creating a form that collects data from a group of Outlook users. The form will be emailed to me when the user clicks a 'Submit' button at the bottom of the form. I would like the Subject of the user's reply to be automatically copied into the Subject field from one of the text boxes the user has entered data into on the form. Can this be done

Reply to this Message

Sue Mosher [MVP-Outlook] - 11 May 2004 18:27 GMT

The easiest way to do this is to use the text box's Properties dialog, the
Value tab, to bind the Subject field to the text box.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> I am creating a form that collects data from a group of Outlook users. The form will be emailed to me when the user clicks a 'Submit' button at the

bottom of the form. I would like the Subject of the user's reply to be
automatically copied into the Subject field from one of the text boxes the
user has entered data into on the form. Can this be done?

Reply to this Message

RogerC - 12 May 2004 00:11 GMT

Thanks Sue. That works. Just one other thing... I find that I now need to add two words to the beginning of the Subject line for every reply. I need every reply to begin with the words 'User Request' followed by the input that the user as typed into the textbox. Having this in the Subject line will allow me to use Outlook rules to automatically file the replies. Can this be done?

Reply to this Message

Sue Mosher [MVP-Outlook] - 12 May 2004 00:45 GMT

You'll need to take a slightly different approach. Instead of binding the
text box to the Subject property, bind it to the Billing Information
property. Then in the properties for the regular text box for the Subject,
set up this formula to be applied automatically:

"User Request " & [Billing Information]

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> Thanks Sue. That works. Just one other thing... I find that I now need to add two words to the beginning of the Subject line for every reply. I

need every reply to begin with the words 'User Request' followed by the
input that the user as typed into the textbox. Having this in the Subject
line will allow me to use Outlook rules to automatically file the replies.
Can this be done?

Reply to this Message