need to send emails based on their transactions in oracle reports
Hi All,
Currently report is generating with all customer transactions.
our new requirement is we need to add email id in the reports and i need to send emails to customers wrt their transactions.
PDF format as an attachment.currently we are getting text format mail.
the output of the mails is
soniks Limited STATEMENT OF ACCOUNTS Report ID: R04021B
Division : soniks Division From : APR-2018 To : APR-2018 Location : Indore
As On : 04/12/2018 Page No. : 1
--------------------------------------------------------------------------------------------------------
Party's Name and Address: GUDEKOTA ENTERPRISES G0335
--------------------------------------------------------------------------------------------------------
DATE PARTICULARS DEBITS CREDITS
Rs.Ps. Rs.Ps.
--------------------------------------------------------------------------------------------------------
Opening Balance: .00 477058.36
17/04/2018 INVOICES FIV--1803107/17-APR-18 - 26MT 172390.40
19/04/2018 INVOICES FIV--1803632/19-APR-18 - 26MT 179046.40