Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sanjiv
Starting Member
2 Posts |
 Posted - 2004-11-08 : 02:12:53
|
| HiI would like to email a report from VB6. The report is developed in Reporting Services, but since my clients have the standard edition, database driven subscriptions are not available. I would like to simulate this feature in VB6. Is this possible? |
|
|
jhermiz
3564 Posts |
Posted - 2004-11-09 : 19:02:09
|
quote:
Originally posted by sanjiv
HiI would like to email a report from VB6. The report is developed in Reporting Services, but since my clients have the standard edition, database driven subscriptions are not available. I would like to simulate this feature in VB6. Is this possible?
Hmm I've done this in the past writing a vb6 exe to export crystal reports. What format are you sending the reports? You can just add this ".exe" into your windows task scheduler on your server. It will then snatch the reports, create an email object with an attachment (the report) and send it to a list (maybe from a database).The key is you'll have to setup SMTP or some mail client on this server, but definately doable.Jon |
 |
|
|
sanjiv
Starting Member
2 Posts |
Posted - 2004-11-10 : 02:09:37
|
| I have to email the report in pdf format. We have a schedule engine that can do the scheduling and emailing, I am going to use that.I am having a problem with getting the pdf document so that I can email it. I don't know how to get the pdf document. I don't mind getting the pdf doument and saving it somewhere and then my scheduling engine will attached the document and mail it. But I don't know how to get the doc and save it. Pls help, I have already spent 2 weeks trying to find a solution. |
|
|
|
|
|
|
Email Report from VB6