Solved

Outlook Macro

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

Are end users causing IT problems again?

You’ve taken the time to design and update all your end user’s email signatures, only to find out they’re messing up the HTML, changing the font and ruining the imagery. What can you do to prevent this? Find out how you can save your signatures from end users today.

Join & Write a Comment

Learn more about how the humble email signature can be used as more than just an electronic business card. When used correctly, a signature can easily be tailored for different purposes by different departments within an organization.
Get an idea of what you should include in an email disclaimer with these Top 5 email disclaimer tips.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
The purpose of this video is to demonstrate how to set up Lists in Mailchimp. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchimp account. : Click on Lists. Click on Create List Button : Choose the desi…

708 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

15 Experts available now in Live!

Get 1:1 Help Now