Vba to draft html body in outlook

Hi Team,

I need help to update one of the vba codes that I am using to draft outlook emails.

Below is the code that I am using to write in the body of the email. I am looking for the code that I have to add so that numbering is added to the sentences. I learned that <li> can add bullet points but I am looking for the numbering so if there are 10 sentences it is numbered from 1 to 10.

Also there is an image that is pasted in the body of the email - "<img src='C:\Users\12345\Desktop\download.jpg'" & "width='400' height='200'><br>".

I am trying to push this image alone to few centimeters to the right in the body of the mail. I tried adding spaces before the image but that didn’t work out.

Please help.

Please Login or Register  to view this content.

Hi Team... Please help..

hi there,

Can you please highlight the part that you want to be numbered?
This is more an HTML Question then VBA :D
You are Right with LI you can make a list and when you use <ul> it will be bullets but with <ol> you get an ordered list with numbers or letters.

the HTML for a numbered list is this

Please Login or Register  to view this content.

Assuming you have the code you posted above in a for loop you would have to put the <ol type="1"> part outside the loop and then encapsulate the numbered parts in <li> </li>

Originally Posted by LordLoki

hi there,

Can you please highlight the part that you want to be numbered?
This is more an HTML Question then VBA :D
You are Right with LI you can make a list and when you use <ul> it will be bullets but with <ol> you get an ordered list with numbers or letters.

the HTML for a numbered list is this

Please Login or Register  to view this content.

Assuming you have the code you posted above in a for loop you would have to put the <ol type="1"> part outside the loop and then encapsulate the numbered parts in <li> </li>

Thanks a lot for your reply and sorry for not highlighting the part to be numbered..
Below is the same code and the underlined sentences need to be numbered..
I tried to update it myself but got compile error..

Need your help please..

Please Login or Register  to view this content.

Originally Posted by LordLoki

is it possible for you to upload a worksheet with your working code?
The Data can be testdata but like this its very difficult to update your code.
cause i can not tell how its working and how the putput looks now with that piece of code

Sure.. Attached is the workbook.. The HTML body is where I need help..

You can't attach the image like that as the recipients will not have access to your desktop. You'll want to upload it somewhere everyone has access to

Hi Arun,

Attached your workbook with numbers at the parts that you highlited.
Hope that is what you need.

If not send me a screenshot of the mail where i can see how the numbers should be.

Greets
Loki

Originally Posted by Kyle123

You can't attach the image like that as the recipients will not have access to your desktop. You'll want to upload it somewhere everyone has access to

Can you please suggest a way forward.. Do you really need to look at the image because I need help to change the colour of sentences..

No, I don't need to see your image, but the recipients do. So you need to upload it to a place they all have access to

Hi arun,

I changed the Code so that the Image will be attached to the mail and then shown embedded.
This way the image does not need to be in a location where everyone has access.

Make sure to add the location to the image here

Please Login or Register  to view this content.

And put the name of the file here after the cid: that needs to be the same as the name above

Please Login or Register  to view this content.

Originally Posted by LordLoki

Hi arun,

I changed the Code so that the Image will be attached to the mail and then shown embedded.
This way the image does not need to be in a location where everyone has access.

Make sure to add the location to the image here

Please Login or Register  to view this content.

And put the name of the file here after the cid: that needs to be the same as the name above

Please Login or Register  to view this content.

This is working really good as expected.. Thank you so much...

I need one more help.. As mentioned in my initial request,I am trying to push this image alone to few centimeters to the right in the body of the mail...

Requesting for your help..

Hi Arun,

Change the HTML part to this

Please Login or Register  to view this content.

You can set how far by changing this part

Please Login or Register  to view this content.

Greets
Loki

Originally Posted by LordLoki

Hi Arun,

Change the HTML part to this

Please Login or Register  to view this content.

You can set how far by changing this part

Please Login or Register  to view this content.

Greets
Loki

Thanks a lot.. This is working fantastic..

The only thing is, after the image there is signature and that too is pushed to right..

Can you please update so the image alone is moved to right all sentences after that is not moved..

Please help..

Hm thats odd the div should only encapsulate the image. Will look into that later

Gesendet von meinem HTC One mit Tapatalk

Hi, please help in this request..

problem is fixed with the code i offered for your problem in THIS Thread.

my code was working fine but you forgot to close the div after the image in your code

Originally Posted by LordLoki

problem is fixed with the code i offered for your problem in THIS Thread.

my code was working fine but you forgot to close the div after the image in your code

Thanks a lot... I am excited to see the codes working as expected.. This was great help..