SQL generated html email notifications for external customer orders.
$30-250 AUD
货到付款
• 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: #6415227
关于项目
授予:
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 更多
有4名威客正在参与此工作的竞标,均价$260/小时
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