problem with outlook 2007 in a access 2003 application

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yaman - 13 Jun 2007 14:19 GMT

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...

Reply to this Message

Jerry Whittle - 13 Jun 2007 14:57 GMT

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.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> 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...

Reply to this Message

yaman - 13 Jun 2007 15:08 GMT

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

Reply to this Message

Jerry Whittle - 13 Jun 2007 16:35 GMT

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.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> i am not sure but code behind the button can be is:
> Private Sub cmdePosta_Click()
[quoted text clipped - 10 lines]
> Exit_cmdePosta_Click:
> Exit Sub

Reply to this Message