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