PRO features: multiple email accounts and rules

The Mail Attachment Downloader FREE versions offer the ability to download emails from only a single email account at a given time. Furthermore, you are restricted to only a single search or filter criteria.

We will explain how the Mail Attachment Downloader PRO versions differs and overcomes these limitations below with the PRO Features: multiple email accounts and rules.

Multiple email accounts

With the free version, you can run a download session for a single email account at a time. To download from another account you will need to pick another account from the Account dropdown.

With the PRO version, you can select multiple accounts  by selecting <multiple@multiple> option from the Account or email pulldown as shown below.

This will bring up the multiple account chooser after which you can select multiple email accounts that have already been configured.

multiple email accounts

Note that prior to selecting these accounts, you will need to add these accounts to the Account list first as individual accounts and then select the <multiple@multiple> option to choose multiple accounts.

Once selected, when Connect and Download is clicked, the program will download emails from multiple emails automatically.

If you have the PRO Server version and you want to download from multiple email accounts in the background, just select <multiple@multiple> first and then go to the Service tab and then click the Install service button.

Multiple email rules

The FREE version only let you specify a single email rule per email account. For example, you could search for emails starting from a certain date (search tab) and also include a Filter (filter tab)  by Subject. This will download all emails from that date that also match the Subject you provided.

This setting is saved per email account. When you switch accounts, you can specify a different search and filter setting that will be remembered for that account.

But what happens when you want to download this Subject to a folder and maybe a completely different email with a different Subject to a different folder and perhaps also run some actions after downloading the file?

You can do so with the Global Filters tab in the PRO versions as shown in the screenshot below.

IMPORTANT:

The global filters tab lets you add one or more rules (order matters).

Ordering: For every attachment (or .eml if Save as .eml was checked), the program scans rules from topmost down (rule by rule) and checks to see if a rule matches all the criteria. When a match is found and a file is saved, no other rules below it are run for that attachment. Note that other attachments in the same email or body (if body hasn’t been saved already) will scan all the rules again from topmost down to find a match for that attachment/body.  Enable and use rule tracing to find out how or why an attachment or a body did not match a rule.

Applies to all email accounts: These rules apply to all accounts you have defined in the Account dropdown by default.  That is, each rule defined here, by default, will apply and run for every download session regardless of the email account that was selected/used to run the download.

You can, if needed, make the rule run only for a specific email account by adding an Account filter as will be explained below.

When using global filters, certain settings in the Search and Filters tab that were set for individual accounts will no longer be used and the UI for these will be disabled.

This is because the Global filters take precedence over the individual settings specified. You can specify the same exact Search or Filter criteria via a global rule as will be shown below.

To replicate the search and filter settings that you had in your free version in the PRO version, the first step is to click Add new filter and enter a rule name for the new filter. Below we’ve entered then name as ‘Payments FY 2016 Q3’ as an example.

rule filter

IMPORTANT 

Account specific rule: If you want this rule to only apply to a specific email account and not all accounts, you should  specify a filter.

In the filters section of the Rule window, click Add -> Filters -> Account and choose the account from the dropdown (see screenshot below, choose Account instead of Header: SUBJECT).

Not doing so will mean that this rule runs for all accounts.

To add the Subject filter (that was previously in the Filters tab), click the Add button below the filter name in the Rule filters and extractions section and click on the Filters sub-menu followed by the Email Subject sub-menu item.    

This will add a new Subject filter to the Filters list as highlighted below. You can then enter the Subject you want to search much like you could have with the Filters tab in the main program window. Click on the Subject text box or click the … button next to get a help on how to specify this filter.

subject filter added

There are three ways you can specify a “match” in Mail Attachment Downloader PRO in almost any field that does a match (Subject, From, To, etc.).

  1. No quotes: In the field if you just specify Payments without quotes, then it will do a substring match. If the word Payments appears anywhere in the Subject it will be a match.
  2. With quotes: Including quotes like ‘Payments’ will do a regular expression match. If it’s just ‘Payments’ with the quotes it will do a substring match just like in (1) above. You can test out the regular expression by clicking the … button to the right of the text input area as shown above.
  3. With quotes and logical operators: You can also include logical operators such as OR, AND, NOT to combine multiple quoted matches. So an entry like ‘Payments’ OR ‘Invoices’ will match any subject where the words Payments or Invoices appear anywhere in the Subject (i.e. a substring match). You can also use parentheses to group these like: NOT (‘Payments’ OR ‘Invoices’) AND ‘Sales’ will match just Sales and not Payments or Invoices.

