you are great teacher Andrew!! I literally pushed all my colleagues at work to watch and subscribe to your channel. it is one of the very few channels that really worth watching!
Hi Andrew! Thank you for the tutorial. I have a question: i have constatntly receive Runtime error Error at "". for the Set i = fol.Items.Find(FilterText) line. Can you help with that error, please?
Hi wiseowl, thanks for such detail explained videos on VBA , i really love your videos to learn new things in VBA .... One small request can you make detailed series on 'Web Scraping" which will be useful for fully automation of website form filling or other repetative tasks on webpages....
Hello Andrew, love your work and its fun following, could you help, i am looking to understand how can i 1) search specific sign-off emails for my project (basically multiple sign-off from different stages) and 2) save them to desired Windows folder for audit purposes.
Hi Andrew, Million times thank you so much Andrew, God bless you, I have not tested the code yet but I am curious that, can it also work if a subject has special characters like " ' " or " | " or any other special characters. Thanks once again for these amazing tutorials Thanks Kashif
Hi Andrew. Thanks for the videos, they have been very informative. I am trying to edit the code to search through my Sent Items folder for emails sent to a specific email address. I have not been very successful with my attempt. Is it possible to do this? Can I change SenderName in FilterText to Recipients?
Thank you so much Andrew. It seems to be what I am sfter. Currently I am reading your answer on my smart phone n can't experiment the content of the links. Will let you know when I am on my PC.
Hi Andrew, Following this series, I got to know 100s of things but i got stuck in a point where I need to click Reply on and "want to write something in the body of the email" How to write something in the body of the email is what I am not able to do... Any help would be great!
Hi Andrew. This is great and very helpful. Question though please. if i want to find an email based on recieved time how do i format the find expression. I have tried several variations of expr = "[ReceivedTime]'" & format(giventime, "dd/mm/yyyy hh:mm:ss") but without success.
Hi Max, I think you'll find this video useful from 19:26 th-cam.com/video/HftSuuugkGM/w-d-xo.html Alternatively, this video from 21:30 th-cam.com/video/BEplEKOxPFg/w-d-xo.html I hope that helps!
Hi Andrew, I followed your tutorial to a tee, however, i am receiving a run-time error “method’ sender name’ of object ‘_MailItem’ failed. Debug highlights “cells (n, 1).value = mi.SenderName. Could you please some guidance as to why this would occur. I added the correct reference IAW the tutorial i have rechecked my code against the tutorial, it all matches. Kind Regards DJ
Hi Andrew, although the code is simple I'm finding that it isn't connecting to my open Outlook account and therefore doesn't read any emails. I'm probably making an elementary error? Any help would be appreciated. Thanks
when I ran this code, it works fine, but for one very irritating minor bug: The range clear statements runs fine, but the for each loop overwrites from cell A1, and of course overwrites my headers. And yes my range is set to clear from A2.
Yes, yes, I'm an idiot I didn't initialize with the value n=1. Sorry, I noticed that just minutes after I wrote that. But now that I have your attention, on the video about inserting pic into outlook email I'm sure you can insert multiple pics into one email, gotta discover that. It's not by using an operator like AND between statements like this one doc.range(0, 0).InlineShapes.AddPicture "C:\VideosAndPictures\ManhattanFromJerseyCityNewportHarbor.jpg". And to add to that Santa Claus, I mean Andrew. How bout getting emails in Excel VBA from a non-outlook email client. I don't think that can be done easily as there is no reference in the MS library to non-Outlook. But there is MS CDO which might do the trick. I gotta purchase some of your training software, if it's reasonably priced.
@@WiseOwlTutorials Thanks a lot for reply. I tried to close all the office applications then opened outlook and closed it separately .. then opened my workbook that has your great code. The first code is working well .. The problem is with the second one at the referred line. I have tried several emails not specific one and the same problem. I am using office 2016 and on another device Office 2019
@@WiseOwlTutorials That's wonderful. That solved the problem (The second approach I mean) How can I disable screen flickering while outlook is opening?
Hi Andrew, I have one request to you, I am doing some task in VBA but I don't know how to do this, can you please give me any idea or guide me how can I solve my task. My Task:- I have a form and in that form I have a list box with 4 columns Name, Age, Type and TransDate and I want to sort the list box by TransDate with condition. Sort Condition:- Those TransDate that is within before 24 hours by today's date will show first then show rest of the data below. Note 1:- In TransDate column there is also NULL values. Note 2:- In TransDate column Dates may also be futures date s ListBox Name is "QCList" Please help me or guide me to resolve this problem. Thanks in advance. Thanks Kashif
Hi Andres, I hope you are doing good and staying safe and healthy, I want your expert help on a problem that I am facing in Excel VBA code: I have a mail and through "Move" method I am moving this mail to a different folder, now what I want is that I want to take a reference of this mail from the moved folder. Suppose "A" is a folder where have a mail and I want to move this mail to the folder "B", through below code I am moving this mail from folder "A" to folder "B". set MyNameSpace=Outlook.Application.GetNamespace("MAPI") Set Mymail=ActiveExplorer.Selection.Item(1) Set B = MyNameSpace.folders("Inbox").folders("B") Mymail.Move B Now, after moving the mail in the folder "B" I want to take the reference of this mail from the folder "B". I don't know how to do this, my kind request to you please help me how can I do this. Thanks in advance for your help. Thanks Kashif
Hi Andrew, I found a solution on google, below is the code that is meeting my requirements. Dim emailInB As Outlook.MailItem Set emailInB = Mymail.Move(B) MsgBox "The email is now in " & emailInB.Parent.FolderPath Thanks Kashif.
Hi Kashif! I see that you've found the answer already! I was about to reply that the Move method returns a reference to the moved MailItem object which you can store in a variable learn.microsoft.com/en-us/office/vba/api/outlook.mailitem.move Which is exactly what your updated code is doing!
Hi wiseowl, thanks for such detail explained videos on VBA , i really love your videos to learn new things in VBA .... One small request can you make detailed series on 'Web Scraping" which will be useful for fully automation of website form filling or other repetative tasks on webpages....
you are great teacher Andrew!!
I literally pushed all my colleagues at work to watch and subscribe to your channel. it is one of the very few channels that really worth watching!
Of course you mean, you figuratively pushed your colleagues at work. Otherwise, you actually did some physical pushing them.
Hi Andrew! Thank you for the tutorial. I have a question: i have constatntly receive Runtime error Error at "". for the Set i = fol.Items.Find(FilterText) line. Can you help with that error, please?
Thank you!
My pleasure Iryna, thank you for watching!
thank you for your valuable videos, its saving a lot of time
Hi Andrew, thanks for these new uploads. Very helpful and I really enjoy watching them! Best regards, Bas
Hi wiseowl, thanks for such detail explained videos on VBA , i really love your videos to learn new things in VBA .... One small request can you make detailed series on 'Web Scraping" which will be useful for fully automation of website form filling or other repetative tasks on webpages....
Hello Andrew, love your work and its fun following, could you help, i am looking to understand how can i 1) search specific sign-off emails for my project (basically multiple sign-off from different stages) and 2) save them to desired Windows folder for audit purposes.
Thanks Andrew.
Hi Andrew,
Million times thank you so much Andrew, God bless you, I have not tested the code yet but I am curious that, can it also work if a subject has special characters like " ' " or " | " or any other special characters.
Thanks once again for these amazing tutorials
Thanks
Kashif
Hi Andrew. Thanks for the videos, they have been very informative. I am trying to edit the code to search through my Sent Items folder for emails sent to a specific email address. I have not been very successful with my attempt. Is it possible to do this? Can I change SenderName in FilterText to Recipients?
Nice one Andrew. Thanks
Can we determine if an email that we have sent to a specific address has been bounced?
Thank you so much Andrew. It seems to be what I am sfter. Currently I am reading your answer on my smart phone n can't experiment the content of the links. Will let you know when I am on my PC.
Hi Andrew,
Following this series, I got to know 100s of things but i got stuck in a point where I need to click Reply on and "want to write something in the body of the email"
How to write something in the body of the email is what I am not able to do...
Any help would be great!
Hi Andrew. This is great and very helpful. Question though please. if i want to find an email based on recieved time how do i format the find expression. I have tried several variations of expr = "[ReceivedTime]'" & format(giventime, "dd/mm/yyyy hh:mm:ss") but without success.
Hi Max, I think you'll find this video useful from 19:26 th-cam.com/video/HftSuuugkGM/w-d-xo.html
Alternatively, this video from 21:30 th-cam.com/video/BEplEKOxPFg/w-d-xo.html
I hope that helps!
Nice ...I want to get sender mail,cc,bcc,body in a variable from specific emails having a specific word in the subject.
Can u please help me in this
Hi Andrew, I followed your tutorial to a tee, however, i am receiving a run-time error “method’ sender name’ of object ‘_MailItem’ failed. Debug highlights “cells (n, 1).value = mi.SenderName. Could you please some guidance as to why this would occur. I added the correct reference IAW the tutorial i have rechecked my code against the tutorial, it all matches. Kind Regards DJ
Your are so helpfull tks for all :-)
Hi Andrew, although the code is simple I'm finding that it isn't connecting to my open Outlook account and therefore doesn't read any emails. I'm probably making an elementary error? Any help would be appreciated. Thanks
when I ran this code, it works fine, but for one very irritating minor bug: The range clear statements runs fine, but the for each loop overwrites from cell A1, and of course overwrites my headers. And yes my range is set to clear from A2.
Yes, yes, I'm an idiot I didn't initialize with the value n=1. Sorry, I noticed that just minutes after I wrote that.
But now that I have your attention, on the video about inserting pic into outlook email I'm sure you can insert multiple pics into one email, gotta discover that. It's not by using an operator like AND between statements like this one doc.range(0, 0).InlineShapes.AddPicture "C:\VideosAndPictures\ManhattanFromJerseyCityNewportHarbor.jpg".
And to add to that Santa Claus, I mean Andrew. How bout getting emails in Excel VBA from a non-outlook email client. I don't think that can be done easily as there is no reference in the MS library to non-Outlook. But there is MS CDO which might do the trick. I gotta purchase some of your training software, if it's reasonably priced.
Hi I have one question why didn't you make even a single video MS Access macro?
Hi, how can I filter using receivedtime?
Thanks a lot sir 🙏🙏🙏🇮🇳
have you completed the whole series
No at this point i have completed half of series may i know y r u asking
@@pradeeprawatvlogs8358 Bro actually i also want to enroll into this course
just want to confirm the series is useful or not
Awesome bro
@@pradeeprawatvlogs8358 thanks
Hi Andrew! How so I go to a folder other than Inbox?
Hi Evan! Check out videos 29.6 and 29.7 in this playlist th-cam.com/play/PLNIs-AWhQzcleylKSN4MS-tJloReq0XcK.html
I hope it helps!
@@WiseOwlTutorials I already did and it was very helpful as always! Thanks!!!
@@MrXESMOS Happy to hear that it helped, cheers Evan!
Thanks a lot for awesome tutorials.
I have encountered an error at the line `Set doc = mi.GetInspector.WordEditor` (The operation failed)
@@WiseOwlTutorials Thanks a lot for reply. I tried to close all the office applications then opened outlook and closed it separately .. then opened my workbook that has your great code. The first code is working well .. The problem is with the second one at the referred line. I have tried several emails not specific one and the same problem. I am using office 2016 and on another device Office 2019
@@WiseOwlTutorials That's wonderful. That solved the problem (The second approach I mean)
How can I disable screen flickering while outlook is opening?
@@WiseOwlTutorials Thanks a lot for your patience and interest and thanks again and again and again for all you incredible videos
I am getting an error while setting i = fil.items.find(filtertext) . Error is - cannot parse condition
Hi Govind! I guess that you have an error in the string you've assigned to the filtertext variable. I'd start by checking that part of your code.
Hi Andrew,
I have one request to you, I am doing some task in VBA but I don't know how to do this, can you please give me any idea or guide me how can I solve my task.
My Task:-
I have a form and in that form I have a list box with 4 columns Name, Age, Type and TransDate and I want to sort the list box by TransDate with condition.
Sort Condition:- Those TransDate that is within before 24 hours by today's date will show first then show rest of the data below.
Note 1:- In TransDate column there is also NULL values.
Note 2:- In TransDate column Dates may also be futures date
s
ListBox Name is "QCList"
Please help me or guide me to resolve this problem.
Thanks in advance.
Thanks
Kashif
I think 18:22 will fail if the subject consists only of the three characters "Re:" or the four characters "Re: "
@@WiseOwlTutorials Thanks. I'm a big fan of your videos.
⚘⚘❤❤
with special thanks, but I come across an error from the line "Set doc = mi.GetInspector.WordEditor"
.pleae let me know what's the issue
Hi! What error message do you see?
Hi Andres,
I hope you are doing good and staying safe and healthy, I want your expert help on a problem that I am facing in Excel VBA code:
I have a mail and through "Move" method I am moving this mail to a different folder, now what I want is that I want to take a reference of this mail from the moved folder.
Suppose "A" is a folder where have a mail and I want to move this mail to the folder "B", through below code I am moving this mail from folder "A" to folder "B".
set MyNameSpace=Outlook.Application.GetNamespace("MAPI")
Set Mymail=ActiveExplorer.Selection.Item(1)
Set B = MyNameSpace.folders("Inbox").folders("B")
Mymail.Move B
Now, after moving the mail in the folder "B" I want to take the reference of this mail from the folder "B".
I don't know how to do this, my kind request to you please help me how can I do this.
Thanks in advance for your help.
Thanks
Kashif
Hi Andrew, I found a solution on google, below is the code that is meeting my requirements.
Dim emailInB As Outlook.MailItem
Set emailInB = Mymail.Move(B)
MsgBox "The email is now in " & emailInB.Parent.FolderPath
Thanks
Kashif.
Hi Kashif! I see that you've found the answer already! I was about to reply that the Move method returns a reference to the moved MailItem object which you can store in a variable learn.microsoft.com/en-us/office/vba/api/outlook.mailitem.move
Which is exactly what your updated code is doing!
Thank you so much Andrew for the reply :)
Thanks
Kashif
@@kashifkhanspecial You're very welcome Kashif!
Hi wiseowl, thanks for such detail explained videos on VBA , i really love your videos to learn new things in VBA .... One small request can you make detailed series on 'Web Scraping" which will be useful for fully automation of website form filling or other repetative tasks on webpages....
It's already there.