Solved

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

Posted on 2015-02-18
2
91 Views
Last Modified: 2016-02-11
I'm receiving 12 emails with attachments from an AIX Unix server sent to me from 'no-reply@....com.'  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 'no-reply@....com' sender and consolidate them into one email for my distribution list.
0
Comment
Question by:CFMI
2 Comments
 
LVL 41

Accepted Solution

by:
pcelba earned 500 total points
ID: 40617529
You may create a short code in VBA which will do the work via Outlook Automation. Some hints (incl. VBA code) are here:
http://www.itjungle.com/fhg/fhg100610-story01.html
http://www.dicks-clicks.com/excel/olAutomating.htm
http://www.rondebruin.nl/win/s1/outlook/openclose.htm
https://msdn.microsoft.com/en-us/library/office/jj973160.aspx
http://www.outlookcode.com/article.aspx?id=40

Outlook properties and methods are described here:
https://msdn.microsoft.com/en-us/library/ms268893.aspx

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.
0
 
LVL 1

Author Closing Comment

by:CFMI
ID: 40631067
Thank you.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now