Sending an email from Access 2003 to Outlook 2010

Budget N/A
Bids 7
Average Bid $33

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

Post a Project Like This

Looking to make some money?

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

Bids on this Project

  • sajivi Profile Picture

    sajivi

    colombo,  Sri Lanka

    I have experience within the following areas: PSD to Joomla, PSD to HTML, Web designing, Graphic designing ,Logo designing and data entry(MS - Office)., expert in Photoshop, Coral Draw , I can work hard and Also honest person... Career Summary • A dynamic network professional with extensive knowledge of networking possesses rich experience of one year as network technician and assistant network administrator. • Excellent in implementing innovative and tailored solutions to meet the changing business requirements. • Expert in providing the best solution and troubleshooting the network. • Excellent in configure and implement Remote Access Solution. • Advanced knowledge of creating and deploying internal and external wireless and VoIP network Key Responsibilities Handled • Install, configure, and maintain network services, equipment and devices. • Install and configure windows servers (2003,2008,2012) • Documents network problems and resolution for future reference. • Manage user accounts, permissions, email, anti-virus and anti-spam using Active Directory • Build and maintain Visio documentations for Clients • Investigating, diagnosing and resolve all network Related Issues • TCP/IP Ethernet Networking • DHCP and static IP addressing • Wireless Networking Technical Experience- • Operating Systems: Windows XP, Windows Vista, Windows 7, Windows 8/8.1Linux, UNIX, • Hardware testing Tools: Multi meter, cable tester, Card tester, soldering de-soldering. • Application software- Photoshop, Adobe reader, Office Package

    Data Entry, Engineering, Photoshop, and Advertising

  • billfan88 Profile Picture

    billfan88

    Yangzhou,  China

    Relative project experience. 1:CITIC BANK OF China’s Office Automation System; (We set up a workflow System in SQL2012 database by ASP.net of C#) 2.DHL international express company (We set up a workflow system inside DHL.) Contact info: MSN: Skype: Hruisoft Yahoo message: Hruisoft Tel: 86 514 85118155 Mobile: 86 15952799509 web site: www.hruisoft.com

    ASP, Visual Basic, .NET, and Windows Desktop

  • amitchaps Profile Picture

    amitchaps

    Pune,  India

    Experts in Android, Angular JS, Excel Programming, .NET, web technologies, Androidand iOS mobility solutions

    PHP, JSP, .NET, and Mobile Phone

  • illuminesoft Profile Picture

    illuminesoft

    Solapur,  India

    Successfully finished over 430 Microsoft Access Database projects and 50+ .net/other projects. IllumineSoft is established in 1999. Illuminesoft is Intellisoft in India. The company has developed a number of database applications for Hospitals, Doctors, Trading Businessmen, Service Industry, Marketing Companies, Farm Houses, Pharmaceutical Drugs Trading, Chartered Accountants, Canvassing Agents, Libraries, Medical Service Company, Wood Logs Cutting Industry, Municipal Corporation, Web Searching Engine/Yellow Pages, CAD/AutoCAD, Day Care/School , strongly believe in quality engineering work. We train our staff to adopt all Software Engineering methodologies to develop Quality software. We have access to consultations of experts in software, medical science, Engineering science & technology, and textiles from India and abroad. We worked on more than 495 outsourced projects, with a team of more than 5-12 developers. We have more than 150 satisfied customers in about 23 countries.

    Javascript, XML, Adobe Flash, and Visual Basic

  • NourElDeen Profile Picture

    NourElDeen

    Cairo,  Egypt

    I Work As .Net Developer. Have Good Experience on C#,C++,SQL,Access,Windows Applications. Do the task with the lowest price and with the highest quality.

    Visual Basic, .NET, Linux, and Excel

  • mukulsinha25 Profile Picture

    mukulsinha25

    New Delhi,  India

    Looking forward to perform in data analysis, VBA tools development, data mining,automation using excel,access Over the past 7 years i have worked on buiding Tools and Models using MS Access along with VBA Code.I have automated projects in Excel using VBA. I have indepth knowledge of SQL Server.Accuracy,consistency and Creating Robust project is my strength and i certainly believe i can use them to excel in the projects.

    PHP, Visual Basic, .NET, and Data Processing

  • Prashantskin Profile Picture

    Prashantskin

    Bhavnagar,  India

    Expert in Microsoft Access and Visual Basic and PDA programming Exeperience of 5 years.

    PHP, Visual Basic, Data Processing, and Data Entry