Solved

Send Dynamic Pages By Email

Posted on 2012-03-25
3
306 Views
Last Modified: 2012-06-22
I have a web app that generates report cards for online viewing.  The school wants to be able to email these report cards as web pages, sans security.  This could be tough to do as a result of the session variables that are set when a user logs on to the site.  Is there a clean way to do this (with cdo sys I assume?)?  Is there a way to create the report, convert it to a pdf, and send it off in one fell swoop?  Is the only real option to use fso and send them as text files?  Is it even a good idea to do this?  Would it be better to simply send an email that says the report cards are online via their secure log in to the site?  Any thoughts and/or advice is much appreciated.

Thanks for creating such an awesome resource...well worth my money!
0
Comment
Question by:Bob Schneider
3 Comments
 
LVL 28

Assisted Solution

by:sammySeltzer
sammySeltzer earned 250 total points
ID: 37765815
Would it be better to simply send an email that says the report cards are online via their secure log in to the site?

This seems to me, as the most logical approach.

You could use Microsoft word as an attachment.

This method is not really hard but very tedious because it requires carefully formatting and styling a table, saving a copy on your server, then streaming data into this word document, grab it and email as an attachment.

Finally, deleting the copy you just emailed.

At least that's how I would handle it.

It isn't really pretty.
0
 
LVL 25

Accepted Solution

by:
TempDBA earned 250 total points
ID: 37776689
Check out the following link. But, you need to create a SSRS report. You have even got an advantage of sending the report via different rendering process.

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27458276.html
0
 

Author Closing Comment

by:Bob Schneider
ID: 37786343
Given the complexity of the report, I think the thing to do is to just send email notification that it is available online.  Thanks for the time!!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
align Linkedin sign to the right page 5 35
Problem to refer to value 8 46
Slow Connectivity over ODBC 8 33
sql server insert 12 30
This article describes how to create custom column layout styles for Bootstrap. The article uses 5 columns to illustrate the concept, but the principle can be extended to any number of columns.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…

776 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