Outlook Email transfer to Excel and Attachment to Drive C

  • Hi,

    I am a new to VBA. I am working on transferring my email messages to excel as well as its attachments when a date will be entered. I am hoping someone will be able to help me solve the problem since I've also copy this in the internet. I am encountering an error that says, " Run-time error 424 Object Required" under the line "Range("Email_Subject").offset(1,0).Value = OutlookMail.Subject". I am stuck to it. The code does not yet include how to extract the attachment (save it to Drive C:\Marl\) however I would be very grateful if you could also add the code about it. Here's the code --

    Please help and Thanks,


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!