Button to email complete active sheet and current selections
Dear All
I am looking for some advice.
I would like to create a button on every screen of a particular QV document that will open the users default email client. Populate the send to, subject and insert a screen shot of the complete sheet they are on and the "Current Selection Properties" of the sheet. I would prefer not to use macros on this document but if need be could someone please give me initial guidance.
I would presume that a lot of people would have this requirement as it allows users to quickly send an email to someone showing them what they see , without have to explain in detail.
What you can do is when button is pressed you can trigger a macro to export a JPEG file of current sheet and then email it to the recipients you want. Look into API documentation for Exporting sheet to jpeg or bmp, and search here in the community to find code for emailing from QV macro with an attachment.
