HTML email into strings for use in Outlook

Send Email.xlsm

I need to set up my code to where it builds the entire html file. Once I have all my html in a string, lets call it strHTML…
.HTMLBody = strHTML

Do I need to keep the HTML tags.
For example,

Please Login or Register  to view this content.

The formatting is really throwing me off for excel VBA strings in HTML. Set a reference to "Microsoft HTML object library" in the Developer in VBA.

This is what is reading in Outlook:

Dear Random people in company,
If you would like the code. Email me.Unique IDProduct1Chips2Dip3Hummus4Pepsi5AquafinaThank you,Your Name

Can someone please help me, so that this table and picture show up in the body of the email?

I put that code in my ExportToHTML function. What else should I do with your code?? I am not getting a formatted HTML table.

Please Login or Register  to view this content.

PracticeEmail.xlsm

I tried shortening my code to see what the problem was with the table. And even this code doesn't work.

Please help with my VBA code to get the table and picture to send in Outlook using HTML!!

Dear Leith Ross,
I put the code you posted into excel. Maybe it's my Outlook that's not reading the colors. What code should I change to get it to work in Outlook 2010?

Please Login or Register  to view this content.

This part of the code, I've never seen before. Can you explain this??

PracticeEmail.xlsm

Thank you!

PracticeEmail.xlsm
GES logo.jpg

I used this website to convert my .jpg to a string.
http://www.askapache.com/online-tool...age-converter/

Everything works now in Outlook 2010, except for the InsertPhoto() function.

Please Login or Register  to view this content.

Picture example img width =””176”” turns into width=”176”

I call the function in the Sub EmailRangeInHTML(....)

Please Login or Register  to view this content.

What am I doing wrong?? I have attached the photo and the excel file. Thanks

With the string being in base64, it seems outlook won’t decode it properly…
How would I convert a .jpg to MHT instead of HTML?

Right, but it still doesn't work for me. I posted on that forum too

Yes, you posted code that is .Attachments.Add which adds the attachment to the file, not the body of Outlook.
I would like the .HTMLBody portion of the image to work.

Please Login or Register  to view this content.

emailCapture.PNG

In my send folder, this is what I get when I do it your way (.png file)

Please Login or Register  to view this content.

I kept the .attachments.add part, just because I forgot to comment it out.

Please Login or Register  to view this content.

I removed the space after cid:

I still don't see the image in the body of Outlook. Have you seen the excel file I've been working on?? It's called "PracticeEmail.xlsm" I've attached it in this forum.

PracticeEmail.xlsm

I know how to add photos to my signature, that's not the problem. I pressed the button and the .Send was activated to send the email. I don't know if my code is in the wrong spot. I can upload my file again. Could you pinpoint what is wrong in the code? Also, is it something you Referenced in VBA, like a Microsoft library??

Your code exactly matches my code. I don't see any difference.

What section of the code did you put that in? Is it Outlook 2010 specific?? Because that's what version of Outlook I have.

Please Login or Register  to view this content.

PracticeEmail.xlsm

Here is my current file. I hope this helps

It definitely works now! I just needed a space and I needed to make the name with underscores in it.

Please Login or Register  to view this content.

Thanks you for your persistence. I will mark this thread as solved!

This code works great except for the fact that iPhone users cannot see these images. It just displays the image name. Does anyone know how to resolve this? I've tried both PNG and JPG.