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
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
If [url removed, login to view] = 2501 Then
MsgBox [url removed, login to view] & " " & [url removed, login to view]
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
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
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
Experts in Android, Angular JS, Excel Programming, .NET, web technologies, Androidand iOS mobility solutions
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.
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.
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.
Expert in Microsoft Access and Visual Basic and PDA programming Exeperience of 5 years.