Dynamics Community Forum Thread Details

Can we attach excel sheet send through mail using processing report in business central.

Hi Guys,

Can we attach excel sheet send through mail using processing report in business central?

Is any way to do this.

Categories:

Dynamics 365 Business Central

Dear Nilam bhor,

Please call the function in the button or code unit. This code is working for us. Please give a try and let us know

Please use the given below

 local procedure Email()
    var
        Email: Codeunit Email;
        EmailMessage: Codeunit "Email Message";
        TempBlob: Codeunit "Temp Blob";
        ReportParameters: Text;
        EmailBody: Text[100];
        Subject: Text[100];
        Recipient: Text[1000];
        InStr: Instream;
        OutStr: OutStream;
        ReportValves: Text[100];
    begin
        EmailBody := 'Dear Team, ';
        EmailBody += 'Please find attached the reports as of ';
        Subject := 'Sample Subject';
        ReportValves := 'Sample Report';
        ReportValves += '.xlsx';
        Recipient := 'Test@gmail.com';
        EmailMessage.Create(Recipient, Subject, EmailBody);
        TempBlob.CreateOutStream(OutStr);
        TempBlob.CreateInStream(InStr);
        Report.SaveAs(Report::"Standard Sales - Invoice", ReportParameters, ReportFormat::Excel, OutStr);
        EmailMessage.AddAttachment(ReportValves, 'Excel', InStr);
        Email.Send(EmailMessage, Enum::"Email Scenario"::Default);
    end;
 
 
Thanks
Janarthanan v

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS