Emailing through Outlook 2007 Help!!

[huskerphil]

I'm pretty new to visual basic and need a little help figuring out this problem. I'm currently using Access 07 and Outlook 07. I have a button on a form that when clicked will send a email message through Outlook to certain recipients. The problem I'm having is that I have Outlook being created every time the button is clicked. It works fine when Outlook has not been opened yet, but when it is already opened and minimized the code will create another session of Outlook. My question is this; Is there any way to check to see if Outlook is currently running and if it isn't create another session but if it is not to create another session? Thanks!

 

[huskerphil]

I meant in the last part that Access will check to see if Outlook is running and if it is not it will create a session and if it is to leave it alone and not create anything. Thanks!

 

[scliffe]

Can you put the code you're using into your next post? It appears (to me...) that its launching Outlook then sending the e-mail.

 

[Remou]

You can use GetObject with a running application:

On Error Resume Next
Set oApp = GetObject(, "Outlook.Application")

If Err.Number <> 0 Then
    Set oApp = CreateObject("Outlook.Application")
End If

 

[huskerphil]

Thank You Remou, the code worked great.