I'm going to scream so loud my desktop monitor screen won't survive...

I cannot get these simplest of test codes to execute. I'm just trying to open Outlook using vb code behind a button on an Access form. (IMG:style_emoticons/default/crazy.gif)

1) Dim olApp As Outlook.Application

Set olApp = New Outlook.Application

OR

2) Dim olApp As Outlook.Application

Set olApp = CreateObject("Outlook.Application")


I added both the "Microsoft Access 12.0 Object Library" and "Microsoft Outlook 12.0 Object Library" to my References.

All relevant Visible properties are set to "yes".

Both code versions run without errors (my F8/Step Into debugging feature not working is another issue; I have the Special Keys in Options checked. (IMG:style_emoticons/default/pullhair.gif) )....but Outlook doesn't open.

Nothing is working. How could a two line block of code not work. Only Microsoft could make that a reality. (IMG:style_emoticons/default/dazed.gif)

Please rescue me from this limbo before I'm awarded a digital limbotamy.

That is all.

Thank you.

Hi Soule: If you are just trying to open Outlook, with no email creation, you might try something like:



For email creation, more code is required. Let us know if you are trying to create a new email and someone can share the code for that as well.

HTH
Joe

Here's my Outlook button - Access 2003, Win 7 x64, uses reference "Microsoft Outlook 14.0 Object Library". It opens a new email with subject and a signature.


This post has been edited by merlenicholson: Dec 20 2011, 10:26 PM

...or if you just want the email address included in a new email:



...with the [mailaddress] gotten from elsewhere.

Joe

The code is probably working. It is just not doing what you expect. The code creates an Outlook Object in memory. Nothing will be visitable to the end user.

This code you posted is not for opening outlook but for Outlook automation with VBA code. This is normally used to perform actions with Outlook without any user interaction. The user will normally not see anything.