Closed

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
Employer working
Skills Required
Project Budget
N/A
Total Bids
7
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
[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
errtrap:
If [url removed, login to view] = 2501 Then
Exit Sub
Else
MsgBox [url removed, login to view] & " " & [url removed, login to view]
End If

End Sub

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