Use the button to test out your match criteria for any field to see if that is what you want.

Similarly, you could add other filters like by File type filter. 

Click on the Filter file types list item in the list box below the Add button to reveal the file types you want to select. Example below shows how we can filter by file type of Documents. You can add your own in the Other section (comma separated, like .csv, .jpg etc.).

filter by file type

Extractions

Similarly, you could also extract data from any email header or body or attachment once the subject and file type matches if you would like as shown below.

Click Add -> Extractions -> (pick the wizard or regular expression option).

extractions

For more about extractions, check this in-depth guide on how to extract data from emails and attachments.

Choose save filename or format

Once you have the filters and extractions setup, you can pick the filename format as shown below. Click on the little information button next to the filename format to see a list of templates (enclosed between { and }) to include in the filename.

Save filename and format

CUSTOM FOLDERS: You can also include a \ in the Saved filename format field to indicate that a folder needs to be created. The program would automatically create a folder here whenever needed.

For example, {EMAIL_FROM}\{FILENAME}_{ID}{EXT} would create a folder for every senders emails address. This will be automatically created when a new attachment is downloaded.

Click the [i] information button to the right of the Saved filename format area to bring up a guide of all the fields you can insert in here.

TIP: Just double click the field in that popup window and it will insert the field at the current cursor location into the text area.

A few things to also keep in mind:

  • Always include {ID} in the Saved filename format. Excluding the {ID} will result in inconsistent downloads. This is because the program uses multiple threads to download emails simultaneously. If two filenames happen to clash on the filename, you may notice inconsistent behavior.
  • When you are using a shared folder as the Save folder, it MUST be a UNC path (do not use a mapped network drive as these will not work with the service installation).

READ this blog post on how to set the rules up to save different emails or attachments to different folders.

Downloading entire emails (w/o attachments)

Save filename and format

Also, to download the body or download entire emails (even those without attachments), click the ‘Save as .eml‘ checkbox.

Also make sure the ‘Save inline content’ checkbox in the Global filters tab is checked (or if you are using individual account settings, pick the account in the Account dropdown and check the Save inline content in the Search tab).

This will save the entire email (including attachments) as .eml file. If you want just the .eml file, specific a filter in the rule (like we did for Subject) to include just .eml.

If you want to run actions but not save the .eml, just add a delete file action after saving the file.

Download actions

Next we can add download actions that are run after the attachment is saved.

Lets suppose that the document attached in the email was .docx and we want to covert it to a .pdf. This is possible by choosing Add action in the Actions after save section and then clicking on Document conversion menu item as shown below.

Then we have added the document conversion action and you can add a new conversion by clicking on Add conversion button. Once complete, you will see something like the below indicating that Any doc is now converted to a pdf.

doc conversion action added

Save the rule

Now click on the Save button. That’s it, you have created your first rule.

If you want this rule to only apply to a certain email account and not all accounts, you can specify a filter as we did with the Subject instead choose Account filter as explained below.

In the filters section of the Rule window, click Add -> Filters -> Account and choose the account from the dropdown. Then click Save.

Do this for each rule that applies to that account.

Create unlimited number of rules and actions

Similarly, you can create any number of email rules with different save locations and different actions.

This provides rich automation capabilities with ease and enables you to automate backend email to perform more complex tasks.

Multiple rules: Points to remember

email processing

TIP: Keep these in mind when defining multiple rules…

  • All rules are run for every attachment in the email and/or the .eml (if Save as .eml was checked).
  • All rules are run for any account that is selected in the Account dropdown (in the main program window). You can restrict a rule to a specific account by adding an Account filter and selecting the specific account in the dropdown inside the rule configuration.
  • Ordering: Rules are run from the top to down in ORDER they are defined. Drag and drop rules to move them order to affect the ordering.
  • If a Rule matches a given attachment or .eml, then no other rules below it are run for that attachment or .eml.
  • Emails without attachments can run actions as well, you will need to check the Save inline content checkbox in the Global filters tab AND check the Save as .eml checkbox inside the rule (next to the Save folder).
  • Actions in the rule are only run when there is a rules match and a file is saved. If you don’t want to save the file but want to run actions, just add a delete file action after saving the file in the rule.
  • PRO-Server: When making any config change, always uninstall and then re-install the service from the service tab.

