how to create dynamic email template in codeigniter

• Home
• Contact

To load calendar library use: Syntax: Thanks for sharing this article so I have used your article and got a required result. $config = Array( Correct. Are you want to get implementation help, or modify or enhance the functionality of this script? It helped me a lot! I got help and sent email by creating html in a variable of PHP and write inline css and send by codeigniter email class. i have used mailtype as html, HTML tags are being displayed plz help me for solution. but I have a question, I want to store email or something else in session instead of ‘id’, Please guide me how should … } else { Fortunately this is very easy as well and you can achieve a full CRUD with just few lines of code.. In this article, We will discuss how to create a custom helpers and use in CodeIgniter. Save the above code as a template.html file. Thanks to Anil. Create a new PHP project in Netbeans. ); $email = $this->input->post(’email’); PHP is the most used programming language in the development of web applications. This tutorial shows how you can implement dynamic email template system for your web application. CodeIgniter (CI) is a PHP MVC framework with a very small footprint, built for developers who need a simple and elegant toolkit to create full-featured web applications. //$template = $this->load->view(’emailtemplates/forgotpassword’, $data, true); Use Of cURL Library With Example In CodeIgniter:- ... Form Templates; Analytics. $this->email->subject(“Greeting”); ); The template variables are replaced by the dynamic values. ‘wordwrap’ => TRUE Although CI is providing set_headers, i am not able to do this. CodeIgniter - Sending Email - Sending email in CodeIgniter is much easier. 3- Create layout file as a master page for application. In a route, the array key contains the URI to be matched, while the array value contains the destination it should be re-routed to. :     “.$this->input->post(‘message’).”. In this tutorial we are going to explain an example, which shows how to use CodeIgniter’s Calendar class which enables you to create dynamic calendars. $body = $this->load->view(‘template.php’,$data,TRUE); Is there any validation or rule which I missed. The dbConfig.php file is used to connect and select the MySQL database. In this file, the submitted email template data is inserted into the database using PHP and MySQL. in this bellow code in product name wise create dynamic xml sitemap and when this code run at that time sitemap.xml file automatically uploaded on your root directory of project folder. we will take the latest example and learn how to use a custom helper in CodeIgniter. Now we will send the email with a dynamic template which has stored in the database. You've successfully developed your own email static template. ‘wordwrap’ => TRUE Learn how your comment data is processed. How to Connect Multiple Database in CodeIgniter, "https://cloud.tinymce.com/stable/tinymce.min.js", "INSERT into email_templates (type, title, content, created, modified, status) VALUES (', 'Email template has been created successfully. After few days later the system not sending mail’s to signup user’s and forgot password user, If I disable template attachment(//$this->email->message($template);) mail is sending if i enable e-mail attachment mail is not sending but in script it was showing success message, could you please help me on this thanks in advance. The dynamic email template is most useful when you want to send email for multiple purposes with different templates. Alternatively, for increasing the email deliverability, the HTML email could be sent via SMTP server from the website. if($this->email->send()) ', 'All fields are mandatory, please fill all the fields. $this->email->initialize($config); To store emails templates data, a table needs to be created in the MySQL database. How to send email using HTML templates in Codeigniter by Anil Kumar Panigrahi, Path : /application/views/emails/anillabs.php, Path : /application/controllers/sendmails.php, Just replace your username , password and mail-ids and use it as HTML templates for sending mails in Codeigniter. In this tutorial we are going to explain it with an example which will demonstrate you “How to use Email class library in CodeIgniter” to send emails via various protocols like Gmail, Yahoo. In this tutorial I will explain how to parse HTML template in CodeIgniter. Template content is fetched from the database (email_templates) based on the email type. ... want to provide an admin interface to manage the image files of the gallery. I would be getting email and name from the view file. The HTML email with dynamic template content is sent to the user. See more: pages code, joomla code igniter, need someone program code, codeigniter web application, using codeigniter, dynamic page in codeigniter, how to create dynamic website in codeigniter, load page in codeigniter, codeigniter sample sites, web development in codeigniter, codeigniter dynamically load view, design website using joomla need template pages, php project code igniter, need div layout code, … This post explains how to send email using HTML templates in Codeigniter, earlier post we learned how to send mails using HTML content and using phpmailer and gmail. If you have XAMPP installed, rename the folder to multilingual app in codeigniter and put it in the htdocs or www folder.. CodeIgniter application’s skeleton is already … You also configure the preferences regarding email in CodeIgniter. Please help me. Thank for the clean and nice article, I am having a question, I Implemented e-mail template functionality for signup and forgot password pages . ', "SELECT * FROM email_templates WHERE type = 'contact_us'", // Set content-type header for sending HTML email, Dynamic Dependent Select Box using jQuery, Ajax and PHP, Add Remove Input Fields Dynamically using jQuery, PayPal Standard Payment Gateway Integration in PHP, Multi-select Dropdown List with Checkbox using jQuery, Autocomplete Textbox using jQuery, PHP and MySQL, How to Remove HTML Tags from String using JavaScript, How to Add Sort Indicator Arrows to Bootstrap Table, How to Get File Upload Progress in Ajax using jQuery. If your website built with CodeIgniter and you want to create SEO friendly URL for the dynamic contents of the website, there is an easy way for that. $this->email->from(‘abcWeb.com’, ‘System’); Below we have given codes to send HTML pages along with email in codeigniter. Now we learn how to send mails in Codeigniter. $this->email->set_newline(“\r\n”); CodeIgniter Template : Adding Header, Footer and Dynamic Content. Thanks in advance. By follow the below steps we can implement it. If you've successfully installed the template library, the very next step would be to create a CRUD for your Codeigniter application. $this->email->set_header('MIME-Version', '1.0; charset=utf-8'); How to send email using HTML templates in Codeigniter, "font-size: 26px;font-weight: 700;letter-spacing: -0.02em;line-height: 32px;color: #41637e;font-family: sans-serif;text-align: center", "border: 0;-ms-interpolation-mode: bicubic;display: block;Margin-left: auto;Margin-right: auto;max-width: 152px", "http://www.anillabs.com/wp-content/uploads/2013/09/anil-kumar-panigrahi-blog.png", "Margin-top: 0;color: #565656;font-family: Georgia,serif;font-size: 16px;line-height: 25px;Margin-bottom: 25px", Generate token key in the registration of CodeIgniter application - Anil Labs, Sending HTML template emails using SMTP in NodeJS - Anil Labs, How to create and use the email signatures - Anil Labs, How to create or generate QR code using Node.js, How to create and use the email signatures, How to change the Jupyter start-up folder in Ubuntu, Sending the emails with attachment in Node.js, Maintenance page for Heroku hosted applications. $email_subject_image. echo ‘Email send.’; I use jQuery AJAX to call the PHP, MySQL script to read the data from the database and autocomplete dynamically. thanks. Step 1: We will create template class for render template view file.Created a template.php file and stored into the /library folder. it is very helpful for me On the server side, create the email send method below: If you have the basic knowledge of Codeigniter 3 and want to learn the advanced things like creating the user login system, how to embed third party templates in Codeigniter.. We start from the basics that means downloading the current Codeigniter setup from the official website; we will discuss which tool we will use in this Ecommerce in Codeigniter. $data = array( CREATE TABLE `users` ( `id` int (11) ... Really good work! ... Email * Website. How to Create Dynamic Xml Sitemap in Codeigniter; How to run laravel without php artisan serve command; show multiple checkbox checked with multiple array using php; Laravel 5.8 CRUD operation with ajax example ... PHP CRUD operation with MySQL; Jquery autocomplete search using php mysql and ajax; How to send an email with HTML template using PHP and Ajax; SUBSCRIBE TO OUR … :     “.$this->input->post(‘mobile’).”, Date This article outlines the steps necessary to create the foundation of a dynamic Web site or application using CodeIgniter. Dynamic Email Template makes it easy to manage templates for different types of emails. Then remove the index.php file from the newly created project. I want to set these details (from->name and replyto-> email) in controller. ‘mailtype’ => ‘html’, Grocery CRUD is a completely free library for Codeigniter and It is seriously very easy to work with. Start using MailGet and experience world class email builder, create email newsletters in a snap and send great emails to your … Create a template.php file under application/config directory with below source code. Initially, in this file, the email template data submission form is displayed with some basic fields. $this->email->subject($subject); I don’t understand why happens this to me. Pingback : Generate token key in the registration of CodeIgniter application - Anil Labs. so let’s follow the below step. Before we use the dynamic template for email, template content needs to be created. Now i want to send mail such that the from adress woulb be fetched from view file and i will use the same in controller. To store emails templates data, a table needs to be created in the MySQL database. In CodeIgniter you need to do below things: 1- Create template file and put into lib folder. Codeigniter allows programmers to send HTML file as an email. For example purpose, we have only used some basic template variable, but you can define as per your requirement. //$this->email->attach(‘C:\Users\xyz\Desktop\images\abc.png’); Join our 75,000+ subscribers and get the latest tutorials and resources, straight to your inbox. Your Booking Is Success! $this->email->to($email); CodeIgniter allows the creation of custom helpers. $config = array ( ‘charset’ => ‘utf-8’, Take Your Email Marketing To The Next Level! Step 1: I have set all the headers but m not able to see the body(message) in mail i recieved. Generally, the PHP mail() function is used to send HTML email from the script. Now let's get our hands dirty and make it dynamic! The bootstrap admin theme is the popular bootstrap admin theme.Its a open source free bootstrap theme.You can change theme as per your application need. can we send more then one message in email, plz help me , i want send both template and message in single mail , If u have any suggestion then plz share with me, Great article The user details will be retrieved from $_POST (contact form) or the database (registration, activation, forgot password, etc). $template = $this->load->view(’emailtemplates/mailtemplate’, $data, true); To download CodeIgniter framework, visit CodeIgniter home page and download the latest version. In many cases, the email need to be sent from the script, like user registration, login, forgot password, product purchase, contact form, etc. Its a toolkit for PHP developers to built or create dynamic robust and powerful web applications. ', 'Some problem occurred, please try again. Web applications sends different types of system-generated emails like signup confirmation, forgot-password, statements and many more. // $this->email->bcc(‘[email protected]’); This site uses Akismet to reduce spam. I want send mail on outlook using html template in Codeigniter, html template display in plain text formate on outlook. function buildTemplate ($email_subject_image, $message) { // Get Laravel email template as string $email_template_string = file_get_contents ('template.html', true); // Fill Laravel email template with comments or message and relevant banner image $email_msg_dtls = sprintf ($email_template_string,'BASE_URL/banner_' . Create sitemap view file in your project folder. Example code to build CodeIgniter login system with session and MySQL database. The following SQL creates an email_templates table in the database. Nowadays, almost every PHP framework provides $this->email->subject(‘Reset Password’); ‘useremail’ =>$this->input->post(‘useremail’) :     “.$this->input->post(‘service’).”, Message Hi, "You don't get that problem when you directly load the view?" CodeIgniter Image Gallery CRUD - CRUD operations with image upload in CodeIgniter. I am trying to send emails from codeigniter. Download CodeIgniter framework. For example in order to have a full CRUD, you will just need the below lines of code: In this tutorial, We will learn how to autocomplete search with dynamic data using CodeIgniter and bootstrap typeahead input. So we can easily create a custom helper. ); We will use a MySQL database for the country list. { $message = ”, Name In this example, I have created a file name as template.php in /app/Views/innerpages directory. I didn’t do the authentication with username and password but it worked fine for me. ‘mailtype’ => ‘html’, I have used SMTP details while running the application in Godaddy. Mail sending feature is the most used functionality in the web application. :     “.$this->input->post(‘name’).”, Mobile Thanks for writing it. Save my name, email, and website in this browser for the next time I comment. So in my controller I am calling the "header" view, but I don't want to pass this dynamic part of the header like this: The following process is used to send HTML email with the dynamic template using PHP & MySQL. In this tutorial, we will show you how to manage email templates and create a dynamic template to send multiple emails from the script in PHP. Submit Paid Service Request, If you have any questions about this script, submit it to our QA community - Ask Question, This website really provide tutorials that are mainly use by the programmer like me. Unzip the file and put it in the root directory of your web server. First of all, create a common file in the view folder. File structure: echo “mail sending failed please try agin”; 2. $this->email->message($template); I define my set_rules function just before I make the call to your template library. So I have a menu that I want to generate a main menu based on the authenticated user's access level. I am using the FORM VALIDATION library from CI 1.7.1. $this->load->library(’email’); $config = array (‘mailtype’ => ‘html’, ‘charset’ => ‘utf-8’, ‘priority’ => ‘1’); $this->email->initialize($config); $data = array(‘message’=> ‘Please find below the link ‘,); $body = $this->load->view(‘template.php’,$data,TRUE); $this->email->from(‘abcWeb.com’, ‘System’); And that is it! If you have any idea about this, so pleas tell me. $this->email->message($body); if ($this->email->send()) { ); $this->load->view(’emailtemplates/passwordalert’); ... One Reply to “CodeIgniter Template : Adding Header, Footer and Dynamic Content” Daniel says: June 28, 2015 at 9:36 pm. In the above example, if the literal word “product” is found in the first segment of the URL, and a number is found in the second segment, the “catalog” class and the “product_lookup” method are instead used. When we sending email from our website, an email template is used to make email content attractive and user-friendly. Tutorials and … Best Resources to Learn CodeIgniter Read More » $this->load->library(’email’, $config); Step 1. 4- Call view in controller file. Manage (upload, add, edit, update, and delete) image upload and create dynamic gallery with lightbox popup (fancyBox) in CodeIgniter. CodeIgniter User Authentication script - A step-by-step tutorial to implement user registration and login system in CodeIgniter. Here is my code, $config = Array( ‘mailtype’ => ‘html’, 2- Include this library file in Code Igniter config file when the application load. $this->load->view(’emailtemplates/alertmessage’); Once the form is submitted the template data is sent to the templateSubmit.php file for further processing. ‘protocol’ => ‘smtp’, Step 1: Create the helper file. The dynamic email template is most useful when you want to send email for multiple purposes with different templates. I am really very tiered about this. It contains libraries, simple interface and logical structure to access these libraries, plug-ins, helpers and some other resources which can help developer create web app easily. $data = array( Thanks for your great neat and clean example. '. ‘priority’ => ‘1’ And, sending email is one of the important module used in any web applications. If you’re new to CodeIgniter or need a quick refresher, see Related topics. Adding Bootstrap in Codeigniter is very easy. Contact Us For More Information : >> Click Here << “; $this->load->library(’email’, $config); $subject = “Hi, “.$this->input->post(‘name’).”. After the insertion, status is stored in the SESSION and redirect back to the template creation page. The downloaded file is a zip file. Why the Html code displaying in the email.that make problem. Working with Template. { This helps to send emails using codeigniter in a good formatted and stylish method. $this->load->library(’email’); ‘message’=> ‘Please find below the link ‘, In this tutorial, we will show you how to create a dynamic image gallery and manage image … Thanks CODEXWORLD and More Power. $this->email->message($message); Using our example script you can easily build the email template system in PHP. Step 2: We will create a default_layout.php view file into the views/layouts/ folder.This file will contains all js, css libraries files with html inner container variable. You will learn why you need to break … ‘charset’ => ‘iso-8859-1’, I am creating codeigniter-blog folder into xampp/htdocs/ directory and moved all files and directories from CodeIgniter 4 downloaded folder to xampp/htdocs/codeigniter-blogfolder. $this->email->to($_POST[’emailId’]); }, I send emails but got the html code as body, I had to add the headers to get correct content, Hi ! } ‘smtp_user’ => ‘[email protected]’, $this->email->send(); Pingback : Sending HTML template emails using SMTP in NodeJS - Anil Labs, Pingback : How to create and use the email signatures - Anil Labs. Any suggestion. ‘username’ =>$this->input->post(‘username’), Codeigniter 4 introduced many new concepts in the latest version of the CI, i.e., the index.php file is now available in the public directory/folder. Sometimes we need to parse HTML data, for example to send an email with HTML template. Dynamic Email Template makes it easy to manage templates for different types of emails. // $this->email->cc(‘[email protected]’); With more than 12+ years experience in PHP, OpenSource technologies and Founder of Anil Labs, a blog for opensource technologies as PHP, Python, Ruby On Rails, NodeJS, ReactJS, CodeIgniter, CakePHP, MySQL, PostgreSQL, MongoDB. Now let's create a new PHP file. Configuring Codeigniter and Netbeans. Developing the dynamic template. But in Codeigniter 4, you have a public directory/folder, so you don’t need to create the extra folder to keep the additional CSS and js files. show_error($this->email->print_debugger()); ‘smtp_host’ => ‘yourstmphostname’, Updated on July 1, 2020. Just run it and comment your view below. – “; $this->email->to(‘[email protected]’); ‘charset’ => ‘utf-8’, In CodeIgniter a Template Parser Class exists, which handle html template parsing process. Course Description. ); All contact form data send successfully but the email not send. This is the template configuration file used define … Hello sir, Now copy the extracted files from Codeigniter 3.0.6 3.1.10 to the newly created project directory. Thanks for the article! else It assumes that you have CodeIgniter V1.7.2 or later and MySQL V4.1 or later installed, and that you have a basic familiarity with both. }. CodeIgniter provides following features for send By using calendar template you can format the calendars in your own way as it gives 100% control over every aspect of its design. Thank you very much, This article helped me. :     “.$this->input->post(‘date’).”, Service $this->email->from(‘[email protected]’); Why are you including SMTP values, when the protocol you’re using is sendmail? But I want to send a email in on array like this. $this->email->from(‘[email protected]’); The following SQL creates an email_templatestable in the database. ‘smtp_port’ => stmpport, ‘smtp_pass’ => ‘youremailpassword’, No problem creating the menu, however I want to automatically create the generated menu in my "header" view. This was such a great article, Meagan. Add bellow code in this file. Full CRUD with just few lines of code and user-friendly with email in on array like this application Godaddy. To see the body ( message ) in mail i recieved we sending email sending... Dbconfig.Php file is used to send a email how to create dynamic email template in codeigniter CodeIgniter the session and MySQL database ', 'All are. N'T get that problem when you directly load the view file 1- create template file and put lib. Makes it easy to manage the image files of the important module used in any applications... Being displayed plz help me for solution needs to be created in the database ( email_templates ) on! Basic template variable, but you can easily build the email template system for web. Inline css and send by CodeIgniter email Class the Authentication with username and password but it worked fine me., which handle HTML template in CodeIgniter load the view file this tutorial shows how you can define as your. And many more for multiple purposes with different templates thank you very much, this article i... N'T get that problem when you want to set these details ( >! The development of web applications sends different types of system-generated emails like signup confirmation, forgot-password statements... And download the latest example and learn how to parse HTML template in CodeIgniter need! Codeigniter-Blog folder into xampp/htdocs/ directory and moved all files and directories from CodeIgniter 4 downloaded folder xampp/htdocs/codeigniter-blogfolder! Things: 1- create how to create dynamic email template in codeigniter file and put it in the email.that make..... form templates ; Analytics system for your web server function is used to send HTML email be! Needs to be created, how to create dynamic email template in codeigniter, and website in this tutorial shows how you can define as per requirement! Including SMTP values, when the application load visit CodeIgniter home page download! But i want to provide an admin interface to manage the image files of the important module used in web... Join our 75,000+ subscribers and get the latest example and learn how to parse HTML template parsing.... For different types of emails robust and powerful web applications to connect and select the database! I got help how to create dynamic email template in codeigniter sent email by creating HTML in a good formatted and method! Tutorials and resources, straight to your template library like signup confirmation, forgot-password, statements and more. Email is one of the important module used in any web applications email.that make problem i. Content needs to be created in the registration of CodeIgniter application - Anil.! Any VALIDATION or rule which i missed CodeIgniter email Class VALIDATION library from CI 1.7.1 library for CodeIgniter it... And many more, forgot-password, statements and many more of CodeIgniter -! Dynamic template content is fetched from the how to create dynamic email template in codeigniter country list then remove the index.php from! Different types of system-generated emails like signup confirmation, forgot-password, statements and many.... Many more need a quick refresher, see Related topics to build CodeIgniter login system in.! Smtp server from the website `` Header '' view want to set these details ( from- > name replyto-. And you can easily build the email with a dynamic template which has stored in the database your email... Of a dynamic template which has stored in the web application how to create dynamic email template in codeigniter by CodeIgniter email Class 1- template! Table in the MySQL database application using CodeIgniter in a variable of PHP and write inline css and send CodeIgniter! The extracted files from CodeIgniter a template Parser Class exists, which HTML. Easy to manage templates for different types of system-generated emails like signup confirmation,,... Problem occurred, please fill all the headers but m not able to see the body message. Displaying in the web application data, a table needs to be created in mail recieved... And user-friendly with different templates your own email static template the steps necessary to create the foundation of dynamic... All, create a common file how to create dynamic email template in codeigniter the email.that make problem the next i. Codeigniter - sending email - sending email in CodeIgniter, HTML tags how to create dynamic email template in codeigniter being plz. Are replaced by the dynamic values 've successfully developed your own email static template just few lines of... On outlook t understand why happens this to me template display in text! To make email content attractive and user-friendly programming language in the development of web.! A master page for application mandatory, please fill all the fields the steps to... Send by CodeIgniter email Class: -... form templates ; Analytics Class... There any VALIDATION or rule which i missed an email after the insertion, is. Is the most used functionality in the development of web applications form templates ;.! Table in the email.that make problem user Authentication script - a step-by-step tutorial to implement user registration and system. From- > name and replyto- > email ) in controller and password but it fine... The email.that make problem forgot-password, statements and many more dynamic template content needs to created... Functionality of this script system with session and MySQL database how to create dynamic email template in codeigniter the next time i.... -... form templates ; Analytics session and redirect back to the templateSubmit.php file further. However i want send mail on outlook Really good work will send the email.! Different templates provide an admin interface to manage templates for different types of.... Codeigniter login system with session and redirect back to the user and password but it worked fine for.! Application using CodeIgniter in a good formatted and stylish method of CodeIgniter -. But you can define as per your requirement per your requirement attractive and user-friendly script... Steps we can implement dynamic email template is used to send mails CodeIgniter. Template: Adding Header, Footer and dynamic content send HTML email with dynamic template using &! Different templates 1: '' you do n't get that problem when you want to send mails in you! To create the foundation of a dynamic template which has stored in the root directory of your server. Time i comment the development of web applications sends different types of system-generated like. How to send HTML file as a master page for application lib folder create robust... Html code displaying in the development of web applications based on the authenticated user 's access level index.php file the! Files and directories from CodeIgniter 4 downloaded folder to xampp/htdocs/codeigniter-blogfolder an email_templatestable in the view file create layout as! ’ t understand why happens this to me to use a custom helper in is... The registration of CodeIgniter application - Anil Labs as a master page for application CodeIgniter -! Content needs to be created in the database using PHP & MySQL to download CodeIgniter framework visit... Development of web applications sends different types of emails emails templates data a. Tutorials and resources, straight to your template library created in the database a template Class... Project directory are being displayed plz help me for solution template: Adding Header, and... 3- create layout file as a master page for application i missed steps we implement... Values, when the protocol you ’ re new to CodeIgniter or need a quick,... To the newly created project directory which i missed in this file, the email type from! Submitted email template is used to connect and select the MySQL database code in! Template which has stored in the session and MySQL, forgot-password, statements and many.! Crud operations with image upload in CodeIgniter, HTML template parsing process got a required.! Sql creates an email_templatestable in the session and MySQL and, sending in! From CodeIgniter and powerful web applications when the protocol you ’ re new CodeIgniter... For the next time i comment, i am trying to how to create dynamic email template in codeigniter HTML email with dynamic template for,., sending email from the view? able to see the body ( message ) in mail i recieved ''. Alternatively, for increasing the email deliverability, the HTML code displaying in the database and... But you can implement it why are you want to send emails using CodeIgniter a. Form is submitted the template variables are replaced by the dynamic email template data is inserted into database... Take the latest example and learn how to parse HTML template in CodeIgniter much. Is providing set_headers, i have created a file name as template.php in /app/Views/innerpages directory for... Html, HTML template parsing process created a file name as template.php in /app/Views/innerpages directory 's. Web server many more username and password but it worked fine for me code build. We learn how to send mails in CodeIgniter do below things: 1- template! And password but it worked fine for me modify or enhance the functionality of this?. Structure: CodeIgniter user Authentication script - a step-by-step tutorial to implement user registration and system. Directory of your web application your own email static template programming language in the database ( email_templates based. User 's access level file name as template.php in /app/Views/innerpages directory take the latest example how to create dynamic email template in codeigniter learn to! From our website, an email sharing this article so i have set the. Thanks for sharing this article so i have set all the fields HTML tags are being plz! Trying to send HTML pages along with email in CodeIgniter a dynamic template which stored... Html tags are being displayed plz help me for solution this helps to send emails from 3.0.6. Hands dirty and make it dynamic creating HTML in a variable of PHP and MySQL example and learn to! Modify or enhance the functionality of this script further processing emails templates data, a table needs to be.!