Sending an email from Access 2003 to Outlook 2010


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

Taidot: Microsoft Access, Visual Basic

Näytä lisää: send email access 2010, access 2003 outlook 2010, access 2003 send email, access 2003 send outlook, access error 2293, error 2293 access 2010, access sendobject outlook error, outlook 2010 access 2003, sending email access outlook, trying function, send email microsoft access, mail outlook, sending email, outlook visual basic, outlook 2013, my ar, mail access, trying get, access project 2010 2013, project 2013 access, visual basic currency, access 2010 project, sending email project, error sending, basic send mail

About the Employer:
( 39 reviews ) Markham, Canada

Projektin tunnus: #4237944

7 freelanceria on tarjonnut keskimäärin 33 $ tähän työhön


We have checked for email sending code you have displayed, I need your database to test further.

30 $ USD 3 päivässä
(277 arvostelua)

[url removed, login to view] I have gone through your project requirements regarding sending an email from access.. I will work in your computer to complete the job within 3-4 hours Please see PMB for details Thanks for your t Lisää

50 $ USD 5 päivässä
(462 arvostelua)

Dear Sir, I'm Ready to help. Best Regards, NourElDeen

30 $ USD 1 päivässä
(18 arvostelua)

Greetings Client I will be able to help you with this project. I have over 7 years of experience in excel,access,vba automation and database development and management. I will be able to provide you with accurate an Lisää

30 $ USD 1 päivässä
(1 arvostelu)

Hi, Interested in your project. Lets discuss and start off with it.

30 $ USD 1 päivässä
(0 arvostelua)

hi I have ten years experience on MS Access. I have done seven Access DB for client in 2012 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. Btw: I were MVP about Micr Lisää

30 $ USD 1 päivässä
(0 arvostelua)

Hi, Access and SQL developer with many years experience.i can do your work perfectly.....

30 $ USD 1 päivässä
(0 arvostelua)