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
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.