Avatar of Gordon Hughes
Gordon Hughes
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Emailing crystal report

Ok, I have a report that outputs information about individuals one per page
I want to distribute this via email to the individuals, I know I could get some bursting and distribution software, but it is far too expensive. So looking for other ways.
My first thought is, can I add the email address as a link in the crystal report, I have some free software that woul burst a pdf file, which I could export from CP
Maybe then I could find something that could use the link to send the emails
All sounds very complicated!!
Anybody got any ideas?
Crystal Reports

Avatar of undefined
Last Comment
Gordon Hughes

8/22/2022 - Mon
Mike McCracken

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Partha Mandayam

You can create an email link in a report. Here's how


Gordon Hughes

Looking at the Visual Cut, maybe I have to bite the bullet and pay!!!
Trying to get the evaluation copy, but no success as yet!!!

R-Tag Community edition is free (http://r-tag.com/Pages/CommunityEdition.aspx). I saw in the other question you are looking for bursting. It is supported and it supports also data driven reports (for data driven option you need a paid license). Free trial can be downloaded directly from the link above.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Gordon Hughes

I have purchased Visual Cut, now to work out how to use it!!
Gordon Hughes

Ok having got Visual Cut
To start:-
What do I need to do in Crystal Report so that it can see the induvial email address
Guess I have to create a formulae which show the email address (but what should the formulae look like and where should I place it on the report?
Mike McCracken

The documentation is usually pretty good.  Also the developer is usually good at answering questions.

I haven't used it so I really don't know how to do things with it.

Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Ido Millet

Hi Gordon,

In bursting scenarios, if the database doesn’t contain an email address for each Group Level 1, you can use a suppressed Crystal formula (in GH1 or GF1 sections) to return a different email destination for each Group. For example:

Select {Branch_Manager.ID}
Case 101: "Jim@Acme.com"
Case 103: "Amy@Acme.com;Don@Acme.com"
Case 204: "Veronique@Acme.com"
Default: "serge@Acme.com";

Open in new window

If the database already contains the email address (or addresses) associated with each Group Level 1, simply place the field in GH1/GF1. Again, no need to make it visible on the report. It, or the section it's on, can be suppressed.

Consider directing questions about specific products to the company behind that product.
Gordon Hughes

Thanks for your help