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.
Similar threads
Thread starter Title 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
R Notify calendar of other users Outlook VBA and Custom Forms 7
kkqq1122 How would I add Search for attachment name Outlook VBA and Custom Forms 3
Owl Export Outlook PDF Attachment as JPG? Outlook VBA and Custom Forms 3
Timmon Remove just one attachment before AutoForward Outlook VBA and Custom Forms 0
P File Picker for attachment Outlook VBA and Custom Forms 0
D Forwarding email based on the attachment file type and specific text found on the attachment file name Outlook VBA and Custom Forms 1
N File Picker for attachment Outlook VBA and Custom Forms 2
G print attachment straight away; working script edit not working Outlook VBA and Custom Forms 0
G Save attachment run a script rule Outlook VBA and Custom Forms 0
M Autoforward just attachment OR just body. Outlook VBA and Custom Forms 0
D Create new email from the received Email Body with attachment Outlook VBA and Custom Forms 10
T vba extract data from msg file as attachment file of mail message Outlook VBA and Custom Forms 1
K Outlook Office 365 VBA download attachment Outlook VBA and Custom Forms 2
P Sending email from outlook IMAP to GMAIL where embedded images are added as attachment Using Outlook 1
S save attachment with date & time mentioned inside the file Outlook VBA and Custom Forms 0
O VBA Outlook Message Attachment - Array Index Out of Bounds Outlook VBA and Custom Forms 0
A Edit attachment Save and Reply Outlook VBA and Custom Forms 0
D Move Email with Attachment to Folder Outlook VBA and Custom Forms 3
B Outlook 2010 Opening Mail Attachment Using Outlook 2
A Warning When Opening attachment Using Outlook 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

Similar threads

Top