Crystal Report - Text Box Applied as an E-mail Hyperlink

Posted on 2009-04-17
Medium Priority
Last Modified: 2012-06-22
On my crystal report design we've create a request form. At to the top of the request form we a text box that is a hyperlink to an email address. Within format text - hyperlink, we have the code below for the e-mail address hyperlink which works great. We need to be able to add a database field to this, i.e. account number or borrower name. When we get the emails back, we don't know which record it's associated with. Is there any way to add a database field to email or should we approach this in a different way. Thanks.
mailto:myemail@isp.com?subject=Accept&body=The appraisal request has been accepted

Open in new window

Question by:asmyatt
LVL 18

Accepted Solution

UnifiedIS earned 2000 total points
ID: 24170605
Use the formula builder from the hyperlink formatting tab and append your field to the mail string

formula would look like this if you wanted to show the {?RequestID} parameter:


"mailto:myemail@isp.com?subject=Accept&body=The appraisal request has been accepted--RequestID = " & {?RequestID}

After clicking the link, the mail message opens and the body reads:
The Appraisal Request has been accepted--RequestID = 367-6778

Maybe it would be better suited for your subject line but either way, the way to do it is to build a string in the formula builder

Author Closing Comment

ID: 31571458
Exactly what I needed. Thanks.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Screencast - Getting to Know the Pipeline
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question