outlook.application

As the title suggest, I'm trying to export Undelivered emails in Outlook to Excel (sheet1) I found this code on the web, and I'm having a little difficulty getting it to work Ideally I would like the data to appear in columns, a separate column for Email address etc The Emails are in sub-folder...

Context The code below allows or me to send an email once I click submit. It works fine on Microsoft Excel 2010 but gives a 'run time error 287' on Microsoft Excel 2013 - Please help!! :) Dim myApp As Outlook.Application, myMail As Outlook.MailItem Set myApp = New Outlook.Application Set...

Dear Techies, I'm looking for a VBA code to get the direct reporties for a contact using their email ID's. I used the following code which works fine for few, But not for ALL. Not sure why its failing. Request help. Sub GetOtlkDtls() Dim EmailId As String For k = 1 To Sheets.Count...

Hi I have created a VBA for someone else, and on his computer it seem to not be able to start the "Outlook.Application" and therefore no emails are created. When I test it on my computer it Works just as intended. We both run Office 2016, and seem to have the same Librarys activated under...

I have a stock function I use to test to see if Outlook is running before I attempt to draft an email. I've never had problems with it before, but today I ran the program and it doesn't acknowledge that Outlook is running. If I close/reopen the file, it seems to work and if I step through, it'll...

I have a workbook with about 12 sheets in it. Every month I have to update the date in it and the copy each sheet to a new workbook and mail each sheet to a different person. I have found a few macros that do this but I am struggling to copy data from a Word document (Document1) to the body of...