G-Lock Software

HomeProductsForumsFAQDownloadsRegistration













 Parse incoming email message - process unsubscribe request
 Home \ Products \ G-Lock Email Processor \ User Guide \ Custom SQL

To write your own text of the SQL Statement, click Custom SQL tab.

Write your SQL Statement text in the displayed window. Clicking the right mouse button on the window will bring up the popup menu. Select Insert Fields to insert your fields into the SQL Statement. Select Table Fields to insert the fields from the selected table into the SQL Statement text.

ATTENTION!

 

If you manually specified SQL Statement text, make sure the variables are enclosed in [%...%] brackets.

Use current SQL Statement - check this option if you want the program to use the SQL Statement text you typed instead of the SQL Statement that is automatically generated in the Database Manager settings window.

      

 

G-Lock Email Processor
  User Guide

Getting Started
Program Main Window
Process Bounced Emails
Process Remove Requests
Process Subscribe Requests
Process Confirmation Letters
Detect and Remove Spam Emails
Creating Accounts
Creating New Rule

Program Settings
General Settings
Inbox Explorer Settings

Setting up Filters
Principle of Email Filtering
Using Regular Expressions
Filter By Size
Filter By Header/Body
Filter By Subject

Setting up Field Extractor
Field Extractor Window
Source Box
Generate Value From Mask
Create Fields From Database
Create Fields From Clipboard
Create Table In External Database

Setting up Fields Processor
General Settings
Script Syntax

Setting up Bounced Emails Processor
Hard & Soft Bounced Emails
Exclusion List

Setting up Actions

MS Windows Script
General Settings

Database Manager
General Settings
Connection Info
Custom SQL
Working With Table In Excel
Get Identity Value From Table

Write To File
General Settings

Save Attachment
General Settings

Forward Email
General Settings
Additional Settings

Send Email
General Settings
Additional Settings
HTML Settings

Log
Outbox
Inbox Explorer

See also

Services
  Registration
Affiliate
 
Support
  Users Forum
Contact us
 
Info
  Trojan Port List
Privacy Statement
Media and Press Information
 
  Add to Favorites
 
 
   
 
 
   

 

Home | Products | Forums | FAQ | Downloads | Registration