I’m experimenting with using an Outlook form to send structured fields in a message to an inbox that will be read by a bot. I’ve successfully installed the form in the recipient’s Outlook and I can manually see the completed fields are arriving in the inbox.
I’ve set up a simple “Get Outlook Messages” bot with a for each Mail to read the messages, but I can’t find the argument that serves up the form details so that I could assign to a variable. I’m able to retrieve all standard message details like sender, subject, and body, but not the details embedded in the form. Has anyone cracked this?
In the image above, there are two sections of the message. The “Message” that contains all header and body info, and the “P.2” section that contains the structured data. No where in the variables can I find the fields: “Country”, “Type”, “Email Address”, etc.
No. But I was able to move the form elements to the main body of the message and saved it as a .fdm (form message), then use a macro to trigger the form. My robot reads the message body and I use simple array splits to isolate the inputs.
It was hacky, but I made the form in Word with the various fields, created a new message in Outlook, chose design a form in the message, pasted the form from Word into the body, clicked publish as (.fdm), and saved it. Then other I created a macro to open it with a quick access button.