Emailing individual report

I have a report from a database with 400 odd names
I would like to be able to email idividually all the people with the individual report, but do not know If it is possible, and if so, how to set this up

Gordon
Gordon HughesDirectorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
Just about anything is possible given enough time and money.

Sadly there isn't enough information provided to begin to formulate a response.

The only Topic Area provided is:  Databases.

What database are you using?
What is generating the report?
Do you have direct access to an email relay or server?
Éric MoreauSenior .Net ConsultantCommented:
as already said, more information is required!

If you have a single report containing all the 400 names and you want to send each name its specific page, you will need to first cut the report in 400 different reports. Then I hope you have the email addresses somewhere.

But since we don't know what you have and what you need, we can't really get deeper!
Gordon HughesDirectorAuthor Commented:
Hi All
I have an SQL database with members information for a club, need to comply with GDPR
The members have a renewal date of 1/04/2019
I would like to send each member a pdf document showing the information we hold on the system
I have created a crystal report which shows the information, so would get around 400 reports.
Now the question is how to distribute it to the members, ideally would like to create a pdf file from the report 400 of them and then where the members have an email address, email them their details, using outlook with a read receipt option,.

The question is can this be done and if so how

Gordon
Monitor and Analyze Slow Network Performance

SolarWinds® Bandwidth Analyzer Pack, is designed to detect, diagnose, and resolve network performance issues, and monitor and test network throughput and traffic patterns from a single customizable console.

Éric MoreauSenior .Net ConsultantCommented:
I never use Crystal Reports as a standalone tool. Do you have a .Net application in front of it that could handle the report and email generation?
Gordon HughesDirectorAuthor Commented:
Hi
No idont have a .net application
Gordon
Éric MoreauSenior .Net ConsultantCommented:
I have added Crystal Reports to your topics to help you find more experts. Since you don't have a .Net front end, I can't help you
slightwv (䄆 Netminder) Commented:
>>I have an SQL database

I assume SQL Server?  SQL is a query language used by most databases.  Please confirm so we can add the correct Topic Areas so the best possible Experts see the question.
Gordon HughesDirectorAuthor Commented:
Hi Eric
How would you do this using a . Net application?
Microsoft SQL is a database platform and crystal reports is a method of creating reports from various database platforms
Gordon
Éric MoreauSenior .Net ConsultantCommented:
.Net can be use to populate a report from Crystal Reports one email address at a time, save the PDF and generate the email.

I have an article showing the first part: https://www.emoreau.com/Entries/Articles/2016/10/Crystal-Reports-for-Net-revisited-10-years-later.aspx

Sending the email is another article.

But if you are not a .net developer, you are starting from too far to just simply reply to this question!
Raghavendra HullurSoftware DeveloperCommented:
Hi,

How do you run the Crystal Reports?
Are they executed from any front end application or using Crystal Reports Server?
mlmccCommented:
Ken Hamady has a list of scheduler applications for both the desktop and server.  Some are not very expensive and probably easier than writing your own application

https://kenhamady.com/productlinks/default.html#desktopsched
https://kenhamady.com/productlinks/default.html#serversched
https://kenhamady.com/productlinks/default.html#email

mlmcc
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
The feature you are looking for is called Report Bursting.
Some of the tools in the link provided by mlmcc support bursting reports to individual export files and emails.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.