Hire sql developer
€8-30 EUR
Paid on delivery
We need a query which will send email's from our server sql2008 .
The email should be in HTML format, send email's to different receipients with data from a view in our Database.
We have the query which contains data like:
email1@[url removed, login to view]
Invoice number | Amount
A123 | 500 Euro
A124 | 120 Euro
email2@[url removed, login to view]
Invoice number | Amount
A132 | 300 Euro
A136 | 220 Euro
Our clients should only receive their information, so our client with email address should receive only the table with A123 and A124 invoice.
It should be someting like the attached picture.
We already have a profile in our database to send emails, but we don't know how to build this query.
We tried to do it using the msdb.dbo.sp_send_dbmail but with no success until now.
Project ID: #15539892
About the project
4 freelancers are bidding on average €48 for this job
Dear Sir, Thank you for posting this interesting project. It seems your server does not have mail server setup or has config issue. I had used sp_send_dbmail few years back for one of the project. Stay tuned, I'm st More