SQL generated html email notifications for external customer orders.
$30-250 AUD
Thanh toán khi bàn giao
• Create a separate Database with individual Tables for each program, with SQL jobs running every *mins to recreate Tables
• Email Program/script is linked to Data in Tables
• Email Program/script runs every *mins and gathers recent data from tables, formats into HTML and sends email.
o Respond button is configured to update DB information re email addresses
o Separate Mailbox configured for this response (internally handled)
o CST to maintain mailbox (internally handled)
o Email format and wording customisable by internal IT once complete
We have the view's created, could be optimised and also have draft email wording.
ID dự án: #6415227
Về dự án
Được trao cho:
Hi, This can be achieved by designing a SQL Server Stored Procedure. Procedure will be configured as SQL Job. Email will be send using xp_senddbmail. I have 8.5 years experience in SQL Server 2005|2008|2008R2|201 Thêm
4 freelancer chào giá trung bình$260 cho công việc này
For each program, means how many programs in total? oRespond button will update DB info reading addresses from what/where? Thank you
Hi Good Day I can handle your project. Please have a look at my past projects. Done pretty well with PHP and MySQL. I need a couple of points clarified from you. Looking forward to hear from you. Thanks Rinsad