Send Emails via Sp send db mail

Question

Hello Everyone - I currently send emails to customers via SQL Procedure
EXEC msdb.dbo.sp_send_dbmail
@Anton _name = @Monique gmx _Profile_Name,
@recipients = @RecipientsList,
--@blind_copy_recipients = @ToddB ,
@Tomas Podoba = @MessageBody,
@subject = @MailSubject,
@Tomas Podoba _Format = 'HTML' ,
@importance ='HIGH',
@from_address = @From,
@Gaydamak _attachments = @Gaydamak _attachment,
@mailitem_id = @mailId OUT;

It's a simple email saying that 'Please log in to portal for viewing the documentation'.
Now the questions can we insert an body of the email into a Image and a link to redirect to portal ?
Sample below :

Accepted Answer

Hi @kkran ,

As agreed with other experts, your issue is more likely a HTML question.

You could have a try with below:

set @MessageBody='  
  
  
  
  
  
  
  
  
'

Or you could post this question on related HTML forum. Thanks.

Best regards
Melissa

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer

That is really an HTML question, not a SQL Server question. You need to format your @MessageBody in proper HTML format for the picture.

Answer

Hi @kkran ,

Check it out my answer on the previous forum here: html-code-inside-sql

Answer

If you want to insert the message into an image, you will have to work hard. SQL Server is not the venue for manipulating images.

But you could include an image in the mail by adding an that links to an image which is available at some URL.

As Tom says, this is more an HTML question than an SQL Server question. Or an imaging question, if you want to insert text into images.

Answer

You can also embed image in the email very simple. I have a post about it. All you need is to convert the image to base 64 (another post I have bring a function for this) and then you can imbed the code directly to the image tag in the HTML like this

For example, I send personalize email to user using their images from the database. Each user get email with different image. The image directly read from the database and converted to BASE 64 code

Most of the design work of the email is as you said HTML/CSS but this part is related to the DBA since the convert needed to be done in the database query level

Share via

Send Emails via Sp send db mail

8 additional answers

Your answer