Sending an email from Access 2003 to Outlook 2010

This project received 7 bids from talented freelancers with an average bid price of $33 USD.

Get free quotes for a project like this
Project Budget
Total Bids
Project Description


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), "") & "'")


[url removed, login to view] acSendQuery, "AR_email_body_qry", acFormatXLS, stremail, Nz([url removed, login to view], ""), , _

Me.Project_Name & " (Project# " & [url removed, login to view] & ")" & " (Amount owed > 90 days is " & Format([url removed, login to view], "Currency") & ")", _

vbCrLf & [url removed, login to view] & vbCrLf & vbCrLf & "Thank you", True

Exit Sub


If [url removed, login to view] = 2501 Then

Exit Sub


MsgBox [url removed, login to view] & " " & [url removed, login to view]

End If

End Sub

Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online