Solved

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

Posted on 2014-04-12
5
141 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
  • 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Disabling the Directory Sync Service Account in Office 365 will stop directory synchronization from working.
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
In this video we show how to create a mailbox database in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Servers >> Data…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now