How to query a SQL Server 2008 database from Outlook

Tags:
Outlook
SQL Server 2008
VBA

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



Software/Hardware used:
SQL Server 2008, Outlook 2013, VBA
ASKED: August 24, 2013  3:18 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following