Password message box

[ShadowsLight]

Greetings

I have a small Bed&Breakfast client that has the following situation:

1) 5 people use the same Reception PC at all times of the day.
2) There are programs running on the PC that require that the same user be logged in all the time (so I can not use multiple Windows Profiles)
3) He has just upgraded to Outlook 2013 from Thunderbird
4) Each user, when they log into their mail, gets access to their own IMAP mail account and 2 shared IMAP mail accounts


This is what they had in Thunderbird:
When you start up Thunderbird, it asks for your profile. Each user selects their own profile. When their profile is selected, an add-on was installed that asked for a personal password that was used to access their personal mail account. Only if the correct password was entered, would Thunderbird start up properly.

They would like the same in Outlook

However, you can not password protect an OST file (which would be the Home Run solution, in this case)

This is not for major security protection, just simple prying eyes from other employees, all equally technophobic


What I have set up so far:
1) Each employee has their own mail profile setup in the Mail Control Panel program.
2) Each profile connects to their personal mail account and each of the two shared accounts, all filtering into their own .OST files


Solutions I have tried:

1) I added an empty PST file to their profile with a password on the PST file. While it did ask for a password before logging in, if they hit the "Cancel" button they would get access to all the mail accounts
2) I tried to find a program that would password protect the OST file at the file level. Unfortunately, all the programs I seemed to find would put the file into a "vault" and there was no program the would just put up a quick password box before allowing another program to access the file
3) I tried my hand at some "cut and Paste" VBA programming. This was the most successful as I got an almost perfect solution (A popup asks for a password, and if the right one is entered then Outlook opens, otherwise Outlook shuts down), which you can see below, except that it does not show "****" when the password is entered in the InputBox.

My vague attempts at some VBA programming:

Please Login or Register  to view this content.

Like I said, this code works brilliantly and does exactly what I want.... except it shows the password when the user types it in. Now, I realise that their security is a joke, but they are not happy that anyone looking over their shoulder (which could be anyone, even guests at the B&B) can see their password.


So then I went to go add a UserForm....

And that is not working at all.

Please Login or Register  to view this content.

Is how I call the Userform... but then Outlook opens before anything is typed into the form.

And putting the Select Code On the OK button does not seem to do anything.


Can anyone please help me to either:
1) Implement the Select Case solution with the Userform
2) Have any other ideas how I can give them what they want...


Thanks

PS. Please use detailed instructions as I am not a VBA programmer and I am just muddling around with it. Thanks you

[Vikas_Gautam]

Here are some steps:-

Ist Part

Start Excel.
Press Alt+F11 to start the Microsoft Visual Basic Editor.
On the Insert Menu, click User Form.
Using the Controls Toolbox, add a text box and a command button on to your user form.
In the Properties sheet, in the Object list, click TextBox1.
On the Alphabetic tab, click PasswordChar.
Type an asterisk (*).
In the Properties sheet, in the Object list, click UserForm1.
On the Run menu, click Run User Form.

2nd Part

Try the following code:-

Please Login or Register  to view this content.

[ShadowsLight]

Where exactly do I put that code?

I have added the Userform exactly as you have said as it seems to be the same instructions I found on another site.

But I am not sure where exactly to put that code.

I tried adding it in, but it still starts Outlook before anything is typed into the Userform.

[Vikas_Gautam]

Sorry, I am not sure about what application are you working with ..
is it Excel or Outlook itself..?

To make a guess, there would a before open event which we can use...

[ShadowsLight]

I am using Outlook.

[ShadowsLight]

To make a guess, there would a before open event which we can use...

Well, "Private Sub Application_Startup()" makes the code run before OUTLOOK opens... however, putting in "Userform1.Show" into that sub routine does not stop Outlook from opening even though the routine is supposed to be Modal. It does stop Outlook from opening if there is no Userform and just the Case Select code is in the "Private Sub Application_Startup()" sub routine.

[Vikas_Gautam]

Can you attach the workbook in which you have implemented the above steps..?

[ShadowsLight]

Um... This is VBA for OUTLOOK. There is no mention of Excel. This is NOT for Excel.

[Vikas_Gautam]

Oh Sorry...!
Let me give it a try .. I will let you know that if I am able to crack it or not..

[Vikas_Gautam]

I got something to consider about ..
Have a look at Namespace.Logon method in the Outlook Vba Help..
See the Password explanation.
http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

I guess we can

Please Login or Register  to view this content.

I guess it will ask for the password its self with a dialogue box having asterik support.

Share your results after testing.

[Vikas_Gautam]

Just try this, we will improve it further..

Please Login or Register  to view this content.

[ShadowsLight]

Um... Is this using the profile password for the user logged into Windows? If so, then this is no good as all 5 users will be logged into windows with the same profile, so the password will be the same. I need a way to create 5 different passwords for Outlook on one Windows User Profile

[Vikas_Gautam]

Are you talking about a profile having many passwords at a time...?
But in the following part, you are using different passwords for the Different profile not the same one.
You are using three different cases as different profile name.

Please Login or Register  to view this content.

[ShadowsLight]

My apologies. I was talking about two different TYPES of profiles...

There will be 1 WINDOWS profile with multiple OUTLOOK profiles.

profile.png

That is just an example from my own computer (where I am testing).

I need Outlook to ask for a Password whenever it is opened and one of those OUTLOOK profiles are chosen. If the password is incorrect, Outlook must close. If it is correct, Outlook can open.

[Vikas_Gautam]

Okay..
So have you tried the code in Post 11...?
I guess it will do the same.
But you have to password protect those profile first.

One sec.
Are you talking about a Programmatic password..?
I mean you are not protecting the profiles with password, instead you want your own password code to ask password...

I believe, the code in Post 11 would be best.

[ShadowsLight]

How do I password protect the OUTLOOK profiles? If I can do that, that will be what I need. But each Outlook Profile needs it's own unique password

[ShadowsLight]

As far as I can see...

You CAN password protect your PST file...

But IMAP (which is what they are using to access their mail accounts) uses an OST file, which you can NOT password protect.



PS. Yes, I have tried the code in Message 11. Nothing happened. Can you please show me the exact code I would need for the OUTLOOK profile "Reuel" to have a password of "12345". Thanks you

[Vikas_Gautam]

Here is the way you can password protect Outlook profiles:-
http://www.msoutlook.info/question/795

you may be interested in this thread as well:-
http://www.experts-exchange.com/Soft..._27900586.html

Read them fully..

[ShadowsLight]

Thank you for your suggestion.

In the first link it says:
Password on pst-file - As I have said before, they can not use PST files as they are connecting via IMAP

Password protect Exchange mailbox - They are not using Exchange

Alternatives
Encrypt your entire disk with BitLockerAs mentioned previously, the protection methods for pst-files and Exchange mailboxes have their limitations. You also can’t password protect data stored in IMAP, Outlook Hotmail Connector and Exchange Active Sync accounts.

Therefore, if you really want to protect your data, consider the following methods or a combination thereof instead.

Password protect Windows.
Lock your computer or log off when you are away (keyboard shortcut: Windows Logo Key + L).
Encrypt your entire disk via BitLocker or a 3rd party tool.
These methods will also protect all your locally stored data and not just Outlook.

I have tried all those methods... none work as required. They all pretty much assume one user is trying to keep his info safe from outside users, not 6 users trying to keep their info safe from the other 5 users.



The other link hides it's answer behind a pay wall that claims to give out a free month, but requires me to hand over my Credit Card details to get my "free" month. I am sorry, but I am not prepared to do that. If you have access, can you please copy and paste the information here? Thanks you for your time