Hi Brad,

We do have a way to send an email using AquaCommands in the Query Analyzer window. You can add something like this at the end of your statements in the Query Analyzer window. 

.sendMail 'host=smtp.gmail.com,
port=465,
ssl=true,
authentication=true,
user=,
password=,
from=me@mycompany.com,
to=you@yourcompany.com,
subject="Nice document attached",
message="This will blow your sockets off\ncheck it out!",
attachments="c:/abc.xls,c:/abc2.xls"'

You can also use the sendmail command if you are using Fluidshell. 

Let me know if that works for you.

Thanks,Tom

I tried running this...

select top 100 * from dim_account;

.sendMail 'host=smtp.google.com,
port=25,
ssl=true,
authentication=false,
from=bdegenaars@liveperson.com,
to=bdegenaars@liveperson.com,
subject="Nice document attached",
message="This will blow your sockets off\ncheck it out!"

but I am getting this error:

Hi Brad,

Try adding a single quote after the last double quote. The parameter list for .sendMail should be enclosed in single quotes like .sendMail 'parameters'

Give that a try..

Thanks, Tom

.sendMail 'host=smtp.google.com,
port=25,
ssl=true,
authentication=false,
from=bdegenaars@liveperson.com,
to=bdegenaars@liveperson.com,
subject="Nice document attached",
message="This will blow your sockets off\ncheck it out!"'