SQL generated html email notifications for external customer orders.

Completado Publicado Sep 5, 2014 Pagado a la entrega
Completado Pagado a la entrega

• 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.

Manejo de email Servidor de Microsoft SQL SQL

Nº del proyecto: #6415227

Sobre el proyecto

4 propuestas Proyecto remoto Activo Sep 5, 2014

Adjudicado a:

feninsoftech

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 Más

$277 AUD en 17 días
(27 comentarios)
5.9

4 freelancers están ofertando un promedio de $260 por este trabajo

yugolancer

For each program, means how many programs in total? oRespond button will update DB info reading addresses from what/where? Thank you

$236 AUD en 3 días
(17 comentarios)
6.2
rinsadsl

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

$263 AUD en 7 días
(29 comentarios)
5.3