I need an excel macro to pull all email details in an outlook folder into and excel sheet

[tonywatsonhelp]

Hi Everyone,
hope someone can help me,

I have my outlook and have a folder where I receive all my replies called "Reply"

all i want to do is have a macro that i can run that will pull the data from each email into a sheet in excel,
now the data i need is basicly everything,
but these are basic email
so Email address
subject line,
body text
date recived
I think thats it but anything that can be pulled out,

I need it to go into a sheet call "Emails"

If anyone could help me i'd be very happy
thanks
Tony

 

[DanteAmor]

Check these solutions:

VBA code for outlook to find serial number from excel

Hi, I am really not good to work with outlook codes, so here I am. I have a list of serial numbers in a random column, let's say column B. I need to copy the code, and need to find in email body or subject in outlook, returning the e-mail who sent me and what time was it. I think that's not...

www.mrexcel.com

VBA Help - Excel and Outlook

I have a macro in Excel to go into a specific Outlook folder. For all emails in that folder I want to copy the sender email address, subject, body, and date into Excel. When I run the code it returns a an error 'Run-time error 438: Object doesnt support this property or method'. Can someone...

www.mrexcel.com

Copy texts from current email in Outlook to cells in Excel

Hello everybody! I want to create a macro that copies texts from the current email in Outlook and pastes it into cells in the row of a spreadsheet, as a manual procedure is laborious and repetitive. Something that is seemingly simple, and it should be. I wrote the code below, but I can't...

www.mrexcel.com

Extracting SubFolders from Outlook using Excel VBA

I would like to extract out subject from shared outlook email. I manage to extract out inbox but subfolder are not extracted out. Anything wrong with my code below? Shared email > Inbox > subfolder1 (under subfolder 1 has few folders) Public xlSht As Excel.Worksheet Sub...

www.mrexcel.com

 

[tonywatsonhelp]

Thanks dante