Excel VBA Introduction Part 29.13 - DASL Filters in Outlook

By Andrew Gould

[josueprado]

You're the smartest person I've ever met on YouTube, congratulations and thank you very much for all the help you offer with your channel, thanks to you I'm managing to solve many problems that are specific to my work, I don't know of another channel with such vast content as its about Outlook with VBA, i'm your fan!

[ksoonsoon]

One of the most helpful videos I have ever watched. Have been trying to figure out much of this for a long time. THANK YOU

[Gazarodd]

Hello,
I would like to thank you very much as i was able to finish my project thanks to your video

[MasterChelsea]

Great video, sir!
Thank you!
Can anyone tell me please, how to OPEN the excel attachment in this case??? I can’t figure it out…((((

[kashifkhanspecial]

Hi Andrew,

I don’t have any special word how can I thank you I have been searching this for a while, thank you much for this awesome video tutorial, I have question though if a subject line has text with apostrophe mark like “hi this mail’s is important” like that as u can see that this subject line has apostrophe, can dsl filter will search also.

Thanks
Kashif

[praveenj]

Hi very helpful tutorial, could you please help. I want to skip the mail which contains recall subject

[shinrafahell]

Hi Andrew, is there any way to search inside the attachments? Thanks for the tutorial!

[AB-stts]

With many thanks for your helpful tutorials, they are perfect!
I am wondering does this tutor have any learning course available on websites so that people can buy a complete collection?!

[krn]

Thanks Andy. Having not researched the meaning of DASL yet, I was curious now... what does DASL stand for? I thought you were going to define the acronym any minute, but I was incorrect. LOL.

[sayanghosh]

Please advise if the subject string is an user input and saved in a variable then how to pass the variable while constructing the filter string.

[CROW]

dear, how to query mail sender "Mail Delivery Subsystem" Or Subject "undeliverable: ? after send email but system return mail delivery => how to check or not ?

[ganeshs]

Hi Andy. Very good tutorial. I am facing a situation where I have to create send Outlook events, and if the source data has a meeting that is already created and the data is updated. The macro should automatically update the changes and send update. Here I am currently identifying the meeting item by restricting subject and start date. But wanted to know is there a way to find the meeting item using the global appointment ID. This will be captured and saved on a separate sheet once a new meeting is created along with other details. Just was wondering is there's a method or a way to restrict global appointment ID. Thanks

[efernandes]

Great video Andrew. I am glad I found your tutorials. I've been learning quite a lot, thanks.
Suppose I've a custom ribbon tab with buttons that run some macros, and one of the buttons runs a macro that apply one of these DASL filters. How can I show the applied filter in the current view?

[praveenj]

Hi could you please help me how skip mail which subject contains recall and goto next Outlook mail.i am looking forward

[darylenetay]

Hi, these tutorials have helped me greatly in my project!
One question, is it possible to use the DASL filter to filter out emails based on user input fields? E.g. user inputs keywords found in the subject and DASL filter is able to filter out these emails? Many thanks!

[johnabram]

Hi Andrew, I am getting stuck assigning variables in the DASL string instead of hardcoding. @ 14:29 instead of looking for %microsoft%, I want to use a value from the worksheet, store it in a variable and use it like %variable&? Could you please reply?

[ivanonanga]

I am from a french spoken country and in french when you are speechless you just say: "Oh!"

[ganeshs]

While automating outlook through excel. There are some warning messages and pop-ups. Is there a way to bypass these or handle them? Example when sending a message without a subject, or when a meeting's time is changed there are pop-ups. Please help am stuck with this issue.

[prasantha]

Hi Andrew, Thank You so much for your valuable time.

i need your help on the below scenario

set fol =

PROJECT is the subfolder name I have mentioned as per my convenient.

My requriment is

set fol = & sheet1.Range("A1").value

in A1 = PROJECT

Is there any possible way to provide user for their own Subfolder name under Inbox

[kashifkhanspecial]

Hi Andrew,
Thank you so much for this tutorial, I need you help regarding a vba code for outlook mail.
Problem:- I need to loop each mail in the Inbox where Category is blank, then read that mails, email address and then search that email address in the sql server data base, and whatever the rows (will return outlook folder names) returns, that mail will go to that folders, the problem is that, because I am looping in a "Inbox" folder where new mail comes in every second and if the new mail comes in between the loop some emails is not picking by the loop, and also the main concern is that the vba code is taking lot of time to run because the "Inbox" folder has around 4000 mails and it is growing by each data.

Sample vba code:-

Sub MoveMail_Example()

Dim objOutlook As Outlook.Application
Dim objNameSpace As Outlook.Namespace
Dim objFolSource As Outlook.Folder, objFolDes_1 As Outlook.Folder, objFolDes_2 As Outlook.Folder
Dim ObjItem As Object, objItem2 As Object
Dim objCategoryMails As Outlook.Items
Dim lLoop As Long, lCount As Long
Dim sFilterString As String

Set objOutlook = New Outlook.Application
Set objNameSpace =


Set objCategoryMails =
lCount = objCategoryMails.Count

'Start 1st Method not working, - if new mail comes in between the loop in the source folder (Inbox)
'Then below code left some mails, and not looping to the desired mail
If lCount > 0 Then
For Each ObjItem In objCategoryMails
Set objItem2 = ObjItem.Copy
objItem2.Move objFolDes_1

Set objItem2 = ObjItem.Copy
objItem2.Move objFolDes_2

ObjItem.Delete
Next ObjItem
End If
'End ====

'Start 2nd Method not working, - if new mail comes in between the loop in the source folder (Inbox)
'The Index of the looping mail changed and generating the error message when trying to delete the looped mail, after copy and move.
If lCount > 0 Then
For lLoop = lCount To 1 Step -1
Set ObjItem = objCategoryMails(lLoop)

Set objItem2 = ObjItem.Copy
objItem2.Move objFolDes_1

Set objItem2 = ObjItem.Copy
objItem2.Move objFolDes_2

ObjItem.Delete
Next lLoop
End If
'End ====


'Start 3rd Method not working, - if new mail comes in between the loop in the source folder (Inbox)
'Then below code is not looping some mails, that should have included in the loop
For Each ObjItem In objFolSource.Items
If ObjItem.Categories = vbNullString And ObjItem.Class = olMail Then
Set objItem2 = ObjItem.Copy
objItem2.Move objFolDes_1

Set objItem2 = ObjItem.Copy
objItem2.Move objFolDes_2

ObjItem.Delete
End If
Next ObjItem
'End ====

End Sub


Thanks in advance for reading this mail and for your help.

As always God bless you.

Thanks
Kashif