SQL Server Database Email

Just completed a project that uses SQL Server 2008 DBMail to send complex formatted Access reports as an HTML email. Using this SQL Server feature allows us to create a central repository of all the email sent to an individual by the organization. Any user on the system can review and resend an email. These emails are legal documents that notify a member of a rules violation. The format of the HTML email is almost identical as the printed document and will include an invoice and a statement if multiple amounts are still due.

One of the advantages of this system is that the administrator only has to set the email account settings up once on the server. When a user pulls up a members record in the MS Access system all emails sent to that member are displayed.

Leave a Reply