Hi all,
I want to use VBA to take a screenshot and send as an email attachment (not email body). Below code is what I've got so far. It does successfully take a screenshot and save it to the clipboard, however, it does not let me "paste" or "attach" it to the email... Any ideas?
Please Login or Register to view this content.
Are you wanting a screenshot of a specific range within excel spreadsheet ...
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Just a general screenshot of Excel or the windows screen...
Give this a go...
Please Login or Register to view this content.
Thanks! That seems to work, will need to do more testing on Monday though
Last edited by esbencito; 07-29-2019 at 03:06 AM.
Is this feasible as well without having to save the image to a folder first?
What would there be to attach...
I have read about a method where the "word object model" is used for pasting images from the clipboard directly. Unfortunately I don't seem to get it to work.
https://www.slipstick.com/developer/...-contents-vba/
So you are wanting to paste the image into the body of the email and not attach it as a file...See if this helps...
https://excel-macro.tutorialhorizon....k-using-excel/
https://social.msdn.microsoft.com/Fo...forum=exceldev
Last edited by sintek; 07-30-2019 at 02:51 AM.
I don't, I want it as an attachment and was hoping that this method can be used for that as well...
So why would you want to fix something if it ain't broken...Does post 4 not work for your requirement...
my apologies if i'm crossposting
@sintek if i'm using gmail how do i send the email with the attachment?
Administrative Note:
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
As sintek says, you need to save the file to be able to attach it, you can't just magically have a file appear as an attachment without it existing.Originally Posted by esbencito
You can however delete it once you're done with it, stick this line at the end of the code and it'll be like it never existed.
Please Login or Register to view this content.
my apologies, i will start a new thread
Last edited by AliGW; 07-31-2019 at 03:15 AM. Reason: Please don't quote unnecessarily!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks