Search results

  1. J

    Copy or Export Outlook Mail to Excel

    Diane, you are a life saver, last question, what lines do i change to get it to go to this folder and this file: Folder Location is this, O: is not my user drive, but a shared network drive O:\Lease Credit Request\z2017 Pipeline Reports File is 2017 Pipeline.xlsx
  2. J

    Copy or Export Outlook Mail to Excel

    Actually I figured some stuff out, but it keeps overwriting the same row, it wont add a separate email to the next row. Sub CopyToExcel() Dim xlApp As Object Dim xlWB As Object Dim xlSheet As Object Dim rCount As Long Dim bXStarted As Boolean Dim enviro As String Dim strPath As String...
  3. J

    Copy or Export Outlook Mail to Excel

    Thanks Diane, your code worked. I think because the code I had didnt factor in for microsoft exchange. Could you also help me change where it looks for the excel file? It is on a different drive in a subfolder not my user folder. Also I do not need the body, just the subject and not sure...
  4. J

    Copy or Export Outlook Mail to Excel

    Hi, I have a VBA Code to export incoming emails to excel and it does not work. If i paste the code, since i do not know what the items mean can someone highlight what i need to edit to cater it to the folder location of the excel file and other. I really just want to make a macro button in the...
Top