[AccessD] CRLF in email

Dan Waters dwaters at usinternet.com
Thu Sep 11 16:26:17 CDT 2008


Rocky - I don't know why this isn't working - but you can replace vbCrLF
with vbNewLine.  It's just easier to read and type.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Thursday, September 11, 2008 4:13 PM
To: 'Access Developers discussion and problem solving'
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




More information about the AccessD mailing list