Solved

Outlook Macro

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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

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…
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
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…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

830 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