ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   CDO Email (https://www.excelbanter.com/excel-programming/320076-cdo-email.html)

Steph[_3_]

CDO Email
 
Hello. Thanks to Ron deBruin, I have the following piece of code that I
modified from his website. The code in whole sends an e-mail.

strbody = "This is a test"
..HTMLBody = "Click on the link to choose your file: <a
href=""\\server\folder\file\file""FolderName</a" & vbNewLine & vbNewLine &
strbody

All I am trying to do is skip a few lines in the body of the e-mail between
the hyperlink and the strbody string. If I change the .HTMLBody to
..textbody, this does skip lines, but the hyperlink is not formed. Using
..HTMLBody creates the hyperlink, but ignores the vbNewLine and does not skip
lines. Any ideas? Thanks!





Robin Hammond[_2_]

CDO Email
 
Steph,

I'm not sure about the vbnewline thing, but I have a CDO system running that
appears to work by using a direct chr(10) code on an asp page.

e.g.

objCDOMail.Body = "We will send you a password as soon as possible" & _
chr(10) & chr(10) & "Thanks," & chr(10) & chr(10) & "Robin Hammond"

Alternatively, if the HTMLBody property is only accepting HTML and you are
sending as html to an enabled mail client, have you tried using the html
paragraph mark rather than a new line.

e.g.

</p<p

Robin Hammond
www.enhanceddatasystems.com

"Steph" wrote in message
...
Hello. Thanks to Ron deBruin, I have the following piece of code that I
modified from his website. The code in whole sends an e-mail.

strbody = "This is a test"
.HTMLBody = "Click on the link to choose your file: <a
href=""\\server\folder\file\file""FolderName</a" & vbNewLine & vbNewLine
&
strbody

All I am trying to do is skip a few lines in the body of the e-mail
between
the hyperlink and the strbody string. If I change the .HTMLBody to
.textbody, this does skip lines, but the hyperlink is not formed. Using
.HTMLBody creates the hyperlink, but ignores the vbNewLine and does not
skip
lines. Any ideas? Thanks!








All times are GMT +1. The time now is 04:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com