Skip to main content

Sending Tabular Records in an Email

  • Nov 27, 2020 4:43 PM UTC
  • 2 replies
  • 226 views

Forum|alt.badge.img+7

I need to send a quick report that I made via email to multiple users. Any Ideas on how to do that ? Can I send it as an excel file ?

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+11
  • Hero (Customer)
  • Nov 27, 2020 5:17 PM UTC

To send the output of a SQL based quick report as an excel attachment to an email, i would suggest the following…

  1. In IFs Enterprise Explorer, open the “Explore Quick Reports” screen from the navigator
  2. Find the report in question, RMB, Export to excel…
  3. (If the quick report has filter parameters, enter the applicable data)
  4. You can then save the excel file somewhere (e.g. your desktop) then attach it to an email and send it.

Hope that helps!


Forum|alt.badge.img+7
  • Author
  • Sidekick
  • Nov 30, 2020 6:17 AM UTC

To send the output of a SQL based quick report as an excel attachment to an email, i would suggest the following…

  1. In IFs Enterprise Explorer, open the “Explore Quick Reports” screen from the navigator
  2. Find the report in question, RMB, Export to excel…
  3. (If the quick report has filter parameters, enter the applicable data)
  4. You can then save the excel file somewhere (e.g. your desktop) then attach it to an email and send it.

Hope that helps!

I need to do this with the help of a custom event I can do it manually but this is a regular activity so I need to automate it with a custom event any ideas on how we can send excel attached in an email and send it to multiple users daily?