problem with outlook 2007 in a access 2003 application

Y

yaman

i have an application in access 2003.there is button which opens outlook and
sends mail in my application. when i upgrade my outlook 2003 to 2007 , i have
problems when i click the outlook button. it has no compile errors or
something like that . it doesn't work. thanks for coming posts already now...
 
J

Jerry Whittle

What does the code behind the button say? I'm betting that it calls on
something like Outlook 11.0. I believe that Outlook 2007 is 12.0.
 
Y

yaman

i am not sure but code behind the button can be is:
Private Sub cmdePosta_Click()
On Error GoTo Err_cmdePosta_Click
Dim txtePostaMsj As String
Dim txtAlici As String
txtAlici = Me.ePosta
txtePostaMsj = "Mr " & Me.firstname & " " & surname
If Me.email <> "" Then
DoCmd.SendObject acSendNoObject, , , Me.ePosta, "*****@******", ,
"****", txtePostaMsj, True
End If

Exit_cmdePosta_Click:
Exit Sub
 
J

Jerry Whittle

txtePostaMsj = "Mr " & Me.firstname & " " & surname

I would think that you need Me.surname in the line above.

Other than that, I really don't see any problems. However the code does not
open Outlook. It uses Outlook if it is already open. Make sure that Outlook
2007 is open and connected then run it.
 
Top