Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 07-21-2016, 08:42 AM
paul h paul h is offline Exporting Messages to Excel using VBA Windows 7 32bit Exporting Messages to Excel using VBA Office 2007
Novice
Exporting Messages to Excel using VBA
 
Join Date: Jul 2015
Location: Richmond
Posts: 23
paul h is on a distinguished road
Default

I got my answers to the questions above. I easily picked out my folder. I ran the code as written and bumped into several problems which I will iterate. The code checks for olkMsg.Class = olMail. For my purposes this does not work. I am looking at Mail Delivery System Undeliverable notifications. For it to read any of these I had to comment out the If olkMsg.Class = olMail and End If. The next item was a
Quote:
Type Mismatch
on the GetSMTPAddress(olkMsg, intVersion) and then
Quote:
Outlook doesn't support this property or method
for olkMsg.RecerivedTime and olkMsg.ReceivedByName which I assume are not properties of notifications. I commented those three lines out and the code finished running. When it came time to save the files it took about 10 minutes, but it finally finished. The end product though was an empty file except for the headers. The objective is to collect all the email addresses found in the notification files and a few scattered messages. If I could get this code to just run for all the notifications it would be a big help.

Last edited by paul h; 07-21-2016 at 01:53 PM.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting to Excel in MSP c991257 Project 7 05-15-2016 07:58 AM
Exporting Messages to Excel using VBA Exporting from excel into a specific format Bambi555 Excel 2 09-22-2014 08:08 AM
Exporting Messages to Excel using VBA Exporting Contacts to Excel misslinds Outlook 1 06-15-2014 08:08 AM
Exporting Messages to Excel using VBA * Exporting Access Data to Excel djreyrey Excel Programming 1 03-23-2012 10:03 PM
Exporting Messages to Excel using VBA Exporting to Excel lhicks Outlook 1 07-13-2011 02:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft