Solved

Outlook Macro

Posted on 2008-10-23
1
278 Views
Last Modified: 2010-04-08
Hi.

I want to create a macro in outlook that will:

1. look for new incoming mail from a specific address with specific subject ("invoices").
2. Open the PDF attachment in Acrobat, OCR the file, search for a specific number on one part of the page (top right corner within one inch of the edge of the page).
3. use the number found there to rename the file name.
4. save the file in a specific local folder.

Am I insane to think that a macro can do this?  I;m pretty new to macros so don't really know how to write VB Script.  If possible, how do i do it?
0
Comment
Question by:colin911
1 Comment
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 22787700
Hi, colin911.

Requirement #2 is the one that'll be a problem.  Outlook can launch Adobe and open the PDF attachment, but OCRing the content, searching for a specific number, and returning that number is beyond Outlook's native capability.  It can probably be done, but it'll require external libraries (i.e. DLLs) and skill in using them to make this happen.  I can show you how to do 1, 3, and 4, but 2 is a serious challenge.  It's going to take time and tools.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you don't know how to downgrade, my instructions below should be helpful.
Find out what you should include to make the best professional email signature for your organization.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question