How To Auto Open Outlook from Excel

[Launchnet]

I currently use the following code to open any of my 4 types of email accounts, such as hotmail, gmail, juno etc. Now I am adding Outlook and I don't know how to incorporate it into my code.

As an Ex: I have a seperate worksheet that I place the name hotmail.com and the following code will open it. I use a separte cell for each email address along with a separate macro for each email name.

I doubt that I can use this same code. I think that I have to use Outlook.exe ?????

Help would be appreciated.

Please Login or Register  to view this content.

[snb]

Please Login or Register  to view this content.

Your code can be reduced to:

Please Login or Register  to view this content.

[Launchnet]

Good Morning from California

Thanks SNB for your input

When I copied your snb code, the following line turned red.

[CODE]with createobject("Outlook.Application[/CODE]

I also just thought of the fact that I want to open Microsoft Office Outlook.


2nd . . .
In your following code . . .

Please Login or Register  to view this content.

the value in cells (9,5) is: hotmail.com

when I run this macro I get an error message "Run-time error '53':
File not found.

Got any additional suggestions? Need help.

Thanks
Matt

[snb]

I corrected my previous post.

[Launchnet]

Sorry snb

I can not see any posting of a change and the original posting is still the same.

[Launchnet]

I need some Ideas please.

Thanks Matt

[snb]

Maybe some spectacles ?
Please scrutinize again.

[Launchnet]

Hi snb . . .

On the 1st line of your code I found that the closing :} was missing.

I corrected it and copied it from your post.

Pasted it into my code sheetl.

attached a button to Sub snb()

Clicked the button and the circle appears showing that the macro is running. Then the screen blinked and Microsoft Office Outlook was not opened.

Task master shows that the module is running

This is your code I copied from your post.

Please Login or Register  to view this content.

By the way, I am getting new glasses this month.

Please advise.

Thanks
Matt

[snb]

Please Login or Register  to view this content.

[Launchnet]

Now getting . . .

Run-time error '438':

Object doesn't support this property or method

Thanks

Matt

[snb]

Or:

Please Login or Register  to view this content.

[Punter444]

Or:

Please Login or Register  to view this content.

This is working perfect for me, however, I use IBM Lotus Notes 7, any suggestions?

[Launchnet]

Thanks snb

This did the job. I really appreciate it.

I will mark resolved

Thanks
Matt