Solved

Send Dynamic Pages By Email

Posted on 2012-03-25
3
304 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

So you have coded your own WordPress plugin and now you want to allow users to upload images to a folder in the plugin folder rather than the default media location? Follow along and this article will show you how to do just that!
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

762 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

18 Experts available now in Live!

Get 1:1 Help Now