Assuming that the buffer is a variable name, all you need to do is DatabaseSave "somefile.txt", "TXT", rows
FileReadAll "somefile.txt", buffer
MailSend "Account/Profile name", "password", "me@mycomp.com", "Subject", buffer If you use SMTP email interface with text/HTML format option you can save the file in HTML format with column headers, tables, etc... rather then as a plain text file. A more simple and elegant method is to send it as an attachment DatabaseSave "somefile.xls", "XLS", rows
MailSendWithAttachment "Account/Profile name", "[password]", "[me@mycomp.com]", "Subject", "See attached report", "somefile.xls" : I would like to query a database and then send the results of that query in
: the body of an e-mail. I can successfully query the database using the
: DatabaseRetrieve command and get the rows into the "buffer" but
: I'm not sure how to get them from the buffer to the body of the e-mail
: message. Thanks for your help!
|
