Automatically enter 'Subject' from form data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



RogerC said:
I am creating a form that collects data from a group of Outlook users.
Click to expand...
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?
 
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?
 
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]

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



RogerC said:
Thanks Sue. That works. Just one other thing... I find that I now need
Click to expand...
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?
 
Back
Top