CDO Emails and Reports

[kerrance76]

Hello

I am building an application with an email function and would like to be able to attach reports to some of these emails. The place where the app will be installed has its own email servers and as the users all use different mail systems, either outlook, pegasus, webmail or thunderbird i decided to implement a system using CDO.

I know how to attach files from the hard disk to an email but is there a way of generating reports and attaching them straight to an email without saving a hard copy first?

Thanks

 

[John.Woody]

I save a hard copy first, either as an html doc or as an Excel spreadsheet. The user doesn't need to attach the file, its handled automatically, they just complete the email address and click send. The file name I use is the same as the report name.

You could always delete the created file once it has been sent, but I don't bother, mine arn't that big and they will be overwritten next time the report is generated.

 

[kerrance76]

Thanks for the reply i guess thats what I'll need to do as well,

thanks again