Post number 2 has been selected as the best answer.

Jakson

New Member
Outlook version
Outlook 365 64 bit
Email Account
Exchange Server
I'm only now realizing how in over my head I am with this project I'm working on, bear with me through any faux-pas or misunderstandings, my lexicon is rather new yet.

The problem:
I've got an Excel file loaded up with data as a scheduling tool for the agency I work for. Its purpose is to send out an email, and make a new task item, for the employees of this company. Currently, it emails and will receive pre-determined responses just fine. Occasionally though an employee won't respond with exact character phrases, ("Yes" or "No" vs "Mno" or "es") - this breaks the regex because its not finding a match anymore.

I was looking to resolve the issue of not having pre-defined responses by making a user-form to send to the employees in replace of an email. Pursuant to this goal I've figured the best possible method would be check boxes/radio buttons. However, I'm not at all sure how to publish these forms to the employees of my office, furthermore, I am unsure how to get VBA to read the responses indicated by the user-form.

TL;DR:
I need a user-form or something similar to give to my employees so that they can ONLY answer with predetermined responses. How do I publish a user-form like that, and furthermore, how do I read for responses?

Any guidance is much appreciated.

Thank you!
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I was looking to resolve the issue of not having pre-defined responses by making a user-form to send to the employees in replace of an email. Pursuant to this goal I've figured the best possible method would be check boxes/radio buttons. However, I'm not at all sure how to publish these forms to the employees of my office, furthermore, I am unsure how to get VBA to read the responses indicated by the user-form.
This would only work in an Exchange environment where you can use RTF formatted email and publish the form in an org forms library.
 

Jakson

New Member
Outlook version
Outlook 365 64 bit
Email Account
Exchange Server
This would only work in an Exchange environment where you can use RTF formatted email and publish the form in an org forms library.
Hmm... I see...

I'll do some reading and research this a little more in depth. Thanks of orienting me in the right direction!! I had no idea which rock to even begin looking under!
 

Jakson

New Member
Outlook version
Outlook 365 64 bit
Email Account
Exchange Server
This would only work in an Exchange environment where you can use RTF formatted email and publish the form in an org forms library.
Hey Diane,

I'm having a really hard time grasping this. I'm not sure why its sticky, but I'm feeling kinda mired.

I've done some reading about making custom outlook forms. I seem to have successfully made a few test forms, however, I cannot get my test forms to carry the radio button/check boxes into the reply form for my employee to manipulate the buttons. When I open the form I made, I can see the radio buttons/check boxes and make changes accordingly. However, when I hit send and attempt to reply to the form generated email, I don't see any of the form features anymore. I read in a few articles about Sending forms and Replying forms, is this something to do with the mentioned behavior?

I'm pretty sure I'm doing something wrong, I'm just not sure what.

Furthermore, I'm having a difficult time finding information online about retrieving values specifically from checkbox/radio button controls on a form. I've seen plenty of examples of extracting the body of text from a textbox, or a filled-in-textbox... If its basically identical, sub the object name, I'm certain I can ferret my way through with minimal help.

Any guidance is deeply appreciated.

Any suggestions as to what I'm doing wrong, or where I might find more information?
 
Similar threads
Thread starter Title Forum Replies Date
S Outlook Custom form - selecting text in read page Using Outlook 0
B Inconsistent handling of message read/unread status by Outlook Using Outlook 3
Z Outlook 365 delete reminder you can’t make change to contents of this-read only folder Using Outlook 4
R seperate read layout to design in outlook 2016..Help!! Outlook VBA and Custom Forms 3
DoctorJellybean Outlook 365 doesn't always mark emails as read Using Outlook 3
Diane Poremsky Edit and Save Outlook's Read-Only Attachments Using Outlook 0
T Outlook 2013 either fails to mark messages as read or marks them as read, then un-marks them. Using Outlook 1
Mary B Outlook 2013: Rule for copying new email to folder & marking that copy as read Using Outlook 1
JR Ryan Outlook marks all as "Read" issue Exchange Server Administration 2
T Saving Outlook 2010 email with attachments but read the email without Outlook Using Outlook 2
C In need of VBA code to read / parse HTML - Outlook emails Using Outlook 0
S iCloud Outlook Calendar is read only Using Outlook 1
G How to make outlook show as unread messages I read in my mobile ph or tablet Using Outlook 1
Z "Mark All as Read" in Outlook 2007 extremely slow Using Outlook 1
S Block read receipt when outlook is configured to Exchange server Using Outlook 0
J Mail read in OWA won't appear in Outlook Exchange Server Administration 1
P mails in my inbox of outlook 2007 tend to go missing after I read them Using Outlook 14
S How to read single instance of recursive meetings in Outlook Outlook VBA and Custom Forms 1
S How to read single instance of recursive meetings in Outlook Outlook VBA and Custom Forms 1
A How to Sort by Unread and then Read mail in Outlook 2007 Using Outlook 7
J Outlook 07 emails all appear READ now my Blackberry activ. Want UN BCM (Business Contact Manager) 1
A Read Outlook Mail Item From Value Outlook VBA and Custom Forms 1
V Outlook 2007: How to read/write Out-of-Office settings Outlook VBA and Custom Forms 3
T E-mails marked as read turn back to unread after a couple of seconds Using Outlook 1
M Cannot read the calendar Using Outlook 9
A Inbox didn't got read Outlook VBA and Custom Forms 0
e_a_g_l_e_p_i Is it possible it set the fonts used to read incoming mail Using Outlook 25
N Disable Auto Read Receipts sent after using Advanced Find Using Outlook 4
N Separate Read Layout Editing Outlook VBA and Custom Forms 0
A Read and Write to Text File Outlook VBA and Custom Forms 1
L Email Read and Delete Outlook VBA and Custom Forms 4
A Separate Read Layout Outlook VBA and Custom Forms 4
M Making Subject field writable (disable Read Only) Outlook VBA and Custom Forms 2
M How can I determine which user read an email Exchange Server Administration 4
Diane Poremsky Mark Sent Items as Read After Copying with a Rule Using Outlook 0
Rupert Dragwater Some mailboxes show deleted items as not read Using Outlook 5
K cant read email or open attachement Using Outlook 0
R Reply marks read message as unread Using Outlook 1
Mary B VBscript: Need to copy every email to a folder & mark that copy as read Outlook VBA and Custom Forms 5
M Sorting messages by read/unread status Using Outlook 8
C Mark all incoming emails as read Outlook VBA and Custom Forms 3
FirefIy Marking message read only if replied to the message or Ctrl+Q. Possible? Using Outlook 1
A give User Read Only access to secondary mailbox in Exchange 2010 via AD Exchange Server Administration 1
M How do I mark emails already received as read when I get a second, different email based on subject? Outlook VBA and Custom Forms 3
R Cannot read Chinese message after import Using Outlook 2
M Oh please read---> Extracting email web leads on to excel spread sheet Using Outlook 3
A Can't read my mails if they are on a folder... Using Outlook 0
M Unable to read HTML Using Outlook 2
J Cannot read incoming emails Using Outlook 2
P Custom field is read only Using Outlook 1

Similar threads

Top