Hi,
I've been looking to send a cell range from excel via outlook email, which I have managed successfully with the vba code I found below. However I would like to embed or have added a picture in a similar fashion to the insert--picture route. The picture is currently located in a network folder s:\headers.
I've spent a little while searching for a solution but the answeres I found went miles over my head.
Please Login or Register to view this content.
This works for me (Excel & Outlook 2003).
The RangeToHTML function is the same as in your post.Please Login or Register to view this content.
As noted in the comment in the code, if you use Send to send the email immediately instead of Display, the image appears as a file attachment rather than an embedded image. If you prefer Send and having the image properly embedded, try the code at http://www.outlookcode.com/d/code/htmlimg.htm, combined with the string manipulation in my code which inserts the image tag in a suitable place in the HTML string.
wow that simple eh?
That was so helpful thank you!
Last edited by Kramxel; 04-19-2012 at 06:52 AM.
Your initial reply, now edited, asked how to put the image at the top of the email rather than the bottom. Maybe you've worked it out, but for the benefit of others here's how.
Replace:
with:Please Login or Register to view this content.
Please Login or Register to view this content.
Post responsibly. Search for excelforum.com
Hi Chippy,
Yes I did manage to work it out realised like most things the solution was far easier than I was expecting so quickly removed it (well not as quickly as I had hoped).
once again thank you so much.
althogh I didn't add the + Len("<body>") O just took the / away... i'll add that now and see what the difference is.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks