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...
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
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.
Dim EmailId As String
For k = 1 To Sheets.Count...
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...