Hi - i would like to schedule an aged report or any other report as an excel attachment to an email. Email person may or may not be an end user of business central. Currently having difficult performing this. I'm only able to send pdf's.
Hi - i would like to schedule an aged report or any other report as an excel attachment to an email. Email person may or may not be an end user of business central. Currently having difficult performing this. I'm only able to send pdf's.
Modification or an appsource app is the best approach here.
Mod wise you would need to either create a specific function for dealing with it or intercept an event which handles the format. Report selection table uses SaveReportAsPDF which has an event OnBeforeSaveReportAsPDF. There is a parameter in the main function for filepath which contains the text pdf which you could change to xlxs.
André Arnaud de Cal...
292,516
Super User 2025 Season 1
Martin Dráb
231,409
Most Valuable Professional
nmaenpaa
101,156