Find solution
How to email attachments?

How do I automatically extract data from email attachments?

  • I am using Outlook and I receive regular emails with attachments (csv, excel...). I would like to automate data extraction from the email attachments, i.e. copy the data from the attachments and paste it to a master file.

  • Answer:

    Disclaimer: I'm the founder of https://mailparser.io?utm_source=quora It's difficult to give a precise answer with the information provided in the question. Assuming that the files are having an identical format all the time, it should be possible to automate your data extraction process.I would say you have the following options for automating the task: Write a Makro in Excel which extracts the data you are looking for Automate your Desktop computer with a software like Automator for Mac Search for a software which is specialised in automatically processing spreadsheets and manually import your files each time you receive an e-mail (e.g. TaskPipes) Use an e-mail parser software which supports file attachment processing If you go for an email parsing solution, chances are high that you can set up a fully automated process which doesn't require any manual work once set up. An email parser can fetch the e-mail for you, process your file attachment according to custom rules and give you exactly the data you need.Another important question is what you want to do with the extracted data. e.g. you want it in form of another Spreadsheet, you want to push it to your CRM, you want to send out personalised e-mails based on the extracted data, etc.If you like, have a look at our solution https://mailparser.io?utm_source=quora. Our software allows you to automatically process incoming e-mails (and their file attachments) and then automatically copy your extracted data to another software or a spreadsheet.For a full list of email parsers, check out my previous answer here:

Moritz Dausinger at Quora Visit the source

Was this solution helpful to you?

Other answers

Look at G-Lock Email Processor. It is developed to process incoming messages. Also, it can automatically parse email attachments such as CSV, Text and PDF attachments and extract data from them. You can set it to save extracted data to a text file or write it to the database. You can read more about how G-Lock Email Processor can extract data from email attachments here: http://www.glocksoft.com/email-automation-software/parse-csv-attachment-to-database/

Julia Gulevich

Disclaimer: I am the co-founder of TaskPipes. http://taskpipes.com allows you to extract data directly from email attachments, including Excel files, CSVs, Word docs, PDFs and more. You can set up automated email forwarding in your inbox to forward such emails to a unique TaskPipes email address. TaskPipes will then receive the emails, parse the data in the attachments, which will be manipulated and cleaned according to user-defined rules. It can then be exported to a final location, like a Google spreadsheet or API endpoint.

Fraser Atkins

Assuming that “Outlook” in this context refers to the Outlook application running on a PC, then you can do this with a bit of macro programming. The macro would save the attachments to disk and then open them in Excel. It would then copy data from that attachment to a master file. It’s not too difficult to do so long as you can articulate a condition for detecting the messages with the subject attachments and ignore all other messages with Excel attachment, and so long as the attachments are consistently and correctly formatted. I can supply some sample code if you can share details describing how you want this to work.

David Lee

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.