Is there a way to Copy And Paste Excel Range As Picture Into Outlook Email Body Using Excel Vba
Is there a way to Copy And Paste Excel Range As Picture Into Outlook Email Body Using Excel Vba
In excel 2007+ I think in the ribbon the copy button has a drop down option for "copy as picture".
In excel 2003 if you hold shift and click edit->copy it will change it to copy as picture.
Than paste it into your message as you would a normal picture.
will copy the picture![]()
Please Login or Register to view this content.
I am not sure about the adding of the image, in the past i've saved the image and built the email text in HTML format inserting an image in image tags.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks