problem with outlook 2007 in a access 2003 application

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top