Summary

This quick post shows how you can add many email accounts and many filters to handle simple automation tasks.

To see the full list of features or download actions the program supports check our PRO page and browse through features described there.

Further reading

Some interesting how-to links and posts for further exploration:

Contact us

Contact us if you have any questions, suggestions about the functionality described in this article.

Automate emails and integrate applications

This post explores how to extract data from emails, automate backend processes and hence reduce repetitive tasks. It also provides an overview of how to integrate LOB applications using some of the solutions provided on this site.

Automate email with attachments

What options do you have when it comes to automating emails?

Mail Attachment Downloader PRO versions offer a cost-effective solution to automating emails within your enterprise running as a service on a server or in the cloud through Windows Azure (PRO Server version required).

The way this is achieved is using rules for emails. You can setup many rules for the software based on your needs via the UI. These rules can be run for a single email account or across many accounts simultaneously.

Scheduled processing

Mail Attachment Downloader PRO Server lets you process incoming email on a scheduled frequency in the background 24×7 unattended as a Windows service.

It can recover from system restarts automatically, runs in the background even when no user is logged on and can also data center failure if a hot-standby is used to do so.

It can also be run in the cloud using Windows Azure if needed.

Ordering of rules

The rules defined in the program are run top-down for each email and attachment. The first matching rule is used to download any emails or attachments within the email. If no rules are defined, then all emails will be downloaded.

Phases of rule processing

The software breaks down processing emails into the following phases for each rule as shown.

email processing

 

  • Search and Filter phase: For each rule, you can specify which emails or attachments need to be processed by including search filters using the Add button -> Filters
  • Save files: Specify the format and location of where you want any files to be processed to be saved. This could be a temporary location if you do not want this data permanently stored. This could also include a file share (use UNC path).
  • Process email and files: This last phase is used to run the automatic processing and includes many different actions as shown below. These can include nested actions for example, unzip a file, decrypt a PDF, extract data and save the information to a database.

email actions

Multiple email accounts and filters

Once these are setup for a rule, you can enter many such rules. If you have multiple email accounts to process, you can restrict a rule to apply to only one email account if needed by using an account filter (Add -> Filters -> Account email in the rule).

SDK or API for email integration and processing

We now offer an SDK or plugin API to integrate with your backend systems in a more seamless manner. Contact us for more.

Common uses

  • Archive emails for further processing
  • Receive invoice data via email and need to save data for invoice processing
  • Save emails and integrate with ERP, EDI, eDMS, eCMS, document management systems or content management systems, eInvoicing invoicing software, Salesforce or medical systems
  • Use our PRO SDK (Software Development Kit) to integrate directly with your LOB applications.
  • Save emails or Excel or CSV attachments sent via email to an in-house or cloud database for further processing
  • Convert emails to PDFs or multi-page TIFF or over 50+ formats or merge/split PDFs including attachments to hand-off to other document management systems or medical software
  • Run custom in-house scripts after extracting attachments
  • Auto-respond or send email notifications when certain types of emails or attachments arrive and then take other actions

Conclusion: Automate emails, process and integrate applications

We have provided a brief overview of how to automate data from emails within your enterprise using an on-prem service or a cloud-based self-hosted service using Windows Azure using Mail Attachment Downloader PRO.

If you have a specific use-case that is not covered let us know or if you need help integrating your backend systems we may be able to offer consultation services to do so.

Further reading

Some interesting how-to links and posts for further exploration:

Contact us

Contact us if you have any questions, suggestions about the functionality described in this article.

Bulk download emails, attachments and save

Mail Attachment Downloader lets you bulk download attachments,  bulk download emails and archive or save them as eml, pdf, docx, tiff and more.

Saving emails and email attachments has never been easier. We offer a FREE version available on our website and also a PRO version that has additional capabilities that the FREE version does not.

Mail Attachment Downloader is NOT dependent on any installed email client such as Outlook and can work independently on a server if need be.

The FREE version lets you bulk download email attachments. The PRO version lets you bulk download both email attachments and emails (in .eml format or .txt or .html formats or .pdf or .docx or a .tiff multipage image).

If you want to save emails and attachments into a SINGLE PDF, you can do so as described in this blog post.

Bulk download emails as .eml and save

We will explore how to set this up using the  Mail Attachment Downloader PRO version.

  • Create a new rule filter by going to the Global Filters tab and clicking on Add a new filter.
  • Type in the rule name for the new filter.
  • In the Save area, check the Save as .eml checkbox as shown

    madpro3_saveemailbody
    Bulk download emails

This will bulk download emails as .eml files to the save folder.

In addition to the above, you can create many rules to only save certain .eml files like those that match a certain FROM email or a certain SUBJECT each out to different folders by creating a rule per save location.

Save emails and email attachments as PDF, DOCX or TIFF

If you want to have this .eml saved to a different format like PDF or DOCX or a multipage TIFF (the PRO Server supports over 50+ file formats), do the following:

  • In the Actions after save section, click on Add action -> Document conversion
  • Select the Document conversion entry if not already selected and click the Add conversion button

    convert to pdf
    archive emails
  • Select the From type as Any doc and the To type as PDF or TIFF or DOCX.

That’s it!

Now you have emails being saved to PDF or any other format as desired.

If you want only the .eml to be saved without the attachments, you can add a Filename filter and specify ‘.eml’ in the filter text box. This will only download the .eml’s without downloading the attachments separately.

If you want to save emails and attachments into a SINGLE PDF, you can do so as described in this blog post.

Automate bulk downloads

With the PRO Server version you can run the above setup 24×7 as a Windows Service and not have to worry about opening up the program every time you need to bulk download emails.

If you have any questions, please feel free to contact us.

Further reading

Some interesting how-to links and posts for further exploration:

Contact us

Contact us if you have any questions, suggestions about the functionality described in this article.

Nested email actions: unzip, convert or decrypt PDF and run a script

Setup email actions such as unzipping an email attachment, converting the email attachment to pdf and running a script easily with Mail Attachment Downloader PRO Server.

This post will show you how to setup a rule to Unzip a file, then convert the unzipped .docx or decrypt a .pdf and then run a script.

In the Actions section, do the following:

  1. Select ‘After saving attachment‘ from the tree view on the left. Note that even though this says ‘After saving attachment‘, you can run actions on the body of the email as well which will be downloaded as an attachment when you click on the ‘Save email text’ checkbox.
  2. Click on Add button -> After saving attachment -> Unzip files and select any options as shown below. You can enter which specific files you want to unzip in the box which can also include wildcards or regular expressions. If you have multiple, separate each file or wildcard by a new line.automate email actions: unzip_files
  3. Select Unzip files from the tree view on the left. This is necessary to create a sub action under unzip files so every unzipped file runs the remaining action. You can also specify which files to unzip in the previous step. Now click on Add -> After saving attachment ->  Document conversion. Fill in the conversion details by clicking on the Add Conversion button. Note: You can also choose to decrypt the unzipped file if the source file was a PDF by providing the password to decrypt the file.automate email actions: madpro3_convert
  4. Select Document conversion from the tree view on the left. Then Add -> After saving attachment -> Run command line. Enter details to run a command line. In this case we are running a .bat file with the filename of the converted file – {FILENAMEEXT} in the screenshot below now represents the converted filename now from the previous step and not the original saved filename. automate email actions: madpro3_pda_runbat

That’s it.

If you have questions or need additional actions, please contact us and we can help assess feasibility.

 

PDF to DOCX conversion and more

Convert PDF to DOCX easily with Mail Attachment Downloader PRO Server

When you run the server version you can run the program as a Windows Service that runs 24×7 unattended. Then just email the PDF as an attachment to your email and have Mail Attachment Downloader PRO Server pick it up and automatically download/convert the file and save it in the way you want it.

  1. Open Global filters tab and either click the Add new filter or Edit selected filter button
  2. If you are creating a new rule, just enter a meaningful filter name.
  3. Under Actions, click Add action and choose  Document conversion. This will add a new action in the list to the left. Click on the Document conversion list item under After saving file. You will see the conversions that are configured on the right side. convert to pdf
  4. Click on the Add conversion button.
  5. In the From Type select Any doc and the To Type specify docx. Click OK.PDF to DOCX
  6. Save the rule and that’s it!

