If you are not getting all the emails, try to refer your exchange server. For more information, please refers to stackoverflow.com/questions/26731604/vba-not-all-outlook-emails-show-up
hello sir, could you guid me how to email from specfic folders Like under > inbox > folder1 > and inside folder2 > how to give path or how to download wherever we selected. Thank you
Great info. Thanks a lot. However, how to set up the corresponding fields in excel where the records are going to be saved. That part is not clear in this video
Hi Jie Jenn, may I know if you would know how to incorporate the ConversationIndex Property into your code above to track if sent emails have been replied?
How can we we about reading the body content of he outlook report item? Email Item(class 43 ) works fine, but the item.Body attribute of the ReportItem returns gibberish / chinese characters
Two questions. First, is there a way to get the above macro to work on the "current" folder? I have an inbox with sub folders and ideally would like to select any folder and then be able to export the items included in your macro. Second, is there an addition to add the "body" of the email to the export? thank you.
I haven't work on any VBA script for Outlook for a long time, so for question #1, I couldn't give you an answer. For #2, if you want to extract email body message, you can reference to the Body property. For example, olItems(i).Body
after 58 records its shows Export Complete. I wanted to increase it to 3000 records. Is it possible? Also, need email ids instead of sender names. Also body massage.
Hi, I have been trying to export the subject, sender email address, recived time and also the name of PDF's that i have in my emails. I am using "FileName" but I do not why I can not export it. Could you help me please?
Hello, could use some help: What references do you have activated during this tutorial? When I compile, it errors out with "User-defined type not defined" and highlights the Sub List_Email_Info() . I have Visual Basic for Applications, Microsoft Outlook 16.0 Object Library, OLE Automation, and Microsoft Office 16.0 Object Library checked off. Thanks!
@@jiejenn sorry for confusion above.. i just want to download email from certain date.. like example i want to download yesterday mail. But innyour macro we can download all the mails in the box. But i want to download only yesterday's mail. I hope you understand this
@@rakeshvengatesan8922 In the email I am only listing the email information in Excel. When you say download, do you mean pulling the emails information that are from yesterday?
I want to import only those email from outlook which has specific text in subject or body or sender domain name, say ex: only those email say "pepsi" , how can I do that . can someone please help with code.
Hi Jie, Thanks for this video, I am getting only couple of rows (email info) when I have over 1000+ emails I am trying to extract. My counter initialised before the For > Next and increment by 1 is sitting inside. same as yours. Not sure why it stops after couple of records. I monitored via debug it does not seem to encounter any errors. It does not go to On Error however, after 2 records it goes to the msgbox "export completed". Any helpful hints ?
I'm re-running the code (your code) that successfully ran about a month ago. But now, it skips a month. It will export email in MAR and MAY but not APR. Do you know why? There is email dated April, not sure why it's being skipped.
If you are not getting all the emails, try to refer your exchange server. For more information, please refers to stackoverflow.com/questions/26731604/vba-not-all-outlook-emails-show-up
Make sure you have your Microsoft Excel Object Library checked in Tools>References... I was getting an error when compiling
Thanks! I was having trouble figuring out what the issue was...
Kinda Important for Author to mention..... Thanks
is it possible to export also the received and the date replied of an email?
hello sir, could you guid me how to email from specfic folders Like under > inbox > folder1 > and inside folder2 > how to give path or how to download wherever we selected. Thank you
Excellent... But, how do you extract sender's IP Address to Excel? Thank you.
Great info. Thanks a lot. However, how to set up the corresponding fields in excel where the records are going to be saved. That part is not clear in this video
Hi can this be done in outlook chrome version?
Hi Jie Jenn, may I know if you would know how to incorporate the ConversationIndex Property into your code above to track if sent emails have been replied?
How can we we about reading the body content of he outlook report item? Email Item(class 43 ) works fine, but the item.Body attribute of the ReportItem returns gibberish / chinese characters
Two questions. First, is there a way to get the above macro to work on the "current" folder? I have an inbox with sub folders and ideally would like to select any folder and then be able to export the items included in your macro. Second, is there an addition to add the "body" of the email to the export? thank you.
I haven't work on any VBA script for Outlook for a long time, so for question #1, I couldn't give you an answer. For #2, if you want to extract email body message, you can reference to the Body property. For example, olItems(i).Body
after 58 records its shows Export Complete. I wanted to increase it to 3000 records. Is it possible? Also, need email ids instead of sender names. Also body massage.
Microsoft update its Outlook server, I will need to find sometime to investigate the issue a little bit.
Can you share the code please ?
Hi, I have been trying to export the subject, sender email address, recived time and also the name of PDF's that i have in my emails. I am using "FileName" but I do not why I can not export it. Could you help me please?
Hello, could use some help: What references do you have activated during this tutorial? When I compile, it errors out with "User-defined type not defined" and highlights the Sub List_Email_Info() . I have Visual Basic for Applications, Microsoft Outlook 16.0 Object Library, OLE Automation, and Microsoft Office 16.0 Object Library checked off. Thanks!
You will also need Excel library activated. The library name should be Microsoft Excel 16.0 Object Library or something similar.
@@jiejenn still same issue
Thanks for your video it helped. What if I want to import mails on a specifc date.. kindly advise on it.
Searching emails in Outlook is actually not as straightforward. I will record a video this weekend to show how to search emails using Outlook VBA.
@@jiejenn I don't want to search the mail. But i have ti export the mails on a specific date. I tried multiple times but i didn't get that
I'm not following your question.
@@jiejenn sorry for confusion above.. i just want to download email from certain date.. like example i want to download yesterday mail. But innyour macro we can download all the mails in the box. But i want to download only yesterday's mail. I hope you understand this
@@rakeshvengatesan8922 In the email I am only listing the email information in Excel. When you say download, do you mean pulling the emails information that are from yesterday?
Is there a way to do this not on the inbox folder?
You can. You just need to reference your folder object to the subfolder first.
@@jiejenn Where would i do that? Sorry this is very foreign. I have done VBA in excel but never in Outlook
Side note. it is not a sub folder under Inbox. But another folder. Outside of the inbox.
@@jeremiahkeltner371 then I don't know.
Hi, could you advise the coding if I want to extract the date and time of an email sent from a specific email subfolder in my outlook?
i am getting Compile error ( user -defined type not defined)
I want to import only those email from outlook which has specific text in subject or body or sender domain name, say ex: only those email say "pepsi" , how can I do that . can someone please help with code.
Can anyone help me how to save email from Outlook to desktop folder
Hi Jie, Thanks for this video, I am getting only couple of rows (email info) when I have over 1000+ emails I am trying to extract. My counter initialised before the For > Next and increment by 1 is sitting inside. same as yours. Not sure why it stops after couple of records. I monitored via debug it does not seem to encounter any errors. It does not go to On Error however, after 2 records it goes to the msgbox "export completed". Any helpful hints ?
Got it. Looks like sometimes olMailItem = "" when I replace For > Next with Do While olMailItem "" Loop it works.
@@calvinjames419 Indeed Do While workd but is not getting out of the loop for me, should the test be different than OlMailItem "" ?
Has anyone else had their export cut off after adding or removing sync'd accounts from outlook?
What about attachments ?
You can use Graph API th-cam.com/video/UF-hc2nZV_A/w-d-xo.html
I'm re-running the code (your code) that successfully ran about a month ago. But now, it skips a month. It will export email in MAR and MAY but not APR. Do you know why? There is email dated April, not sure why it's being skipped.
Are you a Microsoft 365 subscriber?
@@jiejenn No
The VB is success running, but no any record appear in excel
same here
@@daniloafb2 im having the same issue, hope you guys found an answer