Suljettu

Sending an email from Access 2003 to Outlook 2010

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

Taidot: Microsoft Access, Visual Basic

Näytä lisää: send email access 2003 outlook 2010, access 2003 send email outlook 2010, send email access 2010, access 2003 outlook 2010, access 2003 outlook 2010 send mail, 2293 access 2003 outlook 2010 send email, access 2003 call outlook 2010, error number 2293 outlook 2010, access 2003 send email, access 2003 send outlook, access 2010 error 2293 access send mail, access error 2293, microsoft access send email outlook 2010, error 2293 access 2010, email access 2010 outlook 2003 2293, sending email access 2010 outlook 2003, docmd sendobject access 2003 outlook 2010, error 2293 microsoft access 2003 outlook 2010, access 2003 send outlook 2010, access sendobject outlook error, outlook 2010 access 2003, sending email access outlook, access 2003 mail outlook 2010, access 2010 send email outlook 2010 code, we trying to function

Tietoa työnantajasta:
( 39 arvostelua ) Markham, Canada

Projektin tunnus: #4237944

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

illuminesoft

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)
7.5
Prashantskin

[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)
6.9
NourElDeen

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

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

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)
2.0
amitchaps

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

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

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)
0.0
sajivi

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

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