Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Fri Sep 12 13:03:10 CDT 2008
Dan: Worked a treat in Front Page (which is all I got). Like cribbing the SQL out of a query or recording a macro in XL to use in a module, huh? Thanks. Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, September 12, 2008 5:33 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] CRLF in email Hi Rocky, I did something like this once upon a time. First, I used Expression Web to create a page that looked like I wanted it to look. Then switched to code view to see the HTML. I copied that to VBA code, and made syntax mods so it would work there. This will keep you from guessing what you have to type in HTML to get what you want. I bet there are a number of free apps that would do the same thing. Maybe even Word? HTH! 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 8:10 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] CRLF in email Darren: Nothing more or less than using <b /> for CrLf. But now the user has ANOTHER request. He'd like the sig in Eras Medium ITC, and some in blue and some in black. Anybody? :o) MTIA, Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren D Sent: Thursday, September 11, 2008 5:56 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] CRLF in email Hi Rocky and team I have this exact same issue - Can you post the solution? Thanks Darren -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Friday, 12 September 2008 8:12 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] CRLF in email Looks like the <b /> works in plain text comin' and goin'. Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----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 2:55 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] CRLF in email Would using <p> work if the email client is set to display only plain text? Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael Bahr Sent: Thursday, September 11, 2008 2:48 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] CRLF in email Rocky, proper html formating should be <p>bla bla bla</p><p> </p>. You could also use <br>. The difference is <br> is a soft-return where <p> is a hard-return. However you should consider using both CRLF and <p>. This is the same as looking at the source of a web page. Using the CRLF formats the source and the <p> formats the html. Some email readers may be set to display only plain text (strip out html) so then the formating would still remain the same. Mike... > 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 > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com