Integration of corporate email voting with SQL database

Question

Hi, is anyone familiar with development of integration between corporate Outlook email voting buttons with logging in SQL database?
Process involves sending automatized voting email by ITEM_ID (probably part of subject email) to multiple voters (executive board members). This SQL table represents voting topics aka ITEM_ID's. After each of them votes, SQL is logging their answers with time, answer and ITEM_ID because emails are sent frequently based on ITEM_ID.  

I searched and found only possible solutions as separate web page and email with links, or .NET application.

kind regards,

Answer 1

You can use PowerShell to read the email and it contents and  then process it to the table.

More information can be found at : 

https://devblogs.microsoft.com/scripting/use-powershell-to-data-mine-your-outlook-inbox/

https://www.computerperformance.co.uk/powershell/outlook-email/

Hope this helps.

 

Answer 2

Hi DenisRap,

Sorry I'm not familiar with this feature, some articles lead me to enable Tracking in Outlook and print poll results to a Excel file, so that you can transfer the data in Excel file to SQL Server by using SSIS.

refer to: Create polls in email messages and review the results.

Best Regards,

Lily

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]