Posts Tagged ‘Email Processor’

Convert HTML Email into PDF

Convert HTML Email into PDF

What the Rule Does

The rule creates PDF files from incoming messages using the original email content, saves PDF files to a local folder and sends an email with the PDF attachment to a recipient. You can activate/de-activate the “Send Email” component depending on your needs.

If you do not have G-Lock Email Processor yet, click here to download it now.

How to Use the Rule

1. Download PhantomJS.

To be able to process email messages by this rule, you need to download PhantomJS (free open source tool).

At this page, you can download PhantomJS for Windows.

Extract the content from the downloaded file to the root folder on the C: drive for example.

Now open the examples folder on C:\phantomjs-2.1.1\, copy the rasterize.js file and paste it into the bin folder (C:\phantomjs-2.1.1\bin).

2. Download Rule.

Click here to download the rule (.zip file).

Extract the rule .txt file and .eml file.

Open G-Lock Email Processor and click on “Open Rules folder”.

Copy-paste the rule PhantomJS.txt file to the Rules folder.

Copy-paste the .eml file to the Emails folder.

Return to G-Lock Email Processor and click on “Reload Rules Folder”.

Look for the “PhantomJS” rule in the list of rules. Click on the rule name to see what components it includes.

Important notes:

The path to the default folder to save PDF files is D:\111\. If you want to change the folder to save PDF files, you can change it in the PdfFolder extractor settings.

Convert HTML Email into PDF

If you change the path to the folder in the PdfFolder extractor, make sure to change it in the Folder extractor settings after file:/// too.

Leave file:/// in place.

Convert HTML Email into PDF

Important! By default, the path to the phantomjs.exe file is C:\phantomjs-2.1.1-windows\bin\. In our rule, the path is phantomjs-2.1.1\bin\ because we renamed the phantomjs-2.1.1-windows folder to phantomjs-2.1.1. To avoid errors during the rule execution, open the PhantomPath extractor settings and type the correct path to your phantomjs.exe file.

Convert HTML Email into PDF

If the path to the phantomjs.exe file is wrong, the rule execution fails with the error below:

Convert HTML Email into PDF

You can also check and activate the Send Email rule if needed. It sends an email with the created PDF file as an attachment. You can check the path to the attachment under the Advanced tab.

Download the Rule (.zip file).

How to Automatically Move Incoming Emails Between IMAP Folders

Move emails between IMAP folders

As a business, sometimes you may need to sort incoming emails by different IMAP folders.

For example, if all emails come to the same email account, it is reasonable to move support tickets to the folder checked by the support team,  orders –  to the folder monitored by the sales department, marketing emails – to the promotions folder etc. Your inbound email stream could be well organized and each department would not waste time for searching their messages in dozens or even hundreds emails in the Inbox.

How to Automatically Parse CSV Attachment to Database

Parse CSV attachments to database

Sometimes it’s just easier to email a file than upload it to a server. If you run an online business, you may receive transaction confirmation emails with CSV attachments, or monthly sales reports with attached CSV documents, or support tickets with attachments. And you may need to regularly update your database with the data received via CSV files arriving as email attachments.

How to Automatically Parse Emails from Web Forms

Parse email from web form

Many online businesses have web forms that visitors fill in such as newsletter subscription forms, registration forms, contact forms, survey forms etc. After a visitor submits the form, the content is sent to the web site owner via email. Getting the form data as emails is a very convenient way to collect user responses very quickly. But when you have hundreds of responses per day, processing them manually can be very challenging.

How to Automatically Parse Email to Database

Extract data and parse email to database

Extract Data from Incoming Emails and Convert It to Database

If you’re doing business online, you probably maintain a database of your customers, clients, or subscribers. Typically you store the customers’ email addresses, names, order numbers, and purchased products in the database. Plus, you may want to keep the customer’s personal information such as postal addresses, phone numbers, fax numbers and much more in your database. It’s a large volume of data that you need to keep in order — add new customers, remove customers, and update the customer’ information on their request.

How to Automatically Parse Email to an Excel Spreadsheet

Extract data and parse email to Excel

Extract Data from Incoming Emails and Convert It to Excel

Many people receive hundred emails to their Inbox containing data filled out via a website form and they are looking for a solution how to parse these emails into an Excel spreadsheet automatically.

Is there a tool where you can define a parse “template” which would filter incoming messages, extract the desired data from the messages and auto parse the data into the Excel columns? 

Yes, you can use G-Lock Email Processor to automate parsing emails to Excel spreadsheets.

How to Automatically Parse Email to CSV

Extract data and parse email to CSV

Extract Data from Incoming Emails and Convert It to CSV

If it happened to you to copy data from incoming messages and paste it to a CSV file, manually, you know what time consuming and boring this work is.  And if you have dozens or even hundreds emails you need to process? This is eating almost all working time. 

Luckily, now you can stop your manual work and use G-Lock Email Processor to automate your email workflow.

Save Email Attachments to Database

How to Save Email Attachments as Binary to the Database

What the Rule Does

The rule extracts the email attachment,saves it to a temp folder on the disk, then inserts the attachment into the database and delete the attachment from the disk. Also, the rule includes the Script that restores the deleted attachment to the folder. You can activate/de-activate this component depending on your needs.

If the message has more than one attachment, the rule will process all attachments.

How to Use It

Download the Rule (.zip file)

Extract the files from the .zip file.

The zip file contains the rule Save_Attachment_to_DataBase.txt file, a debug message in the .eml format and a sample MS Access database to which the attachment will be saved.

If you do not have G-Lock Email Processor yet, click here to download it now.

Install G-Lock Email Processor, open it and create the account from which you will process messages.

