Dynamically add recipients using combobox and checkbox?????

Status
Not open for further replies.
I hope that posting two posts in one night is not a faux-pas in this online community. I do appreciate any and all help that I receive from this bright and wonderful forum!




On to my dilemma...




As my title suggests, I am trying to dynamically add recipients to my "To" field (I would settle for "Cc" too...) on my form with the use of listboxes and checkboxes. I have bound a combobox ("ComboBox1") to a custom value field ("addresses") with three or four email addresses in the Possible Values entry. I want to be able to add multiple recipients by the use of multiple comboboxes and checkboxes, but I can't even get one to work correctly.




In the Value tab for my "To" ("_RecipientControl1") properties, I've set its Initial Value field to "[addresses]", and I have it set to "Calculate this formula automatically".




Thus, when I open the combobox and choose one of the email addresses, it appears in the "To" textbox.




But that is ALL that appears. I can't type in anything else because it just reverts back to the combobox selection. But it doesn't work correctly. The email address shows up in the "To" box, but it doesn't recognize it in the GAL. So when I try to send the form it errors out. Sometimes when I test the form it gives me the AutoComplete button for the address, but then still, it just reverts back to the text and won't send.




I've also tried setting the Initial Value of the _RecipientControl1 to "[To]+"; "[addresses]", but when I do this, obviously, it continuously loops and fills the entire To field with just one address.






Has anybody else dealt with this, and can you help me? Thank you so much for any help!!!
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
I IMAP - are emails dynamically fetched from server as required? Using Outlook 2
M MS Access contacts dynamically MS Outlook Using Outlook 4
G How to add a folder shortcut to outlook quick access toolbar? Using Outlook 5
G Add to Outlook Contacts - Point to non-default contacts folder Using Outlook 0
M Automatically add senders first name to a greeting Outlook VBA and Custom Forms 1
C Add Form to Appointments Received, Automatically Outlook VBA and Custom Forms 6
O Outlook tasks - Add text column with multiple lines Using Outlook 3
W April 2020 Office 365 Update - Add-Ons fail after Office 365 Update Using Outlook 6
B Task Filter Not Working When I add too many criteria Using Outlook 0
D Add date next to day name in Outlook Today calendar view Using Outlook 1
D iCloud Add-in not working in Outlook 2013 and Outlook 2016 After Windows Upgrade & iCloud Upgrade Using Outlook 2
P Add Paste Unformatted to QAT Using Outlook 1
M Ignore slow add-ins Using Outlook 0
B Add Prefix text to Subject Line Using Outlook 1
Jennifer Murphy Add birthdays to calendar Using Outlook 7
Z Add text to auto-forwarded e-mail Outlook VBA and Custom Forms 4
P Add, remove, & reorder folder pane Using Outlook 6
L Tired of Outlook disabling Adobe PDF Creator add-in Using Outlook 1
R Add 'Company' to Select Names Form Using Outlook 1
A Outlook 2016 Web add-in missing on some machines Using Outlook 9
P Syncing problems with add-ins Using Outlook 3
Mark Foley Cannot enable add-in in outlook 2010 Using Outlook 0
BretAB Is it possible to add a lookup field to a Message form? Outlook VBA and Custom Forms 4
J Add an Attachment Using an Array and Match first 17 Letters to Matching Template .oft to Send eMail Outlook VBA and Custom Forms 2
iwshim outlook 2013 - I cannot see the "Manage Add-ins" Using Outlook 2
A Add multiple servers "on behalf of" email to "safe senders" list. Using Outlook 1
S Add Exchange Account as Secondary to Existing PST? Exchange Server Administration 1
C Macro to add multiple recipients to message Outlook VBA and Custom Forms 3
A Add to Outlook Contacts from email - default view Outlook VBA and Custom Forms 1
P Add a contact to the New Task in Outlook 2016 Using Outlook 2
e_a_g_l_e_p_i Is there a way to add something that is in the "Format Text" tab to the "basic Text" on the message tab Using Outlook 1
B When working on emails in a certain folder, when I hit reply or reply all, I would like it re always reply all and add an email address to send to Outlook VBA and Custom Forms 3
M Macro to add date/time stamp to subject Outlook VBA and Custom Forms 4
O Outlook on Android - add BCC Using Outlook 2
J Execute Add-In Button from VBA Outlook 2016 Outlook VBA and Custom Forms 1
S Example VBA Macro - To Conditionally Change the From Account and Add a BCC Address on Emails Outlook VBA and Custom Forms 11
B When I add more search strings to RULES, it is not processing them Using Outlook 3
D Add Tetxbox at form open Outlook VBA and Custom Forms 1
Andrew Quirl Open attachment, manipulate without add-on program? Outlook VBA and Custom Forms 5
B Searching for a Add-In Using Outlook 3
J Add Fillable Fields to Existing Template Outlook VBA and Custom Forms 1
J vb to c# for Outlook add-in. Using Outlook 0
S Send email via SMTP - use transport rules to add to senders inbox (then rule to move to sent items Exchange Server Administration 1
R Outlook add-in to create new contact from an email. Using Outlook 0
twofivepie GTD Netcentrics add-in for 2016 Outlook VBA and Custom Forms 13
D Add all meeting rooms to the meeting request by default Outlook VBA and Custom Forms 0
A add birthday to outlook contacts Using Outlook 1
Tanja Östrand Outlook 2016 - Create Macro button to add text in Subject Outlook VBA and Custom Forms 1
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
K add pdf to every reply or forward Outlook VBA and Custom Forms 1
Similar threads


















































Top