How to Collect Data from Inbound Emails and Insert It into MS Access Database

When you are running an online business, you most likely maintain a database with the customers’ names, email addresses, order numbers, activation keys, purchased products, postal addresses, phone numbers, and other personal information you may gather. This huge amount of data needs to be processed when the order is received and needs to be updated if a customer changes the email address or leaves the company.

G-Lock Email Processor helps you collect the data from incoming email messages and add a new record to your MS Access database or update data in the MS Access database based on a received message. The MS Access database can reside on your local computer or on your network.

How to Collect Data from Inbound Emails and Insert It into MS Access Database

The unique features of G-Lock Email Processor and the flexible processing engine allows you to process any type of messages, e.g. messages sent via a web form on your website, messages sent by your order processing company, messages with attachments.

You can use any type of an email sender, contact form or script which generates and sends the email. The data extracted from the email message will be mapped to the data cells of the MS Access database automatically. G-Lock Email Processor can change the data format using the script before adding it to the database. For example, it can convert the date format Tue, 4 Aug 2016 18:26:06 to 2016-08-04 18:26 or change the “.” separator in 2.5 to “,” (2,5), etc.

How to Collect Data from Inbound Emails and Insert It into MS Access Database

The table in the MS Access database can be customized by you – there are no required columns or data types. All you need to do is to map the source fields of the email to the corresponding database columns.

How to Collect Data from Inbound Emails and Insert It into MS Access Database

Using the “Test Rule” feature you can verify all the settings based on the loaded sample message.

G-Lock Email Processor can process incoming messages from a regular email account using IMAP or POP3 any time by the user’s request or using a timer (e.g. every 30 minutes), depending on your workflow. It works on your computer with a Windows system as a service which starts automatically at the system startup.

Try G-Lock Email Processor for free and parse your first emails to the MS Access database within minutes!

Download Free 30-Day Trial ->

Average rating:  
 15 reviews
Fantastic Support

We had been using G-Lock processor for some time with out any problems. Our provider sadly made some changes that broke the connection to G-lock.

G-lock support was fantastic and took a backup of our system and restored it and debugged the problem really quickly. They promptly remoted in and fixed the problems with our system.

Impressed and appreciated - Thank you Julia & Co

Page 1 of 15:
«
 
 
1
2
3
 
»
 

Interested? Learn more about our email parser software for Windows.

Further reading:


Leave a comment

Get «Email Marketing Secret №1» eBook for Free Today!

Many who are new to email marketing start off on the wrong foot. They ‘spray and pray’ and hope that someone will click and buy, but are hit with angry complaints and find their emails blocked as spam.

But you can significantly improve your odds of reaching customers and prospects by taking the right steps.

Get Email Marketing Secret #1 eBookDownload our PDF eBook and learn how to collect more leads and send highly responsive emails for free to grow your business and maximize your email marketing, not relying on expensive, restrictive email services that charge high monthly fees and ultimately control your profit at their whim. Be in control of your email…

This offer is limited! Act fast!

LAST STEP


Get Email Marketing Secret #1 eBook

Where should We
send the Free book?

Easily save as a PDF or print for daily use

Privacy Policy: We hate SPAM and promise to keep your email address safe.