How would I add Search for attachment name

kkqq1122

kkqq1122

New Member
Outlook version
Outlook 365 64 bit
Email Account
Office 365 Exchange
What do I need to add to search for all below but add attachment name?

Private Sub objInboxItems_ItemAdd(ByVal Item As Object)
Dim objForward As Outlook.MailItem

'see if it is running
msgbox item.subject

If TypeOf Item Is MailItem Then
If (item.SenderEmailAddress = "sender@test.com") And (item.Subject = "Test") Then
 
kkqq1122

kkqq1122

New Member
Outlook version
Outlook 365 64 bit
Email Account
Office 365 Exchange
Diane Poremsky said:
Try using hasattachments:Yes and attachment:test

You may not need to use hasattachments - but it might make it a little faster.
Click to expand...
How would you that into VBA code though to have it search for sender, subject and attachment name?
Private Sub objInboxItems_ItemAdd(ByVal Item As Object)
Dim objForward As Outlook.MailItem

'see if it is running
msgbox item.subject

If TypeOf Item Is MailItem Then
If (item.SenderEmailAddress = "sender@test.com") And (item.Subject = "Test") Then
 
Diane Poremsky

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
That would be using search or filter. If the keyword is in the attachment subject, you could use a simple IF statement, but to search the file, you need to use a filter or find / restrict.

txtSearch = "folder: (Inbox) shasattachments:Yes attachment:test"
Application.ActiveExplorer.Search txtSearch, olSearchScopeAllFolders

More info on searches here -
www.slipstick.com

How to Create a Unified Inbox View

How to use create a Unified Inbox filter in Outlook 2010 or Outlook 2013 using VBA and a search query. Turn any frequently used search into a macro.
www.slipstick.com www.slipstick.com
 
You must log in or register to reply here.
< Macro to block senders domain | Automatically Insert Recipient Name from To Field >
Similar threads
Thread starter Title Forum Replies Date
B When I add more search strings to RULES, it is not processing them Using Outlook 3
A Recommend add-on or utility enabling quick Google search within Outlook Using Outlook 7
S Add Search Criteria Using Outlook 1
N The add-in "C:\program files\google\google desktop search\googledesktopO..." could not be installed Using Outlook 32
K Add an entry to a specific calendar Using Outlook 0
F Add a category before "Send an Email When You Add an Appointment to Your Calendar" Outlook VBA and Custom Forms 0
J Want to create a button on the nav bar (module add-in) to run code Outlook VBA and Custom Forms 2
M "Attachment Detacher for Outlook" add in, does it update the server copy of the email? Using Outlook 1
J Outlook 365 Add keywords from Listbox to the message body where cursor is placed Outlook VBA and Custom Forms 0
O Add Day Number of the year for 2023-2033 Outlook VBA and Custom Forms 5
J GoDaddy migrated to Office365 - Outlook Wont Add Account Exchange Server Administration 21
F Outlook 2019 Outlook 2019 Add and Sync to New computer Comcast server Using Outlook 2
Witzker Add a text line at the end of the note field in all selected Contacts Outlook VBA and Custom Forms 7
A iCloud Outlook Add In is causing Outlook 2021 to crash and got disabled Using Outlook 10
N How to add or delete items to Move dropdown Menu Using Outlook 0
G Add contacts birthday to calendar Using Outlook 4
V How to add 'Previous Item' and 'Next Item' to the Quick Access Toolbar Using Outlook 1
Commodore Safe way to add or update holidays; Windows Notifications issue Using Outlook 8
L did MS ever add way to text via Outlook Using Outlook 5
P How to add a column named categories when searching in Outlook Using Outlook 0
M add new attendee to existing meetings with VBA Outlook VBA and Custom Forms 5
N Can't create NEW GROUP and add/remove a member from existing Group in Outlook Using Outlook 1
Witzker Outlook 2019 Pls. add a Prefix for OUTLOOK 2019 here Using Outlook 1
P Add inanimate objects to meetings? Using Outlook 1
O Outlook 2010 Add delete button to the side of the message list Using Outlook 1
BartH Add a string to the conditions in .Conditions.BodyOrSubject.Text Outlook VBA and Custom Forms 2
A "Get Add-Ins" - Which Version of Outlook to use Using Outlook 1
D Do I need Exchange Add-In? Using Outlook 6
C-S-R Manage Add-ins (Remove Wunderlist) Using Outlook 6
A iCloud add in problems Using Outlook 4
L Macro to add Date & Time etc to "drag to save" e-mails Outlook VBA and Custom Forms 17
C Looking for feedback on new Outlook Add-in Using Outlook 0
L isn't there an OL add-on that flags addressee before sending Using Outlook 3
S Add VBA save code Using Outlook 0
P Shortcut Pane - add shortcut to Office365 group mailbox Using Outlook 1
Z Add ComboBox Value to Body of Email Outlook VBA and Custom Forms 1
G How to add a folder shortcut to outlook quick access toolbar? Using Outlook 6
G Add to Outlook Contacts - Point to non-default contacts folder Using Outlook 0
M Automatically add senders first name to a greeting Outlook VBA and Custom Forms 1
C Add Form to Appointments Received, Automatically Outlook VBA and Custom Forms 6
O Outlook tasks - Add text column with multiple lines Using Outlook 3
W April 2020 Office 365 Update - Add-Ons fail after Office 365 Update Using Outlook 6
Z Task Filter Not Working When I add too many criteria Using Outlook 0
D Add date next to day name in Outlook Today calendar view Using Outlook 1
D iCloud Add-in not working in Outlook 2013 and Outlook 2016 After Windows Upgrade & iCloud Upgrade Using Outlook 2
P Add Paste Unformatted to QAT Using Outlook 1
M Ignore slow add-ins Using Outlook 0
B Add Prefix text to Subject Line Using Outlook 1
Jennifer Murphy Add birthdays to calendar Using Outlook 7
Z Add text to auto-forwarded e-mail Outlook VBA and Custom Forms 4

Similar threads

Top