Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
Email editor closes when forwarding Excel-embedded email | Setting up and Configuration of Excel |