Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2015-02-18
2
97 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 42

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
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 …

809 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