Print Page | Close Window

PBS Email Query Executable

Printed From: peach info
Category: INTEGRATION & ADDONS
Forum Name: Useful Utilities
Forum Description: Utilities from Steve and Pouya and what they do
URL: http://www.peachinfo.net/forum_posts.asp?TID=1720
Printed Date: 29-Mar-2024 at 10:31
Software Version: Web Wiz Forums 11.04 - http://www.webwizforums.com


Topic: PBS Email Query Executable
Posted By: peach
Subject: PBS Email Query Executable
Date Posted: 08-Aug-2014 at 12:14

Attached is an application that lets you store a query which when run if it returns any records, it will send an email (setup email details in the email tab first)
Extract into its own folder,  C:\PBSEmailQuery

Example: If you wanted to check for new online orders every 5 minutes and email you each time an online order was received...... Query e.g. would be: Select id from Pbstrans where id like 'co*' and source = 'online' and reference = 'final'

Set the database location to look at the pbo.mdb

There is a batch file in the zip too – so you can setup a scheduled task to run every 10 mins.


http://www.peachinfo.net/downloads/PBSEmailQuery_v1.1.zip" rel="nofollow - http://www.peachinfo.net/downloads/PBSEmailQuery_v1.1.zip







Print Page | Close Window

Forum Software by Web Wiz Forums® version 11.04 - http://www.webwizforums.com
Copyright ©2001-2015 Web Wiz Ltd. - http://www.webwiz.co.uk