I exported an archive of Outlook "Notes". These are simple plain-text documents. The Outlook Export created a Word file with embedded Notename.msg objects.
I need the data in searchable text, not embedded objects. There are thousands of notes, so manually opening and copy/paste each message is not feasible.
I want to use VBA to iterate through all the embedded objects, open them, copy all the note's text, and paste the note's text, appending into the same (or another) Word document.
A very similar question was posted in 2012, now closed: Link
I tried the proposed VBA code, and I get the same error as reported in 2012 (Run-time error '430': Class does not support Automation or does not support expected interface") with Office 365 today.
A solution was never posted.
Can anyone help debug this error, or offer a different approach to opening and extracting text from embedded objects?
I need the data in searchable text, not embedded objects. There are thousands of notes, so manually opening and copy/paste each message is not feasible.
I want to use VBA to iterate through all the embedded objects, open them, copy all the note's text, and paste the note's text, appending into the same (or another) Word document.
A very similar question was posted in 2012, now closed: Link
I tried the proposed VBA code, and I get the same error as reported in 2012 (Run-time error '430': Class does not support Automation or does not support expected interface") with Office 365 today.
A solution was never posted.
Can anyone help debug this error, or offer a different approach to opening and extracting text from embedded objects?
