Notify on attachment content

Status
Not open for further replies.
U

U3BhY2VDYW1lbA

I receive email with a word attachment every day. I am only interested when

the document contains certain words. Is there a way via VBA to automatically

open the doc, scan for the word and notify if present.

Thanks,
 
K

Ken Slovak - [MVP - Outlook]

You would need to save the attachment to the file system as a document file

and then open it and parse it using the Word object model.

When you manually open an attachment from Outlook that's exactly what

Outlook does. It saves the attachment in a temp folder and opens it based on

what program is registered in Windows to handle that file extension.

"SpaceCamel" <SpaceCamel> wrote in message

news:EB09FDD5-ECF2-4002-9C61-0CA7E3793472@microsoft.com...
> I receive email with a word attachment every day. I am only interested
> when
> the document contains certain words. Is there a way via VBA to
> automatically
> open the doc, scan for the word and notify if present.
> Thanks,
 
U

U3BhY2VDYW1lbA

OK, Got it to work.

Rule moves msg to folder and start macro.

Macro saves attachment to folder, opens doc, scans for text

if finds text then it sends me another email

Thanks,
wrote:


> You would need to save the attachment to the file system as a document file
> and then open it and parse it using the Word object model.

> When you manually open an attachment from Outlook that's exactly what
> Outlook does. It saves the attachment in a temp folder and opens it based on
> what program is registered in Windows to handle that file extension.

> >

>

> "SpaceCamel" <SpaceCamel> wrote in message
> news:EB09FDD5-ECF2-4002-9C61-0CA7E3793472@microsoft.com...
> >I receive email with a word attachment every day. I am only interested
> >when
> > the document contains certain words. Is there a way via VBA to
> > automatically
> > open the doc, scan for the word and notify if present.
> > Thanks,


>
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
J Ability to notify attendees when canceling past meeting is gone Using Outlook 1
Y How do I notify a colleague about a new Opportunity BCM (Business Contact Manager) 2
D Envelope notify when new mail arrives Using Outlook 1
D Notify Outlook contacts of my new Outlook email address??? Using Outlook 1
C Notify owner of shared calendar of new events created. Exchange 2010 / Outlook 2010 Using Outlook 6
S Notify recipient of assigned task in Business Contact Manager by email Using Outlook 4
R Notify calendar of other users Outlook VBA and Custom Forms 7
R Limiting length of saved attachment in VBA Outlook VBA and Custom Forms 2
F Script for zip file attachment Outlook VBA and Custom Forms 1
P Outlook 2013 Word Share doc as Email Attachment now brings up Eudora. Using Outlook 1
L Attachment saving and tracking - PLEASE help! Outlook VBA and Custom Forms 5
H Outlook 2003 find by "has attachment" Using Outlook 1
9 Outlook 2016 How to save an Outlook attachment to a specific folder then delete the email it came from? Using Outlook 1
J Add an Attachment Using an Array and Match first 17 Letters to Matching Template .oft to Send eMail Outlook VBA and Custom Forms 2
geofferyh Cannot get Macro to SAVE more than one message attachment??? Outlook VBA and Custom Forms 5
geofferyh How to change the Attachment File Name? Outlook VBA and Custom Forms 1
geofferyh Outlook 2010 How to Copy Outlook Attachment to a Specific Folder? Outlook VBA and Custom Forms 3
D Body text of email disappears when I scan an attachment from printer to email Using Outlook 1
J Help Please!!! Outlook 2016 - VBA Macro for replying with attachment in meeting invite Outlook VBA and Custom Forms 9
W Save Outlook attachment in network folder and rename to current date and time Outlook VBA and Custom Forms 18
D Autosave Attachment and Rename Outlook VBA and Custom Forms 1
N Macro for attachment saved and combine Outlook VBA and Custom Forms 1
Andrew Quirl Open attachment, manipulate without add-on program? Outlook VBA and Custom Forms 5
V VB script code to save a specific email attachment from a given email Outlook VBA and Custom Forms 14
Commodore Attachment icon when there is no attachment Using Outlook 3
V Saving attachment from outlook in My Documents Outlook VBA and Custom Forms 14
N automatic response with an attachment based on the subject line Outlook VBA and Custom Forms 1
J Auto Forward - Include Attachment and change Subject depending on original sender Outlook VBA and Custom Forms 3
M Search for attachment filename Using Outlook 0
E Open olNoteItem Attachment Outlook VBA and Custom Forms 6
Vijay Reply all by attachment name Using Outlook 10
Michael R Belleville Making an Attachment Name the Message Subject Using Outlook 2
N Paste content to Excel when .txt file (attachment) is opened Outlook VBA and Custom Forms 1
P Outlook Randomly Not attaching (attachment file) Using Outlook 0
S VBA to search a keyword in attachment and move to a folder Outlook VBA and Custom Forms 0
Diane Poremsky The Attachment Size Exceeds the Allowable Limit Error New Slipstick.com Articles 0
B VBA Help Email that will save as draft and send as attachment Outlook VBA and Custom Forms 3
O Maker Checker - Colleague to authorise attachment Using Outlook 0
C Outlook Attachment List in Reply Header Using Outlook 3
B Auto Preview Attachment in Inspector Reading Pane Outlook VBA and Custom Forms 1
Randy Redekopp Outlook 2016 attachment content search Outlook VBA and Custom Forms 2
A OL16 C2R attachment preview fails Using Outlook 8
R Print email message and attachment in order Outlook VBA and Custom Forms 2
RalphG101 No indication of attachment, when selecting file, send to outlook. Using Outlook 0
A Auto Insert of filename when selecting 'Remove Attachment' Using Outlook 1
A "untitled attachment" if file name contains eg. special character Using Outlook 1
Mark Foley Emailing attachment from Word/Excel sends attachment but no message body Using Outlook 0
peacepanda How to save attachment looking at the attachment name Outlook VBA and Custom Forms 1
Diane Poremsky Add Attachment Names to Message Before Sending New Slipstick.com Articles 0
K Outlook send emails without attachment to a list Using Outlook 1
Similar threads


















































Top