[AccessD] CRLF in email

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




More information about the AccessD mailing list