Solved

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

Posted on 2014-04-12
5
148 Views
Last Modified: 2014-12-24
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.
0
Comment
Question by:dgd1212
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 15

Expert Comment

by:jrhelgeson
ID: 39999741
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
 

Author Comment

by:dgd1212
ID: 40000692
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
 
LVL 15

Accepted Solution

by:
jrhelgeson earned 500 total points
ID: 40001571
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
 

Author Comment

by:dgd1212
ID: 40010880
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
 

Author Closing Comment

by:dgd1212
ID: 40516439
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

Featured Post

Windows running painfully slow? Try these tips..

Stay away from Speed Up Computer Programs that do more harm than good.
Try these tips instead.
Step by step instructions in trouble shooting Windows Performance issues.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A list of top three free exchange EDB viewers that helps the user to extract a mailbox from an unmounted .edb file and get a clear preview of all emails & other items with just a single click on mailboxes.
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
This video discusses moving either the default database or any database to a new volume.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question