Creating email hyperlink field
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15984
Printed Date: 18 Apr 2025 at 7:09pm
Topic: Creating email hyperlink field
Posted By: paulmcm
Subject: Creating email hyperlink field
Date Posted: 26 Mar 2012 at 4:54am
Hi, I've a name field on my report that I am trying to format so that when clicked it will open an email with that persons email address in the recipient's box. In my hyperlink tab in the Email Address box there's;
mailto: (at this point I click the formula editor and would like to concatenate on the email address field from the DB)
I only have the field name in the formula editor text:
{tbl_Presenters.EmailAddress}
Is what I am trying to do possible?
|
Replies:
Posted By: paulmcm
Date Posted: 27 Mar 2012 at 4:33am
After a lot of online reading I have finally managed to get my email hyperlink field to work BUT when I click the name to open an email, the format of the email doesn't look quite as I expected. Here's my mailto formula:
"mailto:"+{tbl_Presenters.EmailAddress} +
"?subject="+ {tbl_Companies.CompanyName} + "-" + "Company" + "#:" + {tbl_Companies.RegistrationNumber}
"&body=Hi"+{tbl_Presenters.PresenterName} + "," +
"&body=Just a quick email remind you that this return is due in on 26/04/2012." +
"&body=Would appreciate if you confirm when this has been done and also please let me have a copy for our files." +
"&body=Many thanks and" +
"&body=Kind regards" +
"&body=Liz"
but within outlook the email is like this:
To:ABC@ABC.Com - which is good
Subject: bee-Company#: - I have tried entering empty strings to help the format but everything after the empty string doesn't not display
Body: HiLiz - again the same as the subject line empty strings to create blank spaces don't work, and I'm only getting the first line of the body outputted.
Can anyone see what I am doing wrong to cause only 1 line of the body to be outputted? Any help on the formatting would also be appreciated..
Thanks Paul
|
|