Save file in Excel and Email on the fly - NAV 2016

rnjbng
rnjbng Member Posts: 82
in NAV Three Tier
I have a very simple processing only report that goes through the Sales Header table for Quotes only and adds User Id, Quote No. and Amount in excel per User ID. At the end of my loop I am calling CreateExcelBook. I just want to save this spreadsheet and send it out as a attachment to the user ID. Emailing is not a issue but my issue is how to save it as a excel file on the fly while the report is running.
I have seen post in this forum for old version of NAV but unfortunately those Excel buffer functions do not exist in NAV 2016 or have changed in NAV 2016.

Any help is highly appreciated.

Thanks
RJ.

Best Answer

Answers

  • rnjbng
    rnjbng Member Posts: 82
    Thank you logger for your suggestion, I created my own function and works perfect. Thanks for your valuable suggestion.
  • melsimmons68
    melsimmons68 Member Posts: 8
    What is the code you used to save the excel file?

Categories