[AccessD] Using MailTo: hyperlink in form; need carriage returns in body text

Hi Bob,

Thanks very much for your reply and suggestion.  About the same time I read
your reply, I heard from someone else (not on this list) that:

"if you use the characters %0A (percent-zero-A) that the linefeed will be
embedded in your message.  (This is the hex equivalent as chr$(13) except
that it has been URL-encoded to work with HTTP.)"

I'll be testing both approaches this afternoon.  Thanks again!

Best Regards,

Julie Schwalm
Backroads Data
www.backroadsdata.com
785-594-6807
----- Original Message -----
From: "Geldart, Robert" <RGeldart at detma.org>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Thursday, September 04, 2003 1:44 PM
Subject: RE: [AccessD] Using MailTo: hyperlink in form; need carriage
returns in body text


> Julie,
>
> Codes within html codes can be problematic. My html reference says to try
> something like:
> &#n; - where n is the base-10 number of the character.
>
> So something like
> 
 (for cr)
> 
 (for lf)
>
> I think you can string them together:
> 

>
> Hope this helps,
> Bob Geldart
> Economic Research Department
> Massachusetts Department of Employment & Training
>
>
> -----Original Message-----
> From: Backroads Data [mailto:backroad at idir.net]
> Sent: Thursday, September 04, 2003 2:01 PM
> To: AccessD
> Subject: [AccessD] Using MailTo: hyperlink in form; need carriage returns
in
> body text
>
>
> Hello group,
>
> Using Mailto: protocol in a hyperlink, I'm including the email address,
> subject line, and body text.  Is there a way to include carriage returns
in
> the text?  Here's the situation:
>
> There's a textbox on a form that contains 4 lines of text; this text block
> is built through code and uses the vbNewLine variable after each line.
The
> contents of the textbox look like this on the form:
>
> Name:           John Doe
> Business:       Backroads Farrier Service
> Shortterm Code: 7083-603-718-5836
> Request Code:   F003-B863-A003
>
> After the textbox contents are built, it sets the hyperlink property of a
> command button on the form, like this (watch word wrap):
>
> Me!btnEmail.HyperlinkAddress =
> "mailto:info at backroadsdata.coml?subject=Lifetime License Request&body=" &
> Me!txtRequest
>
> When the button is clicked, an email is created, and the message body
> section contains the text from the form, but it looks like this:
>
> Name:           John DoeBusiness:       Backroads Farrier ServiceShortterm
> Code: 7083-603-718-5836Request Code:   F003-B863-A003
>
> Is there anyway to embed something the email will recognize as a carriage
> return, so that it appears in the message on 4 distinct lines?  (I've
tried
> Chr(13) & Chr(10) as well as vbNewLine when building the textbox.)
Thanks!
>
> Best Regards,
>
> Julie Schwalm
> Backroads Data
> www.backroadsdata.com
> 785-594-6807
>
> _______________________________________________
> 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
>