Outlook auto reply with attachement based on a subject of email received

[msamhouri]

I am new in VBA world and i have a question about connecting MS outlook to MS access (2007 or 2010). let me explain what i want exactly by telling you what kind of project i wanna do.

I have an access database with a lot of data and tables, when i receive any email with certain subject like if i receive an email says in the subject line "Emp 1232221" then outlook when see any email with subject start with "Emp" a VBA code should go to MS access table called "employees" and get all the data belong to employee no "1232221" put them in excel sheet and reply back with this sheet as an attachment.

[Rabbit]

First of all, this sounds like a bad idea. You are allowing anyone and everyone to request employee information. Which can be a security nightmare and possibly illegal to leak employee information due to privacy laws. Note that anyone outside your organization can exploit this to extract your entire employee database.

That being said, this article on our forum will teach you how to automate Office applications: https://bytes.com/topic/access/insig...ion-automation

[msamhouri]

i am not going to but the employees information for all over the world, no its just an example, but my real project is different

[zmbd]

msamhouri
i am not going to but the employees information for all over the world, no its just an example, but my real project is different

The critical point that Rabbit is trying to make here is that any information you provide via such an automated system is vulnerable to exploitation by those with malevolent intentions. Only four years ago, an exploit was found that allowed people to authenticate email as being sent by Google Staff (http://www.wired.com/2012/10/dkim-vu...ty-widespread/)! And very recently there was a mass attack against the USA-IRS in an attempt to steal people's tax-identity using the IRS.GOV own automated systems (https://www.irs.gov/uac/Newsroom/IRS...on-Efiling-PIN).

Thus, make sure that what you are exposing here isn't something that will compromise either your employee or company assets.

[Rabbit]

Also, I'm not saying what you want to do is a bad idea in general. I'm just saying the method by which you want to do it is a bad idea. You have no processes with which to prevent data from getting into the wrong hands.

But if you do want to do this, then the first step is to read the tutorial I linked in the first post.