• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 102
  • Last Modified:

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 '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
CFMI
Asked:
CFMI
1 Solution
 
pcelbaCommented:
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
 
CFMIFinancial Systems AnalystAuthor Commented:
Thank you.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now