View Single Post

   
  #1 (permalink)  
Old 02-29-2008, 07:14 AM
Michael McGarrigle
 
Posts: n/a
Default Sending file contents in the body of the email with xp_sendmail

I would like to send the contents of a file using xp_sendmail however
I do not want the file contents to be an attachment.
I have no problem sending the file as an attachement.
Can anybody give me an xp_sendmail example of how to do this.
The results of a query can easily appear in the body of the email but
all my
attempts to include the contents of a file in the body of the email
have not worked.

TIA
Reply With Quote