Pulling data from a SQL server

[steelcoyot]

Does anyone have a script that will pull user modified information in SQL and have it emailed to a group? The Database is Great Plains and we're trying to perform audits of daily changes preformed by users for SOX Compliance. Any help would be appreciated

 

[jbenson001]

There have been plenty of posts here on how to email. Once you pull the data, it is simply a matter of assigning the data to the email object and sending. Also, there are plenty of examples out there if you search in Google.

 

[jshurst]

Here is an example of sending an email through a web service, but the code will be the same (pretty much)...

faq855-5920