The purpose of this module is to monitor the activity of Outlook and grab the attachment (. Zip file) for a specific email address and subject line and place it on the server (and create the Server Folder(s) Structure: CompanyName->weekNo.->zip file(s))
I have to mention that we are going to run SQL Server 2008/12 and Outlook 2013 on the server.
This module should run ongoing (like a service) and grabs the files any time when they arrives .
My question is, because MS. Outlook is an e-mail client only, do we need to run a mail server Microsoft Exchange Server on the server?
This is a standalone module, the main application we would like to be hosted in the cloud (Windows Azure) and the software support would be ASP.Net C# with MVC.
To answer your questions
#1 - How to use SQL 2008 in general? Using what language?
I placed the module in Outlook-ThisOutlookSession (VBA)
I checked for the existence of a specific kind of e-mail with an attachment, and then verify if the Folders (companyName and weekNo.) exis. If it’s a new company then create a new folder called companyName, if folder- weekNo doesn’t exist create a new subfolder( for that companyName) called weekNo
The CompanyName is a field in a SQL Server database table and it can be determined by querying the database based on an ID (primary key) that comes from the subject line( last 10 characters of the subject line)
The weekNo. would be calculated using a function with a parameter InputDate = current date
The info. that comes form the Sql database would be used for creating a proper folder structure on the server.
Grabbing the files and creating the subfolder weekNo. and placing the zip files in the server folder has been addressed using the VBA module, I only need to query the database to get the company name
Thank you for your time and any advice and suggestions will be greatly appreciated