Thank you for this! Very informative and suprisingly pertinent to the exact project I am working on. This is definitely going to save me a ton of time! Thank you very much!
Great tutorial, congratulation! Could you please do a video about how to save the Outlook calender automatically? E.g. save the calender from the entire past week, always run the save every Sunday night at midnight and save the PDF to a certain folder. I would really be interested to learn this :-) thank you so much!
I know this is old, but I have a question I have had zero luck finding an answer to. I have a macro I use to do many things and it sends an email. I only use it for certain emails. I want this single macro to send and email, wait for it to show in my sentitems folder, and then save that sent email. The issue is I do not want an eventlistener like this video because it is only for specific emails (not all sent). I have tried loops, sleeping, wait and other things. the problem is, the email sends, but is never received if you do anything else in the vba code while waiting. I legit have no idea how to fix, it is like vba is single threaded and can only do my macro and won't receive the already sent email until my macro finishes, it is super frustrating.
Keep up good work sir. Thanks for this very important video. I’m also interested to learn VBA development from scratch if that’s something in pipeline please let me know.
Hi, thanks for the video. I have small query, what if we have to use outlook sub folder instead of Default Inbox, how we can use the code [Auto Download]
Hello man! , This code is cool, i did do it and it worked but , im still stuck when i need to set a folder where i want some emails to go and then extract them from that place
Hello Sir - i would like to know the option of replying or saving some attachments through excel based on the conversation id and received date, is it possible?
@@VBAA2Z Conversation ID and Email Received Date or Modified date which I am thinking to give a criterion because it is unique in outlook emails...question it should be used in outmail email code?
Thank you for such a great video... I have one question... I am logged in on same email address on outlook on multiple devices (home, office, laptop etc) ... can i write a VBA code which if executed on 1 system will automatically replicate on all systems where I am logged in and carry out the functionality ? or do i have to execute VBA code seperately on all outlook sessions? thank you
hi I would like to congratulate you for the quality of your presentation, but i have a small querry, can we make the vba, to carry the print if we know in advance the extension of the file in the attachement and the body of the email, similaire to quick print Thank you
Thanks for making such useful tutorials, i have used some of you code to extract table contents to excel file but the outlook keeps crashing after performing the macro also excel keeps asking me to confirm pasting the content due to the difference in size when receiving new email.
thank you for the advice, but as i understood, you cannot print if there is no path to the file and the relevant application to open it, most of the attachement i have is in word, and i cannot instruct outlook to open word document and print it
Can this code work whenever we receive multiple emails at same time? I want to run utility as soon as I receive new email, but for multiple emails at same time how can we trigger?
Yes, definitely. there are various ways to accomplish this. Simplest will be have the program files in shell:startup folder, use Task Scheduler, or create a bat file which will load your excel file and run the VBA program. hope it helps.
Hello, Thanks for this great tutorial. I want to ask, if this kind of macros (triggered upon email arrival) works also while Outlook is closed? Thanks in advance. @VBA A2Z
@@VBAA2Z Thank you for your answer but I realized that I didn't give enough details. I would like to write a macro same as yours but it should work even if Outlook is not open. So can be the macro triggered on company's mail server, when I recieve some specific E-Mail? The macro should also give an automatic permission because I can not give a permenant permission. Thanks in advance!
Thank you for the video :) Do you know how to use excel VBA to reply to specific emails from outlookfolder. For example. Each reply needs to be replied with dear the person's name and contact details, email body with the person name eg. "Thank you for the response...." with the original email string. Much appreciated you help if you can. Thank you!
try something like this Dim olItem As Outlook.MailItem Dim olReply As MailItem ' Reply For Each olItem In Application.ActiveExplorer.Selection Set olReply = olItem.ReplyAll olReply.HTMLBody = "Hello, Thank you. " & vbCrLf & olReply.HTMLBody olReply.Display 'olReply.Send Next olItem
Hi Ashish, check the video below. We did detailed tutorials for the same. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ji2jHz8YPq8.html VBA real-life project from scratch to extract an attachment from outlook to folders. Learn how to: * Connect to outlook using VBA * Activate a specific session * Navigate to any folders within outlook * Search email based on various parameters * Download the attachment to a folder * Design a simple UI to send get parameters * More tips and tricks . . .
Have question I want to send data to everyone with excel sheet but according to outlook username the message has to display in excel hope you understand my thought
@@VBAA2Z no not like that in that excel I have data to all my team members but on the email I'd it has to display the data and rest need to hide I want automate the data to just display only partial data to that user
I do not have the code ready now but yes it is possible. Access / point to shared email box. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ji2jHz8YPq8.html it'll be something like this. Dim m As MailItem Set m = arySelection.Item(i) m.Categories = category m.FlagStatus = olFlagMarked m.FlagIcon = 6 m.Save
Hi can you please help me with validating the mail id of the incoming mail , if it is a valid mail "xyz@gmail.com" then it should be forwarded to another mail id say "abc@gmail.com"
forword sample here Sub ForwardEmail(item As Outlook.MailItem) Dim oMail As MailItem On Error GoTo Release If item.Class = olMail Then Set oMail = item.Forward oMail.Subject = oMail.Subject oMail.HTMLBody = "sample email body" oMail.Recipients.Add "abc@gmail.com" oMail.Save oMail.Send End If Release: Set oMail = Nothing Set oExplorer = Nothing End Sub