Vba Code to Export outlook emails of current date for a folder to excel

[super.user.super]

any idea ..... how to get date in separate column...

I can see only -> Cells(n, 4) = olMail.ReceivedTime

 

[super.user.super]

?

 

[zesid]

If you get a lot of emails and you need to analyze the data in them, then importing your emails from Outlook into Excel with VBA will save you a lot of time. In this post, we’re going to easiest way to transfer emails from MS Outlook to Excel with date and time.

 

[josros]

When I run it get error 430 and highlight this line:

If Int(objItem.ReceivedTime) <= inteDate And Int(objItem.ReceivedTime) >= intsDate Then

 

[Mushtaq1126]

Woops My bad. I forgot to remove comment out from when I was running few tests. Use this one.

Good day, may i please ask for assistance.

How do i get the Senders email adress?

 

[vletm]

Mushtaq1126
You should open a new thread
as written in Forum Rules
which You have just read.