Re: Oracle Java Mail Question
Date: Thu, 30 Jun 2005 03:56:58 -0400
Message-ID: <8497c1pkei90iao4onie41qvd86k75pue6_at_4ax.com>
By pretty emails I mean, that using standard HTML tags (anything between <BODY> and </BODY>) you can send as the text message. As long as it does not exceed 32k which makes for a lot of room to build your formatted HTML message. If you can make a web page example of what you want, then just copy paste what is between the body tags into the contents of the message parameter in my PLSQL procedure and tada ! Pretty Email.
I never understood why users couldn't be happy with plain jane text emails, but alas... they are the customer. So I got it working for them.
To take a step further, you can easily perform string substitution to your message so that it can be personalized to the individual before sending it off.
There are of course other methods to do the same thing, this is just the method we went with and it has been in the works for about 2 years now running solid. Introduced it on a 8i platform and we are on 9iR2.
Barry Chase
MylxHQ - My Oracle Resource Portal
http://www.mylxhq.com
On 29 Jun 2005 06:37:48 -0700, amerar_at_iwc.net wrote:
>
>You say that your routine sends 'pretty text' emails. What about HTML,
>so I can change font size and change color, etc? Will that work? Are
>you referring to the Oracle UTL_SMTP routines, or is this something
>totally different?
Received on Thu Jun 30 2005 - 09:56:58 CEST