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
Jayla
Messages: 5
Registered: July 2008
Location: Suffolk, UK
Junior Member
Hi

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

Regards
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
BlackSwan
Messages: 26766
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
ThomasG
Messages: 3212
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: Compile error
Next Topic: Index Not getting used
Goto Forum:
  


Current Time: Thu Nov 07 22:14:40 CST 2024