Solved

Outlook Macro

Posted on 2008-10-23
1
276 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
domain listed in spamhaus.org 2 47
Outlook Calendar Permissions 4 39
exchange2010 test connectivity error 4 32
restore emails from public folder 2 19
What does UTC stand for?  “Coordinated Universal Time” – Think of this as the true time on Planet Earth that never changes with the exception of minor leap seconds here and there to account for the changes in the planet's rotation.   What does th…
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
In this Experts Exchange video Micro Tutorial, I'm going to show how small business owners who use Google Apps can save money by setting up what is called a catch-all email address in their Gmail accounts. By using the catch-all feature, small busin…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

867 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now