I am still very much a greenhorn in regards to Toad Automation, but have been thrown into the lions den at work and have had to learn quickly and Toad World has been an invaluable resource so far.
What I am attempting to do, I feel like, seems easy, but I have struggled to figure out/find a way to do it. I have a scrip that runs and populates a table based on the results of said script. The vb Script is an MS Access macro that looks for files to ensure that the new files have been posted for the current date. The results are added to a table in Access and I have created the connection in Toad.
What I am want to do is query the results in the table and add them to an email.
I do not want them as an attachment, but as a table/variable inside the actual email. When I set up a Variable as SQL, and use:
SELECT * from tbl_Status
I get the following:
To_date(‘10/17/2016 00:00:00.00’, ‘MM/DD/YYYY HH24:MI:SS.SS’)
Edit: The Log shows: Variable “strRecords” set to a result set of 27 row(s)
Any suggestions on how I can achieve this without using attachments?