How to export voting results using VBA?

Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#1
Hi there,

I am proficient at coding VBA in Excel but haven't really tried it in Outlook (2016 is the version we have).

I am looking for something that would automate this:
  • View voting responses (this brings up the original mail in the "Tracking" pane where recipients and responses can be seen)
  • select all rows in the table
  • copy the rows
  • open a blank Excel sheet
  • paste the results in Excel
The last two are fairly trivial, but is there a way to do the first three programmatically using VBA??

Thanks for any help!
Phil
 
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#3
Excellent!! Almost what I wanted and I can edit the VBA to make it do what I wanted!! Thanks!!
 

Similar threads

Top