Results 1 to 5 of 5

Thread: xp_sendmail & HTML

  1. #1
    Michael Guest

    xp_sendmail & HTML


    Hello everybody!

    Can I make e-mail message by xp_sendmail SP in HTML (without attach)?

    Thanks.

  2. #2
    chris Guest

    xp_sendmail & HTML (reply)

    use xp_sendmail and sp_makewebtask.


    ------------
    Michael at 8/29/00 8:12:01 AM


    Hello everybody!

    Can I make e-mail message by xp_sendmail SP in HTML (without attach)?

    Thanks.

  3. #3
    Michael Guest

    xp_sendmail & HTML (reply)


    Chris,

    Thanks for answer, but I need query result into message body (in HTML). By you way I can get HTML page or reference to it. I can make HTML-page by multiple SELECT and make attach file with *.html extention. It's one way, but not need it. I need all of that into message body. May be @type argument but I can't find docs or examples.

    Regards, Michael.

    ------------
    chris at 8/30/00 5:28:26 PM

    use xp_sendmail and sp_makewebtask.


    ------------
    Michael at 8/29/00 8:12:01 AM


    Hello everybody!

    Can I make e-mail message by xp_sendmail SP in HTML (without attach)?

    Thanks.

  4. #4
    Chris Guest

    xp_sendmail & HTML (reply)

    Why don't you use dynamic SQL and build the HTML dynamically. If you always have a static body, just with dynamic values, that would be your best bet.

    ------------
    Michael at 8/31/00 3:12:24 AM


    Chris,

    Thanks for answer, but I need query result into message body (in HTML). By you way I can get HTML page or reference to it. I can make HTML-page by multiple SELECT and make attach file with *.html extention. It's one way, but not need it. I need all of that into message body. May be @type argument but I can't find docs or examples.

    Regards, Michael.

    ------------
    chris at 8/30/00 5:28:26 PM

    use xp_sendmail and sp_makewebtask.


    ------------
    Michael at 8/29/00 8:12:01 AM


    Hello everybody!

    Can I make e-mail message by xp_sendmail SP in HTML (without attach)?

    Thanks.

  5. #5
    Michael Guest

    xp_sendmail & HTML (reply)

    By task conditions, I must make D-SQL in HTML. Yes, you way is good, but it some harder for administration (many stages).
    1.Sheduled task for generate static page.
    2.Shedule task for send e-mail messages.
    (This stages must be coordinated by time.)

    I'm already make D-SQL & HTML from file-attach. But I want to know, can I send HTML message by xp_sendmail or not.

    Thanks again.

    Michael

    ------------
    Chris at 8/31/00 10:57:37 AM

    Why don't you use dynamic SQL and build the HTML dynamically. If you always have a static body, just with dynamic values, that would be your best bet.

    ------------
    Michael at 8/31/00 3:12:24 AM


    Chris,

    Thanks for answer, but I need query result into message body (in HTML). By you way I can get HTML page or reference to it. I can make HTML-page by multiple SELECT and make attach file with *.html extention. It's one way, but not need it. I need all of that into message body. May be @type argument but I can't find docs or examples.

    Regards, Michael.

    ------------
    chris at 8/30/00 5:28:26 PM

    use xp_sendmail and sp_makewebtask.


    ------------
    Michael at 8/29/00 8:12:01 AM


    Hello everybody!

    Can I make e-mail message by xp_sendmail SP in HTML (without attach)?

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •