Outlook Email to Excel

What is it that you expect this code to do?

Offhand, I see that you have a comment that you save the workbook, but you don't actually save it to the specified path, you just close it.

Please post your code instead of a picture of your code. Pictures are not useful for code--we can't copy it to test it, or modify it for you.

You are creating both an Excel application and and Outlook application in this code, which you never use. Then you create another Excel application. Are you running this code in Outlook or Excel?

Other than cleaning that up, I would add a line that says

Please Login or Register  to view this content.

before you close the workbook.

Hi,

Please be advised that the excel automatically save on the shared drive. Hoever, when I open it, the excel file is empty. It seems that the code was not able to read and write the contents from email to excel. Here's the code:

Please Login or Register  to view this content.

Thanks in advance.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Originally Posted by KMBuild

Here's the code:

This code has several compilation errors so it appears it was not copied directly from the VBA module. They are easy to fix, and I will try to reproduce your problem. But it raises the question of other copy errors.

I cannot even run this code because I get a compile error here. I am unclear on how you are getting this to run. GetSharedDefaultFolder has two required arguments.

typemismatch.JPG

Also, I asked "Are you running this code in Outlook or Excel?" Since the code calls Application methods in Outlook I am going to assume this code is in Outlook.

This code has many problems in it, especially undeclared variables. I have fixed as many as I could to get it to run, but I could not get it to produce an Excel file.

I am especially having trouble with GetSharedDefaultFolder. I am not familiar with that method and can't get it to work.

The line

Please Login or Register  to view this content.

is a poor practice here because it hides errors. You are almost certainly getting an error that is ignored and that is why your file is blank. I suggest commenting out this line, running it again, and then report back to tell us what error you get.