Checking attachments as they arrive

Status
Not open for further replies.
B

ben

Every time one (or more) e-mails arrive I need to be able to check the name

of an attachment and if it contains certain words, we'll just use example

as the word for this, I want to mark it as read and move it to a folder. I

can use either a rule or vba. The problem I'm having with the rule is that I

don't see one that will read the attachment name as new mail arrives. With

vba the only possible way I can see to check attachments is to loop through

each and every e-mail in the Inbox instead of just unread mail. This isn't

quite possible as the user I am creating this for has about 65,000 e-mails in

his inbox over 7 years and would be quite adverse to changing his system. I

can fire the newmail or newmailex event, but I can't find a way to filter

attachments from only Unread mail. Any suggestions? I could probably even use

a .find .findnext loop but can't locate the syntax for unread mail.

When you lose your mind, you free your life.
 
B

ben

Anyway, so after a couple more hours of searching I discovered the simple

fact that I can set outlook to run a script from a rule, so now I just have

it running my attachment checking script on each new e-mail as it arrives.

"ben" wrote:


> Every time one (or more) e-mails arrive I need to be able to check the name
> of an attachment and if it contains certain words, we'll just use example
> as the word for this, I want to mark it as read and move it to a folder. I
> can use either a rule or vba. The problem I'm having with the rule is that I
> don't see one that will read the attachment name as new mail arrives. With
> vba the only possible way I can see to check attachments is to loop through
> each and every e-mail in the Inbox instead of just unread mail. This isn't
> quite possible as the user I am creating this for has about 65,000 e-mails in
> his inbox over 7 years and would be quite adverse to changing his system. I
> can fire the newmail or newmailex event, but I can't find a way to filter
> attachments from only Unread mail. Any suggestions? I could probably even use
> a .find .findnext loop but can't locate the syntax for unread mail.

> > When you lose your mind, you free your life.
>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
L Checking Sender Email Address for trusted domain from list on intranet Outlook VBA and Custom Forms 4
V Checking for empty field Outlook VBA and Custom Forms 2
S Problem Checking the available stores in my Inbox (Outlook VBA) Outlook VBA and Custom Forms 0
M Account sequence when checking mail Using Outlook 6
T Checking mailbox emails Outlook VBA and Custom Forms 0
B Auto name checking upon Tab or Click off To field(s) Using Outlook 19
S Checking attachment is passward protected or not before sending the mail Using Outlook 1
S Outlook Macro for checking the mail is sent to outside organization Using Outlook 3
J Checking PST File Keeps Crashing Using Outlook 2
L Script to: Change subject of email after checking body Using Outlook 2
H Redirection checking Exchange Server Administration 10
S Stop mail checking Using Outlook 5
B Too many ' tasks' when checking email Using Outlook 1
Commodore PDF attachments started to open in Edge Using Outlook 0
T Outlook 2021 Cannot open attachments Outlook DeskTop 2021 Using Outlook 0
D ISOmacro to extract active mail senders name and email, CC, Subject line, and filename of attachments and import them into premade excel spread sheet Outlook VBA and Custom Forms 2
witzker Outlook 2019 Macro to answer a mail with attachments Outlook VBA and Custom Forms 2
P Print attachments automatically and move the mail to an existing folder called "Ted" Outlook VBA and Custom Forms 4
G Schedule recurring email and attachments display Outlook VBA and Custom Forms 3
G Save and Rename Outlook Email Attachments Outlook VBA and Custom Forms 0
L Macro/VBA to Reply All, with the original attachments Outlook VBA and Custom Forms 2
A Attachments.Delete Outlook VBA and Custom Forms 3
M Deleting attachments does not reduce file size Using Outlook 0
L unblocking attachments before sending Office 365 Advanced Protection Using Outlook 0
I Saving attachments from multiple emails and updating file name Outlook VBA and Custom Forms 0
R Use an ItemAdd to Save Attachments on Arrival Outlook VBA and Custom Forms 0
shrydvd vba to secure zip attachments Outlook VBA and Custom Forms 3
R fetching blocked attachments Outlook VBA and Custom Forms 0
H Outlook 2016 sent over 30 copies of an e-mail with attachments Using Outlook 1
W Automatically open attachments without automatically printing them Using Outlook 0
O Save attachments using hotkey without changing attributes Outlook VBA and Custom Forms 1
T Outlook converts sent email to txt attachments when sync Using Outlook 0
Nadine Rule to move attachments with specific name Outlook VBA and Custom Forms 1
R Outlook is NOT removing attachments. Using Outlook 4
Dan_W Nested email attachments Outlook VBA and Custom Forms 4
M Print email and, attachments sent in hyperlinks in the email Outlook VBA and Custom Forms 2
W Save and rename outlook email attachments to include domain name & date received Outlook VBA and Custom Forms 4
S DRAGGING MAIL AND ATTACHMENTS TO CALENDAR Using Outlook 1
D Print attachments automatically and moves the mail to a new folder Outlook VBA and Custom Forms 9
G Download pdf attachments only if email subject has one of words Outlook VBA and Custom Forms 8
D Saving Selected Emails as PDF and saving Attachments Outlook VBA and Custom Forms 6
R Quick Access view in File Explorer when saving attachments Using Outlook 0
J Save E-mail attachments in a specific folder Outlook VBA and Custom Forms 0
broadbander Needing help with reply/reply all while keeping attachments and adding a new CC recipient. Outlook VBA and Custom Forms 5
I Forwarding attachments in email received Outlook VBA and Custom Forms 3
A Outlook - Send New 20 Attachments through Email Using Outlook 4
D Print Attachments only in selected emails using a macro Outlook VBA and Custom Forms 3
M Outlook 2016 msg attachments Using Outlook 0
N Saving And Deleting Outlook Attachments with Unknown Error Message Outlook VBA and Custom Forms 1
M Macro for attachments download adjustment Outlook VBA and Custom Forms 3

Similar threads

Top