MSSQL 2008

Maybe i'm just looking in the wrong place.
Here's the scenario:

We have files stored in a varbinary(max) column.
I'd like to select these as individual files, along with the names of the files stored nearby, as individual file attachments.

can this be done?

it's easy enough to send the results of a query as an attachment, but it just sends 1 file.

Thanks