Sending a report by e-mail

Sending a report by e-mail

Posted by: j0k3rm4n on 4 August 2017, 5:58 am EST

• 

  j0k3rm4n

  • Post Options:
  • Link
    Copy

  Posted 4 August 2017, 5:58 am EST

  Hey folks…how are you?
  
  
  
  This is my current dilemma: Is it possible to have a procedure in a AR 2.0 Report in which I’d be able to export it and send it by e-mail (using outlook express, or something like that…)?
  
  I wouldn’t need it to be a PDF file, but if I could only send it in a format recognizable somehow, it’d be great!!!
  
  
  
  I’d appreciate any help…thanks a lot!
  
  
  
  best regards,
  
  J0k3rm4n

• 

  ali-dd

  • Post Options:
  • Link
    Copy

  Posted 4 August 2017, 5:58 am EST

  You have several options to send a report via email. A very nice and easy-to-use library is vbSendMail. The one drawback of this library is that it doesn’t support encrypted smtp (SSL). If you cannot use this library because of this drawback, you can use:

  1. Collaboration Data Objects : Sending Email Using CDO and MAPI

  2. Microsoft MAPI controls 6: Sending Email With MAPI Components in Visual Basic

  3. Using the Outlook object model: How do I send an email using Outlook?

  No doubt there are other options to send email including third party controls. I’ve modified the sample from the devarticles using the MAPI controls to send a report in several attachments. I hope the resources above prove helpful if this application doesn't suit your needs

  2006/10/SendMailMapi.zip
• 

  j0k3rm4n

  • Post Options:
  • Link
    Copy

  Posted 4 August 2017, 5:58 am EST

  Thanks a lot, Ali - DD!!!
  
  
  
  Is there a procedure in which I could the same that those ones you showed me using an Outlook Express application?

• 

  ali-dd

  • Post Options:
  • Link
    Copy

  Posted 4 August 2017, 5:58 am EST

  I really don’t know if Outlook Express has an OLE automation interface for you to start a new message. The MAPI controls uses underlying message subsystem of the machine and I think if you change the sample to suit your needs, it is as if you have created a new Outlook Express message and attached the report to it.
  
  
  
  

• 

  ali-dd

  • Post Options:
  • Link
    Copy

  Posted 4 August 2017, 5:58 am EST

  Tecnova,

  Can you share the code you use to open a new Outlook Express message and add the exported reports as attachments to it?

• 

  danielgarcia0537

  • Post Options:
  • Link
    Copy

  Posted 27 August 2020, 4:16 am EST

  You can delete your POF profile quickly, we’ll tell you How to delete POF profile. Closing your POF account is simple, even if it requires some clicks.