Sending an email from Access 2003 to Outlook 2010

CLOSED
Bids
7
Avg Bid (USD)
$33
Project Budget (USD)
$30 - $30

Project Description:
Hello
I am trying to send an email from Access 2003 to Outlook 2010 (it works if sent from Access 2010 into Outlook 2010)
I get an error message

Run-time error ‘2293’:
Microsoft Office Access can’t send the e-mail message

We will need to remote meet so that you can see my screen and let me know what to fix

Here is the code

Private Sub cmd_Email_Click()
'AR Body email, we need to call the function
Call Modify_Query

Dim stremail As String
stremail = DLookup("AR_Name_Email", "T_Emails", "left(AR_Name,5)='" & Nz(Left(Notes, 5), "") & "'")

‘THIS IS WHERE THE CODE STOPS
DoCmd.SendObject acSendQuery, "AR_email_body_qry", acFormatXLS, stremail, Nz(Me.Biller, ""), , _
Me.Project_Name & " (Project# " & Me.Project & ")" & " (Amount owed > 90 days is " & Format(Me.Over90days, "Currency") & ")", _
vbCrLf & Me.Notes & vbCrLf & vbCrLf & "Thank you", True

Exit Sub
errtrap:
If Err.Number = 2501 Then
Exit Sub
Else
MsgBox Err.Number & " " & Err.Description
End If

End Sub

Skills required:
Microsoft Access, Visual Basic
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 30
in 3 days
Hire Prashantskin
$ 50
in 5 days
$ 30
in 1 days
$ 30
in 1 days
Hire sajivi
$ 30
in 1 days
$ 30
in 1 days
Hire billfan88
$ 30
in 1 days