?
Solved

Outlook Macro

Posted on 2008-10-23
1
Medium Priority
?
284 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 76

Accepted Solution

by:
David Lee earned 1500 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This article will help to fix the below errors for MS Exchange Server 2013 I. Certificate error "name on the security certificate is invalid or does not match the name of the site" II. Out of Office not working III. Make Internal URLs and Externa…
We aren’t perfect, just like everyone else.  Check out the email errors our community caught and learn the top errors every email marketer should avoid.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
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…
Suggested Courses

770 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