Thread: CDO Email
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steph[_3_] Steph[_3_] is offline
external usenet poster
 
Posts: 312
Default 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!