Macro that would export emails
I'm looking to create a simple outlook macro that would export emails in a specific folder into an excel worksheet. The folder can be called "test" for reference purposes and the excel spreadsheet can be anything.
Outlook will always remain open and the spreadsheet would not be located on a server. This is all local.
Information I would like coming over is the date and the body (possibly the subject).
I've tried this a few different times and have yet to get a working version. I'm using Office 2016.
Any help would be greatly appreciated (appreciated = paypal???)
You all are great and very kind for helping out. It is greatly appreciated.
Hi,
The best available resource is Ron de Bruin' s site ...
https://www.rondebruin.nl/win/s1/outlook/mail.htm
You will find there all kinds of ready made solutions for Outlook ...
Hope this will help
hello
thank you for your help
Hello again,
Below is a link which provides you with the operational answer to your initial question ...
https://www.howtoexcel.org/vba/how-to-import-your-outlook-emails-into-excel-with-vba/
Hope this will help you solve your problem ...
[Good morning
it's very helpful, but i always get an error on this line:
Set Folder = OutlookNamespace.GetDefaultFolder(olFolderInbox).Folders("Net Sales Report").Folders("Sales")
eventhought i have created two folders in my inbox with the same name.
Hello,
When it comes to these kinds of errors ... you do have to make sure your spelling of your various folders' names is 100% correct ...
Hope this will help