How can I to extract and consolidate multiple emails with attachments into one?

I'm receiving 12 emails with attachments from an AIX Unix server sent to me from ''  I'm expecting to receive these daily but they're really meant for about 80 people across the organization.  I have a distribution list to whom I could forward the attachments and could create a rule to forward the emails but that would be an overload to users.  Also each attachment really doesn't need to be sent to every user . . . but that point is kind of a red herring.

Please help me to write some code for my MS Outlook application which could extract the attachment from each email from the '' sender and consolidate them into one email for my distribution list.
CFMIFinancial Systems AnalystAsked:
Who is Participating?
pcelbaConnect With a Mentor Commented:
You may create a short code in VBA which will do the work via Outlook Automation. Some hints (incl. VBA code) are here:

Outlook properties and methods are described here:

The steps to code are:
1) Identify all e-mails incoming from the sender
2) Save attachments to disk
3) Move processed e-mail to appropriate folder (and failed e-mails into another folder)
4) Create new e-mail and add selected attachments into it
5) Send e-mail to the selected recipients
6) Create the e-mail about the daily results and send it to yourself

Google "Outlook automation" for more hints and more code etc.
CFMIFinancial Systems AnalystAuthor Commented:
Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.