Any email that you receive that has a PDF attachment (including some other related formats like LaTeX etc.) will be converted to DOCX.

If you receive encrypted PDF files, you can provide the decryption password in the PDF Decryption Password text box as can be seen in the screenshot in Step-5. You will need to do this before you can convert it to DOCX.

With the Mail Attachment Downloader PRO Server version, you can use it to convert emails (.eml or .msg or .txt or .html) and email attachments (text, html, word, excel, powerpoint and more) to over 50+ formats (bmp, csv, dif, doc, docm, docx, dot, dotm, dotx, emf, epub, excel, flatopc, flatopcmacroenabled, flatopctemplate, flatopctemplatemacroenabled, html, htmlfixed, jpeg, mhtml, mobixml, odp, ods, odt, openxps, ott, pdf, pdfnotes, png, potm, potx, pps, ppsm, ppsx, ppt, pptm, pptx, ps, rtf, spreadsheetml, svg, swf, tabdelimited, tex, text, tiff, tiffnotes, wordml, xamlfixed, xamlflow, xamlflowpack, xlam, xlsb, xlsm, xlsx, xltm, xltx, xml, xps)!

You can use this to convert from the following popular formats:

  • DOCX to PDF, PNG, JPEG, HTML and more
  • PDF to DOCX, PNG, JPEG, HTML and more
  • CSV, XLSX to PDF, PNG, JPEG, HTML and more
  • PPTX to PDF, PNG, JPEG, HTML and more
  • EML to PDF, DOCX, PNG, JPEG, HTML and more
  • JPEG, BMP, TIFF, images to PDF, DOCX, HTML and more

If you have any questions or suggestions, please contact support.

Convert emails to PDF or TIFF including email attachments

Save emails as PDF or TIFF

It is really easy to save emails to PDF or convert email attachments to PDF with the Mail Attachment Downloader PRO and Mail Attachment Downloader PRO Server.

Converting document attachments to PDF or TIFF

  1. Create a new filter or edit an existing one in the Global Rule tab
  2. Under Actions, click Add action and choose  Document conversion. This will add a new action in the list to the left. Click on the Document conversion list item under After saving file. You will see the conversions that are configured on the right side. convert to pdf
  3. Add a new document conversion by clicking the ‘Add conversion‘ button.
  4. Pick the source format (From Type) and the destination format (To Type).  If you are using the PRO Server, then you can pick any format in the To. Otherwise, you will be limited to just PDF.
    convert to pdf
  5. Click OK

That’s it!

Now each document attachment (doc, docx, txt, html, rtf, eml etc.)  will be converted to PDF or TIFF or any To Type you selected above.

If you want to also save the email body in addition to the attachments as PDF or TIFF, check the Save as .eml checkbox in the rule and the document conversion action (from Doc -> PDF or TIFF) will also convert the .eml file to PDF or TIFF. The .eml extension is considered a document for conversion purposes.

If you want to convert other types such as cells (xlsx etc.), slides (ppt etc.) or images (jpgs etc), you can repeat Step-3 to add the different From’s if you would like.

This will save each attachment as a separate PDF or TIFF files. Further below we show how you can save emails and attachments as a single PDF. You can also save emails and attachments to a multi-page TIFF if required by following the same instructions except select tiff as the To type.

You may also choose to encrypt the PDF file by checking the ‘Encrypt PDF‘ checkbox if needed.

Save emails and attachments to a single PDF

To save emails and attachments as a single PDF, you will need the PRO Server version and the following setup:

  • Make sure Save as .eml is checked, this will save the email body.save as email
  • Ensure Document Conversion action is added and includes conversions from various types to PDF as shown below. Check the delete source files after conversion checkbox.Convert to PDF
  • The above will save the body and attachments all separately as PDF files. You can skip the next step if that’s all you want to do (save as separate files).
  • To merge them into a single PDF: Right click on Document Conversion and then add Merge PDF files action. Check the delete all source PDFs checkbox.

    Merge PDFs
    Merge PDFs

