Home » SQL & PL/SQL » SQL & PL/SQL » send html emails with images? (apex / pl sql)
send html emails with images? [message #333856] Mon, 14 July 2008 11:00 Go to next message
Messages: 5
Registered: July 2008
Location: Suffolk, UK
Junior Member


I've successfully got my pl/sql procedure to send an email, in HTML format, taking a file in to provide its "template" look and feel.

however, I can't get the images to appear in the email, as far as the template goes, the image is referenced correctly, being..

<img src="someimage.bmp">

Yet the image is never included in the email (white box with red X, I've allowed images but still nothing)

I can post the code, but at this point I can't really see how it will help. I'm assuming there is some setting to enable images?

The image and template are located in the same directory, also defined as a "Directory"

Look forward to hearing some advice

Re: send html emails with images? [message #333857 is a reply to message #333856] Mon, 14 July 2008 11:03 Go to previous messageGo to next message
Messages: 25570
Registered: January 2009
Location: SoCal
Senior Member
>the image is referenced correctly
Not correct, obviously, as far as SMTP is concerned.
The solution is non-trivial and has NOTHING to do with Oracle; just SMTP.
Re: send html emails with images? [message #333861 is a reply to message #333857] Mon, 14 July 2008 11:29 Go to previous message
Messages: 3202
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
There are two options for images in mail :

1. Image is part of the mail

Then id needs to be included into to mail as part of a multi-part MIME message, and referenced with the CONTENT ID, for example :

<IMG SRC="cid:foo4*foo1@bar.net" ALT="IETF logo">

2. Image is on a separate web server.

Which is the easier option, then you just have to include the image with the internet address, like :

<IMG src="http://www.yourserver.com/images/image.jpg">

And I hope you are NOT really using bitmaps.
Previous Topic: Partitioning Factor
Next Topic: Conversion Error
Goto Forum:

Current Time: Sat Aug 19 06:28:09 CDT 2017

Total time taken to generate the page: 0.04624 seconds