Skip to main content

Send Mail with Attachment From Navision.

Hi all,

We have seen how to save a report into PDF and how to send mail to a customer.

Let's link these two post in one i.e. Mailing statement to a customer into PDF Format.

This article is part of the Series. Please Refer Table of Content here.

If you have the old objects set let me brief you what I will be changing - 

1) I have moved "Path to Save Report" From user setup Table/Form to SMTP Mail Setup.

2) On customer card there will be a menu button for Mails which will have all existing options and a new option for sending mail with attachment.

3) We have two Codeunit that we will be using -
a) 50000 - Save Report in PDF
b) 50001 - Send Mail

4) I am creating a new function in Codeunit 50001 which will internally call Codeunit 5000 and then will send mail to customer with the Report as attachment in PDF Format.

How it Looks Now -

1) SMTP SETUP.


2) Customer Card.


3) Codeunit Send Mail.



Let's see what we get in output.

Mail -


Attachment -



NAV Version - NAV 2009 R2 IN.

You can find all related objects on my SkyDrive Public Folder.

File Name - NAV - SEND MAIL With Attachment.rar

Also on SkyDrive you will find the new objects which will have merged Codeunit 50000  & 50001.
I will be using Same for future posts.

NAV - SEND MAIL With Attachment (Single Mail Codeunit).rar

Regards,
Saurav Dhyani

www.sauravdhyani.com

Comments

  1. Is there any option if I want my attachment display in the email body?

    ReplyDelete
    Replies
    1. @Sami,
      Not Sure in NAV 2009 but its a default feature in New version of NAV. I would suggest to upgrade as its an easy one.

      Delete
  2. you did not include the code to codeunit 50000? Saving a report as a pdf.

    ReplyDelete
    Replies
    1. Hi Chaz,
      I Rechecked the attachment and it have Codeunit 50000. (I checked in Text file).
      Please check and let me know.

      Delete
  3. Hello - whats the code for saving the file? Codeunit 50000?

    ReplyDelete
    Replies
    1. Hi Chaz,
      I Rechecked the attachment and it have Codeunit 50000. (I checked in Text file).
      Please check and let me know.

      Delete

Post a Comment

Popular posts from this blog

Dynamics 365 Business Central 2021 release wave 2 (BC19) Released.

Hi Readers, As we all were expecting Microsoft have Released Business Central 2021 Release Wave 2 Today a.k.a BC19. In this article we will see what all is announced with the General Availability.  Starting Today Customers & Partners can start using Business Central 19. #msdyn365bc #bc19

Navision Cannot generate SSPI context State ID HY000

Hi all, Sometime while trying to connect database in classic client with windows authentication or connect to Role Tailored Client we face an error message. Error - The following ODBC error occurred: Error: [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context  State ID: HY000