[AccessD] CRLF in email

Hi Rocky

If you are writing in HTML then you can use HTML tags in your text... <br> to add a line break.

myItem.HTMLBody = "Thank you very much for your order.<br><br>" & _
    "Please review the attached rental agreement and call or e-mail me with any " & _
    "questions or changes.<br><br>" 

Kind regards
Hadyn



-----Original message-----
From: "Rocky Smolin at Beach Access Software" rockysmolin at bchacc.com
Date: Fri, 12 Sep 2008 10:13:13 +1200
To: "'Access Developers discussion and problem solving'"accessd at databaseadvisors.com
Subject: [AccessD] CRLF in email

> Dear List:
>  
> I am trying to add some text and a signature to the body of an email with a
> report attached.  Everything works fine except the carriage return/Line
> Feed.  I'm using the following:
>  
>  
> myItem.HTMLBody = "Thank you very much for your order." & Chr(10) & Chr(13)
> _
>     & Chr(10) & Chr(13) _
>     & "Please review the attached rental agreement and call or e-mail me
> with any " _
>     & "questions or changes." & vbCrLf & vbCrLf _
>     & "If this looks good to you, please complete the credit card
> authorization " _
>     & "form and fax it back to us at (858) 560-9900." & vbCrLf & vbCrLf _
>     & "Ken Gimbel" & vbCrLf & "ph 858.560.5000 | fx 858.560.9900 " & vbCrLf
> _
>     & "4909 ruffner st. | san diego, CA 92101 " & vbCrLf _
>     & "www.voiceandvideo.com "
>  
> and neither CHR(10) & Chr(13) nor vbCrLf work.  The email body comes out
> looking like this:
>  
> Thank you very much for your order. Please review the attached rental
> agreement and call or e-mail me with any questions or changes. If this looks
> good to you, please complete the credit card authorization form and fax it
> back to us at (858) 560-9900. Ken Gimbel ph 858.560.5000 | fx 858.560.9900
> 4909 ruffner st. | san diego, CA 92101 www.voiceandvideo.com 
>  
> No returns or line spacing.  Does anyone know what I'm doing wrong here?
>  
> MTIA
>  
> Rocky
>  
> 
> 
>  <C:\DOCUME~1\ROCKYS~1\LOCALS~1\Temp\\attdb4c3.jpg> 	
> 	
>  
> 
> Rocky Smolin
> 
> Beach Access Software
> 
> 858-259-4334
> 
> www.e-z-mrp.com <http://www.e-z-mrp.com/> 
> 
> www.bchacc.com <http://www.bchacc.com/> 
> 
>  
> 
>  
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com