We help IT Professionals succeed at work.

Emailing crystal report

Gordon Hughes
on
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?
Gordon
Comment
Watch Question

Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Have you looked into Visual Cut?
https://milletsoftware.com/Visual_CUT.htm

mlmcc
Partha MandayamTechnical Director

Commented:

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

https://www.tek-tips.com/viewthread.cfm?qid=133958

Gordon HughesDirector

Author

Commented:
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!!!
Top Expert 2011

Commented:
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.
Gordon HughesDirector

Author

Commented:
I have purchased Visual Cut, now to work out how to use it!!
Gordon HughesDirector

Author

Commented:
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?
Gordon
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
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.

mlmcc
Ido MilletProfessor Emeritus of MIS at Penn State Erie and Owner, Millet Software

Commented:
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 HughesDirector

Author

Commented:
All
Thanks for your help