[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2015-02-18
2
Medium Priority
?
101 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
[X]
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
2 Comments
 
LVL 43

Accepted Solution

by:
pcelba earned 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this article I discuss my selections of the Top Four free Outlook OST File Viewers available. Open, view and read even damaged OST files by using these tools. They all provide a clear preview of all data such as emails, notes, tasks, calendars, e…
This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

650 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