#1   Report Post  
Posted to microsoft.public.excel.programming
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!




  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 575
Default 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!






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Macro how to create email link for the email addresses in aRange or Selection Satish[_2_] Excel Worksheet Functions 8 December 28th 09 03:30 PM
send wkbk as an email attachment with an email address copied from SueInAtl Excel Discussion (Misc queries) 0 May 21st 07 10:53 PM
can I copy a column of email addresses, paste into email address? Lizizfree New Users to Excel 4 July 20th 06 10:03 PM
Transfer Email addresses from spreadsheet to email address book Beana Excel Discussion (Misc queries) 2 May 30th 06 06:07 PM
Email editor closes when forwarding Excel-embedded email Bambina Setting up and Configuration of Excel 0 March 16th 06 10:45 PM


All times are GMT +1. The time now is 12:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"