Solved

Automating E-Mail of a Query and/or Crystal Report

Posted on 2011-03-13
2
230 Views
Last Modified: 2012-06-22
Hello,
I have an idea for a program, that I haven't started developing yet, (hence why I don't have any sample code yet.)

However, I wanted to know if it was possible to automatically E-Mail results of an SQL Query (DataGrid View results) and/or Crystal Reports results (without having to go through Outlook)?

Please let me know if it's possible or if there are any demo links I could take a look at.

Thanks

0
Comment
Question by:--TripWire--
2 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 25 total points
ID: 35124805
Crystal reports can be exported to a MAPI mail system.  

mlmcc
0
 
LVL 75

Assisted Solution

by:käµfm³d 👽
käµfm³d   👽 earned 25 total points
ID: 35124810
If you have access to an SMTP server, the SmtpClient class along with the MailMessage class can be used to send email.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Removing blank spaces between pivot table lines. 12 42
update textboxes with Streamreader 21 42
business objects to connect to MSSQL 6 63
Crystal reports filter out records 2 22
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
This script will sweep a range of IP addresses (class c only, 255.255.255.0) and report to a log the version of office installed. What it does: 1.)      Creates log file in the directory the script is run from (if it doesn't already exist) 2.)      Sweep…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

864 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now