Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved How to embedded Image in email body.

  1. How-to
0
Votes
Undo
  1. Tadeo Rodriguez
    Tadeo Rodriguez
  2. PowerBuilder
  3. Tuesday, 19 January 2021 19:53 PM UTC 
Hi,

I need to send emails from powerbuilder that contain an image embedded in message body , not as an attachment.

Is this possible?

Thank you for your attention and help.
OLE try catch error is popping up
Microsoft SQL Server Native Client 11.0 TCP Provid...
Accepted Answer
Tadeo Rodriguez
Tadeo Rodriguez Accepted Answer Pending Moderation
  1. Friday, 21 May 2021 20:31 PM UTC
  2. PowerBuilder
  3. # Permalink

Hello All,

 

I found a solution...

//first, I get the image value from a table:

Selectblob column into :blob_variable from table where id=:xyz;

//Encode using Base64 and returns the encoded data

string ls_Base64Str

string ls_msgbodypicture 

CoderObject lnv_CoderObject
lnv_CoderObject = Create CoderObject
ls_Base64Str = lnv_CoderObject.Base64Encode(blob_variable)

// set string variable 

ls_msgbodypicture = '<img src="data:image/png;base64,'+ls_Base64Str+'" alt="img" />'

//set the messsage

ls_msgbodyemail = '<p>This is a test </p>'+&

                             '<p>'+ls_msgbodypicture +'</p>'

 

// "HTML"
lOle_Outlook_Item.BodyFormat = 2
lOle_Outlook_Item.HTMLBody = ls_msgbodyemail 

lb_Return = lOle_Outlook_Item.Send()

 

I'm using the OLEObject Mail sending...

https://www.youtube.com/watch?v=uHi0z70-cao

 

Thanks everyone for your help.

 

 

 

 

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Sunday, 23 May 2021 05:50 AM UTC
Thanks for sharing!
  1. Helpful
There are no comments made yet.
Responses (4)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 19 January 2021 22:25 PM UTC
  2. PowerBuilder
  3. # 1

Hi Tadeo,

There's 3 ways of adding an image to an email (that I'm aware of).

1. have a link to the image on some file/content server

2. embed as binary values, but most email clients will reject that nowadays

3. in the moment of sending have a temporary file somewhere on disk, add the file to the html using the "cid" tag and attach this file as a "hidden" attachment. Since you say you don't want to attach any files, I won't expand on how to do that. (but it IS the method that gives us most success).

regards

Comment
There are no comments made yet.
Andrew Barnes
Andrew Barnes Accepted Answer Pending Moderation
  1. Tuesday, 19 January 2021 21:00 PM UTC
  2. PowerBuilder
  3. # 2

And if your database is SQL Server, you can use sp_send_dbmail to send an email.  Either way, for an embedded image, Chris's of sending in HTML format is the way to go.

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 19 January 2021 20:24 PM UTC
  2. PowerBuilder
  3. # 3

Hi Tadeo;

  I would suggest that you send the email in HTML format for that requirement.

FYI:

   http://www.topwizprogramming.com/freecode_emailsmtp.html

   http://www.example-code.com/powerbuilder/smtp_send_html_email_with_attachments.asp

Regards ... Chris

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.