Unable to add multiple attachments using DBMail

• mclucas

  Newbie

  Points: 5

  More actions

  March 15, 2010 at 11:26 am

  #217798

  How do you use sp_send_dbmail to send all attachments in a given folder?

  If I use @file_attachments = 'c:\attachment\*.*' then it just states the attachment file is invalid. The only way I can think to do it is to save the attachment locations into the SQL database and then do a query to get all the exact paths but this seems overly complex. Is there a better way?

  Any help would be much appreciated.

  Thanks,

  Matt.

• sturner

  SSC-Insane

  Points: 22411

  More actions

  March 15, 2010 at 11:54 am

  #1133945

  it does not work with wildcards.

  I would have whatever app puts the attachment files in the folder insert a row with (containing the path) into a table as well.

  The probability of survival is inversely proportional to the angle of arrival.