Now emails along with attachments will end up being a single PDF where the email is the first few pages and subsequent pages are the attachments rendered as PDFs.

Over 50+ Formats

If you get the Mail Attachment Downloader PRO Server version, you can use it to convert emails (.eml or .msg or .txt or .html) and email attachments (text, html, word, excel, powerpoint and more) to over 50+ formats (bmp, csv, dif, doc, docm, docx, dot, dotm, dotx, emf, epub, excel, flatopc, flatopcmacroenabled, flatopctemplate, flatopctemplatemacroenabled, html, htmlfixed, jpeg, mhtml, mobixml, odp, ods, odt, openxps, ott, pdf, pdfnotes, png, potm, potx, pps, ppsm, ppsx, ppt, pptm, pptx, ps, rtf, spreadsheetml, svg, swf, tabdelimited, tex, text, tiff, tiffnotes, wordml, xamlfixed, xamlflow, xamlflowpack, xlam, xlsb, xlsm, xlsx, xltm, xltx, xml, xps)!

You can use this to convert from the following popular formats:

  • DOCX to PDF, multi-page TIFF, PNG, JPEG, HTML and more
  • PDF to DOCX, multi-page TIFF, PNG, JPEG, HTML and more
  • CSV, XLSX to PDF, multi-page TIFF, PNG, JPEG, HTML and more
  • PPTX to PDF, multi-page TIFF, PNG, JPEG, HTML and more
  • EML to PDF, multi-page TIFF,  DOCX, PNG, JPEG, HTML and more
  • JPEG, BMP, TIFF, images to PDF, DOCX, HTML and more

Further reading

Some interesting how-to links and posts for further exploration:

Contact us

Contact us if you have any questions, suggestions about the functionality described in this article.

Save emails and attachments to a database

Save emails and attachments to a database (SQL Server)

In this post, we will explore saving emails and attachments to a database server like SQL Server by setting up an ODBC data source and using a post download Action to save contents of the email and/or attachments to a database.

The program supports and works with any compatible ODBC data source such as MySQL, Oracle, PostgreSQL and more. This post only explores setting up to save the data in SQL Server but also has information on how to tweak it for other database types.

An overview — emails to databases

The feature of saving emails to databases is just one of the features available with the Mail Attachment Downloader PRO Server version.

Each rule can be setup to save emails to databases using either generated SQL (to one or more tables) or a custom SQL.

You do not need to know SQL to save emails or attachments to a database. And if you do know SQL, it offers the flexibility and customizability to modify the SQL statements to suit your needs.

You can even include extracted data from emails or attachments using custom variables in your SQL statement and save them to a database!

Each rule has several phases — first, search and filter through emails or attachments, then extract data from emails or attachments, saving email bodies or attachments to a customizable file or folder format if needed and lastly post-process the emails or attachments by saving them to a database of your choice.

email processing

Used by many Fortune 500 companies today to save emails and attachments to databases.  Runs 24×7 in the cloud or on-premise as a Windows Service.

You get a versatile tool that provides flexibility in storing emails to databases in just the way you want to.


Step-by-step tutorial — emails to databases

Setting up a datasource

  1. Let’s start off by adding a new data source —  click on the Database tab -> Add ODBC source buttonDatabase Source
  2. Provide a name for the source first. Then pick either the 32-bit ODBC driver or 62-bit ODBC driver (depending on whether you installed the 32-bit or 64-bit version of Mail Attachment Downloader PRO Client or PRO Server).In our case, the driver “SQL Server” from the drop down indicates the 32-bit driver.  Then enter the Connection string that specifies how to connect to the server:Server=<computer name>\<SQL Server name>;Database=<DB name>;Trusted_Connection=yes;

    The above connection string is specific to SQL Server that is using a trusted connection. To connect in any other way to SQL Server OR to another database like Oracle, you can find ODBC connection strings here (make sure you select ODBC connection string and not any other on the site).

    An example of these filled in is shown below:
    Server=TESTPC\GEARMAGE;Database=TestDB;Trusted_Connection=yes;

    DBDetails2

  3. Click Test Connection button to make sure this succeeds. Then click OK.
  4. At this point a data source has been setup.

