How to check if Hotmail is already open using macro

[Launchnet]

I use the following code at the begining of each macro that opens an Excel File. What I am looking for is to some how incorporate a procedure like this to check to see if the email that I want to open is already open or not.

NEXT, look at the 2nd set of code.

Please Login or Register  to view this content.

The following code is currently what I use to open my 3 email accounts. This sample is for only 1, which is my hotmail account.

Next, see below this code.

Please Login or Register  to view this content.

This eMail code gets the name of the eMail and .com . . . EX: Hotmail.com from a sheet in the workbook named Setup from cell E8.

I know how to check to see if a file is already open or not, (don't want it opened 2X). BUT . . . How do I check to see if Hotmail or whatever email of the three I'm referring to is open or not.

[Chippy]

Have a look at ShellWindows.

[Launchnet]

Hi Chippy . . .

I've finally had the time to search for a solution in Shell Windows. This is an area I'm not very strong in and I don't find anything to do what I'm requesting.

More Help needed.

[royUK]

This works with gmail, I can't test it with hotmail. Give it a try by changing where indicated. It doesn't need to check it sends the email with the attachment automatically

Please Login or Register  to view this content.

[Chippy]

I've finally had the time to search for a solution in Shell Windows. This is an area I'm not very strong in and I don't find anything to do what I'm requesting.

Try these, launchnet:
http://www.vb-helper.com/howto_list_shell_windows.html
http://vba-corner.livejournal.com/4623.html

[Launchnet]

Good Evening . . .

Thanks for the suggestions & Code.

I haven't had time to RoyUK's code yet, but I do want something like this. I may even use it with gMail.

I still need to have code that can check to see if the email program that I want to open is already open or not.

Please see my original sample code.

[Marsig]

To begin, sorry for my english ...
I do not know if this is still useful, but was doing some trial and to use this code in hotmail you can put as STMP "smtp.live.com" and port "2"
Hope this helps someone!

Good Evening . . .

Thanks for the suggestions & Code.

I haven't had time to RoyUK's code yet, but I do want something like this. I may even use it with gMail.

I still need to have code that can check to see if the email program that I want to open is already open or not.

Please see my original sample code.