Simple webspage page to send HTML formatted email using Database lookup
- or -
Post a project like this2731
£23(approx. $29)
- Posted:
- Proposals: 5
- Remote
- #1329802
- Awarded
Description
Experience Level: Entry
General information for the website: school
Description of requirements/features: The very simple system allows the user to fill out a form, it will look emails up from a table then send an HTML formatted email template.
I have already given you the template for each HTML page including the email.
Each time the message is sent it should add a record to a table as an audit.
Where I have used < it means that < is a field from the database
Note that the ‘password’ on the first form must be correct for the form to go onto the confirmation page. I.E it just match one of the passwords in the file 1 “passwords”
For the school name, the user will select the English name (which relates to a school ID number) this then has all the other details
Excel files I will provide are below with 1 row of sample data
File 1 (passwords.xlsx) – Sector Specialist Password and <
Password SectorSpecialistName SectorSpecialistEmail
Dubai145 Sofing Hassan Sofin.Hassan@moe.gov.ae
File 2 (schools.xlsx) –
School ID School Name English School Name Arabic
Principal Email Cluster Manager Email Sector Director Email
1563 Hatem Al-Ta'Ee Boys' School For Basic And Secondary Education
مدرسة حاتم الطائي للتعليم الأساسي والثانوي للبنين
yoousef@moe.ae
ahmed@moe.ae
rashed@moe.ae
Extra notes:
Description of requirements/features: The very simple system allows the user to fill out a form, it will look emails up from a table then send an HTML formatted email template.
I have already given you the template for each HTML page including the email.
Each time the message is sent it should add a record to a table as an audit.
Where I have used < it means that < is a field from the database
Note that the ‘password’ on the first form must be correct for the form to go onto the confirmation page. I.E it just match one of the passwords in the file 1 “passwords”
For the school name, the user will select the English name (which relates to a school ID number) this then has all the other details
Excel files I will provide are below with 1 row of sample data
File 1 (passwords.xlsx) – Sector Specialist Password and <
Password SectorSpecialistName SectorSpecialistEmail
Dubai145 Sofing Hassan Sofin.Hassan@moe.gov.ae
File 2 (schools.xlsx) –
School ID School Name English School Name Arabic
Principal Email Cluster Manager Email Sector Director Email
1563 Hatem Al-Ta'Ee Boys' School For Basic And Secondary Education
مدرسة حاتم الطائي للتعليم الأساسي والثانوي للبنين
yoousef@moe.ae
ahmed@moe.ae
rashed@moe.ae
Extra notes:
Lewis H.
100% (136)Projects Completed
107
Freelancers worked with
94
Projects awarded
69%
Last project
1 Sep 2023
United Arab Emirates
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello Lewis, Is your budget flexible?
196497
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies