list of items displayed in same line in the email

[Roshan.Shakya]

Hi Gurus,

I have written the following code to automate email that is sent to one of my colleagues every month. One aspect is that I have got list of items which is dynamic and keeps on changing every month. The following code creates email with signature (in original format), but the list of items is displayed in the same line instead of a new line. I have used the loop to address this issue but it works only when I use plain text email format and not HTML format . I want to use HTML email format to use signature at its original format.

Please Login or Register  to view this content.

Can you please suggest code that creates new line for every list item? I appreciate your advice.

Thank you
Roshan Shakya

[AlphaFrog]

Change the vbCrLf to HTML < br >

Please Login or Register  to view this content.

[Roshan.Shakya]

Thank you AlphaFrog.

Much appreciated.