Rule configuration to save the email to a database

  1. Then create a new rule or edit an existing rule from the Global filters tab.
  2. Under Actions after save click Add action and then choose Save to database. This will add an action under After saving file in the list to the left.
    NOTE: The screenshot below shows other actions as well, if you have other actions you can chain or nest the save to database action after those actions have taken place as shown below.

    Save to DB

  3. Pick the Source as the one you provided in Step-2.
  4. Specify a new table name (or an existing one) and then click “Create Table” if this is a new table and follow the prompts.  At this point a new table schema would be created and the SQL would be automatically filled in based on the questions you answered.
  5. Click “Test SQL” to test connectivity and table row creation, this will add a new row to the table to make sure everything is setup correctly.
  6. Click the Save button to save the new rule with the Save to DB action.
  7. Now you can click the Connect And Download button to test out the ability to save to DB.

That’s it!

You have setup the program to automatically save emails and attachments to a database.

IMPORTANT CONSIDERATIONS

  1. Make sure you select either the 32-bit ODBC driver or the 64-bit ODBC driver in the dropdown depending on which installation of Mail Attachment Downloader PRO Client or PRO Server you installed (license email has links to both versions of the install). This is supported in all Windows versions including Windows 10. In some cases default installations may only install the 64-bit driver and you may need to manually download and install the 32-bit ODBC driver for your database. Please consult the database documentation and Google on how to do this.
  2. Your specific connection string can vary depending on the type of database (for example, Oracle has different connection strings than MySQL). A useful site to help you with the ODBC connection string is https://www.connectionstrings.comMake sure you only choose the ODBC connection string in the site  for your database type (like Oracle). You may need to play around with the different strings and test connections to find the one that works. If your connection string includes a Driver name, make sure it matches exactly (space for space) the one you have picked in the dropdown.
  3. Depending on the type of DB you use, the automatic creation of table/sql may fail. In that case, you might have to provision the schema for the table in the DB manually and then specify the SQL to insert records into the table in the program.
  4. You can save the attachment content using the following variable in your SQL
    {RAW_CONTENT}

Further reading

Some interesting how-to links and posts for further exploration:

Contact us

Contact us if you have any questions, suggestions about the functionality described in this article.

v3.1 PRO packs many new features

Extract emails and attachments, save to database, save email as PDF and more

We have introduced many new compelling features with the Mail Attachment Downloader PRO v3.1 release. Here is a quick overview of those features. We will have more detailed information about how to use these features in upcoming blog posts so stay tuned.

Before we begin, a quick note about the key differences between PRO Server and PRO licenses:

  • Our PRO Server versions let you perform automated tasks 24×7 on an unlimited number of email accounts and can run on Windows Server (and Windows Client).
  • Our PRO and PRO Limited versions cannot run on Windows Server and requires a user to be logged in when processing email attachments.

With v3.1 we have started to introduce more powerful email automation and processing features. Some of these are detailed below:

  • Convert email attachments after download to PDF
  • Encrypt or decrypt PDF email attachments automatically
  • Automatically print email attachments
  • Upload email attachments to Sharepoint online or on-prem

If you get the PRO Server, you get some even more powerful features and support for unlimited email accounts.

  • Automatically unzip email attachments and run rules (for example, unzip PDF file, then decrypt PDF and print it automatically!)
  • Automatically save email headers and optionally attachments to a database (which fields you save and how you want it saved are completely customizable).
  • Convert email attachments (text, html, word, excel, powerpoint and more) to over 50+ formats (bmp, csv, dif, doc, docm, docx, dot, dotm, dotx, emf, epub, excel, flatopc, flatopcmacroenabled, flatopctemplate, flatopctemplatemacroenabled, html, htmlfixed, jpeg, mhtml, mobixml, odp, ods, odt, openxps, ott, pdf, pdfnotes, png, potm, potx, pps, ppsm, ppsx, ppt, pptm, pptx, ps, rtf, spreadsheetml, svg, swf, tabdelimited, tex, text, tiff, tiffnotes, wordml, xamlfixed, xamlflow, xamlflowpack, xlam, xlsb, xlsm, xlsx, xltm, xltx, xml, xps)

For a full feature breakdown by PRO license type go here.

Have questions about these features or found an issue? Contact us at support@gearmage.com (this is the fastest way to receive support).

As always, we enjoy hearing your feature requests, send them to features@gearmage.com.