Sending email in html format from database


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Sending email in html format from database

  1. #1
    Join Date
    Jun 2007
    Posts
    7

    Sending email in html format from database

    For my task I need to send an email on a daily basis from a particular table in my database.


    At first I try to send the stuff with my PL/SQL stored procedure and seems it works. I am wondering the limitation of UTL_SMTP package. In case my data is not in bulk then it would work fine. However, if I have more data to be sent, then it would not work.

    I knew that there would be other options like using shell script or mailx for sending email. I know totally nothing about these two and don't know where I can learn these. In case if I use shell script or mailx, would it be possible for me to send the email in html format? If I first export the data in a file, then send the email with the file contents, would it still be possible to make it in html format? Because the end-users request to have the report in html format by email. I don't know how I should start with. Please help me experts! Thanks a lot!

  2. #2
    Join Date
    Mar 2005
    Location
    Los Angeles, Calif. AKA: Gangsta Yoda™
    Posts
    455
    What database server are you using? If SQL Server you can use the xp_sendmail extended stored procedure.

    Note: the end users may not have html email capabilities and in that case they would receive all the html markup code in text format.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer code questions via PMs.
    Microsoft MVP 2006-2009
    Office Development FAQ (VBA, VB6, VB.NET, C#)
    Software Engineer MCP (VB6 & .NET)
    Reps & Rating PostsVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6Outlook Global Address List

  3. #3
    Join Date
    Jun 2007
    Posts
    7
    I m using oracle10g

Similar Threads

  1. DATABASE & HTML
    By Stryker in forum VB Classic
    Replies: 4
    Last Post: 10-29-2001, 08:56 PM
  2. MS-Access Error - Obsolet Database Format !
    By Makl. Lemmertz in forum VB Classic
    Replies: 2
    Last Post: 10-29-2001, 11:12 AM
  3. access database format no is valid
    By Alejandro E. in forum VB Classic
    Replies: 6
    Last Post: 08-10-2001, 11:45 AM
  4. How to link a database and a HTML page ?
    By Seb in forum VB Classic
    Replies: 1
    Last Post: 05-20-2001, 10:16 AM
  5. HTML in CT
    By HTML in forum Web
    Replies: 0
    Last Post: 07-05-2000, 12:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center