Need to send mail from apex in html format

raghunadhan

Hi All,

Need to sedn mail as below format from apex. Can you help on this how to send in below format

* This is an automated email. Please do not respond to the sender address *

* In case of questions, please reach out to [email protected] *

Dear Tr, Akshay,

Welcome to CCM!

You have been authorized to access Cost Controlling Module.

Please request access for CCM reports from Analytics Portal after 24 hours.

Below level of access has been provisioned :

Cost Category Group(s) : ALL

Segment(s)                   : TOTAL COMPANY

Reporting Unit(s)          : Total Company/G001AR(Total Company)

Cost Division(s)             : ALL

Main Channel(s)            : ALL

Best Regards,

CCM Team

Paavo

@raghunadhan check this new feature:

https://docs.oracle.com/en/database/oracle/application-express/21.2/htmdb/managing-email-templates.html

it works pretty well and its based on shared components.

rgrds Paavo

raghunadhan

There will be be more names dynamically should be displayed. can yo help me on this.Like names below

You have successfully authorized below users to CCM :

Tr, Akshay

Raghunadhan

Below level of access has been provisioned :

Cost Category Group(s) : ALL

Segment(s)                   : TOTAL COMPANY

Reporting Unit(s)          : Total Company/G001AR(Total Company)

Cost Division(s)             : ALL

Main Channel(s)            : ALL

raghunadhan

Can you helle me creating a template in apex.oralcle.cim

worksspace:raghu_personal

username :[email protected]

password:195689_?Logu

raghunadhan

App 25309 or any authorization app

Paavo

@raghunadhan I think its faster, if you watch this video and try first yourself

https://www.youtube.com/watch?v=1YlKseTVOoo

Its good to see various errors while doing this, it will deepen your skills.

e.g. I learned the hard way that I need to use apex.json_stringify

rgrds Paavo

raghunadhan

Ok.the data shoule be taken from file browse.

raghunadhan

How the data should be taken from file browse(excel file) and send mail.

raghunadhan

How to get the data excel file while uplaoding data and send mail.

raghunadhan

I need to do this in oracle apex or plsql. Iam loading the excel file from the excel file and need to get the usernames and other datas and send mail