I had already replaced Sub CopyToExcel(olItem As Outlook.MailItem)
with Sub CopyToExcel() and Dim olItem As Outlook.MailItem
I had not added this line as instructed.
Set olItem = Application.ActiveExplorer().Selection(1)
The macro knows runs without error, but it just open excel with no file...
This macro is exactly what I am need, but it produces a run-time error '91': Object variable or With block variable not set
The error occurs on line sText = olItem.body
I am new to VBA for Outlook and do not know how to correct the error. Thanks for any help provided.