CDOSys and query attachments

• RichardDouglas

  SSCarpal Tunnel

  Points: 4029

  More actions

  October 30, 2009 at 9:52 am

  #1073246

  Have you tried using xp_Sendmail?

  Hope this helps,
  Rich

  [p]
  [/p]

• Arif Hafeez-Imam

  SSChasing Mays

  Points: 631

  More actions

  October 30, 2009 at 9:59 am

  #1073252

  Hi rdouglass,

  my understanding is that the xp_sendmail sp would require "SQLMail" to be configured which depends on an Outlook client being configured and installed on the SQL server and the SQLServerAgent service would need to be started using the username for the Outlook mailbox. Or am I getting this completely wrong?

  Ideally I would like to steer clear of configuring the "SQLMail" functionality due to this reason. (Unless I have completely missed the point somewhere.)

  Thanks for your reply.

  Arif

• RichardDouglas

  SSCarpal Tunnel

  Points: 4029

  More actions

  October 30, 2009 at 10:12 am

  #1073256

  Hi Arif,

  You're correct in that xp_Sendmail does have quite a few dependencies, I've not used CDOSYS before and thought that xp_Sendmail might be a viable alternative for you.

  Rich

  Hope this helps,
  Rich

  [p]
  [/p]