Hi,
Does anyone know how to export email messages from outlook to an excel workbook? Preferrably using a VBA macro to do it faster.
Thanks in advance!
Fernando
Hi,
Does anyone know how to export email messages from outlook to an excel workbook? Preferrably using a VBA macro to do it faster.
Thanks in advance!
Fernando
Depends what you mena by export email messages. You can easily transfer details, such as headers, sender name and so on. If that's what your after then here's a basic bit of VB to get you going.
(Make sure you've got the Excel Object selected in the references menu)
CheersPlease Login or Register to view this content.
Last edited by Cutter; 08-06-2012 at 09:05 AM. Reason: Added code tags
@ Jockney
Welcome to the forum. Great to see you assisting others right away.
Please notice that code tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks