• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Loop through web-based outlook email folder, and extract attachment

inddon

Member
Hello There,

I am looking for the below requirement to do it in VBA:
1. User is using web-based Outllook for emails (outlook not installed on desktop).
2. VBA should scan through a subfolder (eg. Inbox/Customer Invoices)
3. Check if the email has an attachment (eg. pdf file).
4. Extract the attachment to a local folder (eg. C:\Attachments)
3. After the attachment is extracted, amend the email in the start of the email body, with the details:
a. email scanned and attachment extracted to folder: xxxx C:\Attachments on Date: DD-Mmm-YYYY HH24:MI:SS)
b. Save the email
c. Loop through the next email
d. Move the email to another folder (eg. Inbox/Customer Invoices/Scanned)

I have come across solution which does the above when the outlook is installed in the desktop.

Wonder if the above could be done and what would be the exact excel VBA code, when User uses the web-based outlook.


Look forward to hearing from you.

Regards,
Don
 

inddon

Member
Hello There,

I am looking for the below requirement to do it in VBA:
1. User is using web-based Outllook for emails (outlook not installed on desktop).
I came across some post on the net, regarding sending webmail using CDO option. Would this feature be used to achive my requirements using VB and how?

Thank you & regards,
Don
 
Top