I have been able to now add a logo (graphic) to the body of an email with this code:
I would like to make that Logo.png be a variable that I find in a cell on my open worksheet. Have written this code but it does not work
Please Login or Register to view this content.
Any ideas?Please Login or Register to view this content.
Last edited by Bobbbo; 06-08-2016 at 12:38 PM. Reason: Mark it solved
Just a guess but are you using the right name? In your code that worked you used logo1.png but on your explanation you used logo.png! Are you using the exact spelling in your Q12 cell with the .png extension?
Happy with my advice? Click on the * reputation button below
Sorry for the confusion, probably a bad choice of names. In cell Q12 there is a formula that determines the picture (logo) name. In this case the formula returns= logo1.png. The variable DIM logo assigns the path for the picture. Then I was expecting that in this code below the 'logo' would be replaced with the Path assigned to that picture.Originally Posted by Crooza
Please Login or Register to view this content.
This works for me
Please Login or Register to view this content.
Thanks I will give it a try and let you know.
I tried it out and it works perfectly. Is there a way you can have it put a picture, like "Picture 200" found on a page of the workbook rather than a path to a picture found on your hard drive?
I tried it out and it works perfectly. Is there a way you can have it put a picture, like "Picture 200" found on a page of the workbook rather than a path to a picture found on your hard drive?
Never tried that. I'll see what I can do.
Great thanks and also thanks for your previous solution!
Double post
Last edited by Crooza; 06-09-2016 at 11:38 PM. Reason: Double POST!!!!!
Sorry for delay but this should do what you want. (if you've got more than one embedded image though let me know as this takes the first shape it finds on the page.) If you've got more than one shape / picture it might grab the wrong one.
Not all my own work - I borrowed code form another source. It's a bit of a workaround as I couldn't see how you can take an embedded file from your workbook and put it into an email without first saving it as a file so it creates a chart, saves to a temp directory on your c: drive then deletes the chart then uses the file in the email program. If you've got security settings on your c: drive this may stuff it up too!!
give it a go and let me know how it works. (It works my end)
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks