I regularly create Mailchimp campaigns with an overview of the latest articles on my site, including title, excerpt, featured images and link. This is always a LOT of work, prone with errors.
I have this dream: can I create a Toolset View on my website and copy/paste the HTML code to Mailchimp, along with some appropriate HTML? Is there a way to do that?
Let me check if I understand you correctly. As I understand, you are referring to a mail/notification system that should run on my site and that system should recognize Toolset shortcodes, right?
That's not what I dreamed of. I was dreaming of using Mailchimp as mail platform and creating HTML for that on my site. Your implicit verdict seems to be: keeping dreaming but forget it.