Answered

Saving email attachment when the email is stored in a folder (outside of Outlook)

(0) Share

Report

Posted on by jharrity

We have a bot that automatically stores emails in folders on a server and deletes the emails from Outlook. I would like to extract attachments from the emails stored in the folders and store them in a desired location. I'm struggling with this. I know PAD allows you to easily do this when the email is in Outlook. I'm not figuring out how to do this when an email with an attachment is stored in a folder outside of Outlook. I know how to identify the email in the folder. I don't know how to extract the attachment from the email. Can someone help me with this? Thanks!!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

This link shows how to add a folder within the outlook program to point at the archived folder, that way you can still use outlook to retrieve the messages:

https://www.bu.edu/eso/help-support/e-mail/mailbox-management/create-pst/

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jharrity

I am considering that you are having .msg files stored in a folder.

And if you dont want to use PAD then you will have to use a scripting language like Vbscript, Python etc or a VBA macro.

This link, after a random search, has both, the macro as well as a Vbscript program.

excel - Extract attachments from saved .msg files using VBA - Stack Overflow

You can find some more easier code over the internet if you would like to.

The idea is to:

- Either write an Excel macro and call it from the "Run Excel macro" action of PAD.

- Or write a Vbscript in the "Run Vbscript" action of PAD.

Let me know if you are facing any challenges.

Was this reply helpful? Yes No