Extract the files from the zip file and do this.

Click on the “Open Rules Folder” on G-Lock Email Processor toolbar.

Save the rule Save_Attachment_to_DataBase.txt file to the Rules folder.

Open the Debug Messages folder in the Rules folder and save the Test with Attachment.eml file here.

Save the Test_File_Save.accdb file to root folder on the D drive (D:\Test_File_Save.accdb).

Go to G-Lock Email Processor and click on the “Reload Rules Folder” button.

Look for “Save Attachment to DataBase” rule in the list of rules. Click on the rule name to see what components it includes.

The rule contains the following components:

1. Block Extractor that extracts all attachments from the message just in case the message has more than one attachment. 

The following components are inside the block to make the rule work for each attachment.

2. Field Extractor that extracts each attachment name.

3. Save Attachment component that saves the extracted attachments to the disk (D:Temp folder).

4. Script Processor that inserts the attachment from the disk into the database (D:\Test_File_Save.accdb). When you modify the rule to fit your needs, open the Script Processor and check the script. Correct the connection string as necessary.

5. Fields Processor that deletes the processed attachment from the disk (it’s necessary if the next message has the attachment with the same name as the processed attachment).

6. Script Processor (Test Saved Data) that restores the deleted attachment to the folder on the disk. You can disable this component if you don’t want to restore the deleted attachment.

Download the Rule (.zip file)

Help Us Spread the Word about G-Lock Email Processor!

Help Us Spread the Word about G-Lock Email Processor!

We don’t usually ask much of you. We try to make you happy. But today we’d like to ask your help. Do you love G-Lock Email Processor? If it’s saving you time, please, spread the word about it.

We are happy if our program makes your life easier and helps you in business. We believe that with your word of mouth it can be known by others who are at pain with dealing with hundreds incoming emails manually, day by day.

G-Lock Email Marketing Bundle: G-Lock EasyMail7, Email Verifier & Email Processor

G-Lock Email Marketing Automation Bundle

G-Lock EasyMail7, Email Verifier & Email Processor for Windows

G-Lock Email Marketing Bundle

If you want to grow your business, you can't bypass email marketing. In the modern world companies and entrepreneurs who are using email as a successful marketing strategy need fast, reliable and cost-effective email marketing automation solution. G-Lock Software delivers you powerful software that suits perfectly for targeted bulk email marketing campaigns, email list management and email processing at your desktop.

G-Lock Email Marketing Bundle includes:

  • G-Lock EasyMail7 – Self-Managed, IN-HOUSE Email Marketing Automation Platform for Windows®
  • Advanced Email Verifier – Clean Your List from Bad Email Addresses and Invalid Domains
  • G-Lock Email Processor – Extract data from inbound emails. Automate your workflow within minutes and save valuable time.

G-Lock Email Marketing Bundle combines an unrivaled feature set with world-class support and virtually infinite flexibility, at a fraction of the price charged for competitive programs.

 

Buy Email Marketing Bundle and Save 15%!
Order processed by Avangate®


G-Lock EasyMail7 Email Marketing Automation Software

System requirements: Windows® Vista, 7, 8, Windows® Server 2008/12

Want the better way to stay in touch with your clients, prospects or subscribers and elevate your business to the next level, grow it and make it more profitable?

Try G-Lock EasyMail7 Today – Powerful, Self-Managed, IN-HOUSE Email Marketing Automation Platform for Windows® that works with any Email Delivery Services like Amazon SES, Sendgrid, Mailgun or your mail server.

Zero monthly fees saves you a fortune in email service providers costs.

G-Lock EasyMail7 ($159.00 USD price in bundle $135.15 USD)


Advanced Email Verifier Heps you protect your account from being blocked and send to Inbox

System requirements: Windows® Vista, 7, 8, Windows® Server 2008/12

Clean Your List from Bad Email Addresses and Invalid Domains and Increase Your Email Campaign Performance by Focusing only on REAL Prospects

You can use our Advanced Email Verifier to clean your list from invalid addresses before sending to it. Although it is simply not possible to guarantee a 100% accuracy level due to certain multiple factors beyond our control, the Advanced Email Verifier has a good email validation success rate. It can determine around 70-90% of bad email addresses and help you reduce your bounce rate.

Advanced Email Verifier ($99.00 USD price in bundle $84.15 USD)


G-Lock Email Processor Automated email processing and parsing software

gep main window 1 G Lock Email Processor

System requirements: Windows® Vista, 7, 8, Windows® Server 2008/12

Want a Convenient and Easy Way to Automate Processing of Incoming Email Flow, Without Spending a Single Minute of Your Working Time?

G-Lock E-mail Processor is used by businesses of all sizes to parse and extract data from messages, process email attachments, manage bounced and unsubscribe emails, convert message content into database records, process emails from local or network folders and much more, 24 hours a day, seven days a week.

G-Lock Email Processor ($595.00 USD price in bundle $505.75 USD)


Buy Email Marketing Bundle and Save 15%!

Order processed by Avangate®

 

Building your list, delivering email newsletters and grow sales with email marketing is the hottest sales lead generation trend on the web today. You want an email marketing solution that fits your email marketing goals and target audience, reduces the cost and complexity of your email marketing efforts, and ensures your success in online business.

No Commitment or Hidden Fees. Try it Risk-Free For 60 Days

Your investment is covered by our full 60-day, complete satisfaction, “love it or your money back” guarantee.

You can now safely and securely order our products and try it for 60 days at our sole risk! Your credit card information will be sent directly to the credit card processor via a secure (SSL)
channel so that no one can intercept your personal data.

E-commerce services is provided by Avangate® an e-commerce reseller.