Results 1 to 3 of 3

Thread: DBMail

  1. #1
    Join Date
    May 2006
    Posts
    1

    DBMail

    Is it possible to embed a image datatype into a EMail message using sp_Send_DBMail?

    For example, my query would select a saved print screen image held in a SQL table as datatype image. I would prefer not to attach this image but rather have it print in the message section.

    Thanks in advance.

  2. #2
    Join Date
    Jan 2003
    Location
    Nottinghamshire, UK
    Posts
    364
    Hopefully you mean xp_sendmail

    Sends a message and a query result set attachment to the specified recipients.

    Syntax
    xp_sendmail {[@recipients =] 'recipients [;...n]'}
    [,[@message =] 'message']
    [,[@query =] 'query']
    [,[@attachments =] 'attachments [;...n]']
    [,[@copy_recipients =] 'copy_recipients [;...n]'
    [,[@blind_copy_recipients =] 'blind_copy_recipients [;...n]'
    [,[@subject =] 'subject']
    [,[@type =] 'type']
    [,[@attach_results =] 'attach_value']
    [,[@no_output =] 'output_value']
    [,[@no_header =] 'header_value']
    [,[@width =] width]
    [,[@separator =] 'separator']
    [,[@echo_error =] 'echo_value']
    [,[@set_user =] 'user']
    [,[@dbuse =] 'database']

    U Should be able to
    [,[@attachments =] 'attachments [;...n]']
    easy enough

    But to embed it as a BLOB into emails & not as an attachment is an interesting yet Scary Question

    I Hope U are'nt a Spammer !!

    lol

    GW
    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Why not use VB or ASP in this case to build the case and insert the messages in that form. You can blend sendmail with those programs too.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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