outlook.application

  1. D

    Exporting undelivered emails from Outlook to Excel

    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...
  2. W

    VBA / Outlook run time error

    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...
  3. P

    Outlook VBA GetDirectReports infomation

    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...
  4. E

    VBA sending emails, works on one computer, does not work on another

    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...
  5. R

    GetObject not getting Outlook.Application

    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...
  6. M

    Outlook.Application, copying Word contents to Body and looping through a list of email addresses

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top