Outlook 2010 Custom Form - Add email address based on drop down selection in form

I have a custom Outlook form.
Within the form I have a question that uses a drop down box for either Yes or No.

Is it possible if "Yes" is chosen that an email address is automatically added to the "TO:" line?

If possible, how would that be accomplished?

Thanks in advance.
dgd1212Asked:
Who is Participating?
 
jrhelgesonConnect With a Mentor Commented:
What methods have you looked into thus far?  Using Macros, VBA?

This looks like it gets close to what you're doing.

http://forums.asp.net/t/1037670.aspx?Sending+an+email+with+Outlook+form+data+from+Net
0
 
jrhelgesonCommented:
WE'd need a lot more information about this.  Where are you getting the TO: email address information?  What is the YES|NO question that is being asked?

Are you trying to ask "Would you like sales to contact you?" and if the person selects "YES" then have it add "SALES@company.com" to the to: line?
0
 
dgd1212Author Commented:
The drop down box is a Yes/No selection to the question: Notification Management.

If yes, the persons name (email address) would need to be added to the "TO... line".

Not sure if this makes any difference, but additional names will need to be manually added to the address line also.

Basically what you stated:
"Are you trying to ask "Would you like sales to contact you?" and if the person selects "YES" then have it add "SALES@company.com" to the to: line?"

Thanks
0
 
dgd1212Author Commented:
What I was hoping to do was have a formula in the properties window that is in the "_RecipientControl1" (To...) line.

In the Value tab - Initial Value something like:
If [AlarmMgmt]=yes then john.doe@somewhere.com would appear in the To... line

Is something like this possible?
0
 
dgd1212Author Commented:
As mentioned this looks close (http://forums.asp.net/t/1037670.aspx?Sending+an+email+with+Outlook+form+data+from+Net) but not sure. Need to see if an IF/Then statement would work to trigger
0
All Courses

From novice to tech pro — start learning today.