![]() |
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! |
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