Access 2003 Acformathtml Error
be down. Please try the request again. Your cache administrator is webmaster. Generated Fri, 30 Sep 2016 00:53:00 GMT by s_hv1000 (squid/3.5.20)
Custom Search UtterAccess Forums>Microsoft® Access>Access Reports OutputTo err 2587 Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code Archive|-- Access Knowledgebase / FAQ|-- Access TutorialsMicrosoft® Access|-- Local Access User Groups (AUGs)|-- Interface Design|-- Access Q and A|-- Access Tables + Relationships|-- Access Queries|-- Access Forms|-- Access Reports|-- Access Macros|-- Access Modules|-- Access Date + Time|-- Access Errors + Error Handling|-- Access Built-in Functions|-- Access Searching + Data Mining|-- Access Records|-- Access Security|-- Access Automation|-- Access Database Container|-- Tool bars, http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other/email-error-2293-in-access-2003-using-sendobject/190d5ca8-5299-4de6-91f2-55adc18a2fe7 Menu bars + Ribbon|-- Access Services (Web Databases)|-- Access Data Access Pages (Deprecated)|-- Access Data Projects - ADP|-- Access Runtime, Packaging & DeploymentAnd More...|-- Microsoft SQL Server|-- SQL Server Reporting Services|-- Microsoft SharePoint|-- Microsoft Internet Explorer|-- Visual Basic 6 and Earlier|-- Visual Basic 2003 and Later|-- ASP and VBScript|-- Web Development|-- PHP, Perl, MySQL and Postgres|-- http://www.utteraccess.com/forum/OutputTo-err-2587-t1553994.html Other Database Engines|-- BI Tools and Applications|-- JAVA and C#|-- GraphicsMicrosoft® Office|-- Microsoft Excel|-- Microsoft Excel FAQs|-- Microsoft Word|-- Microsoft Outlook|-- Microsoft PowerPoint|-- Microsoft FrontPage/Exp. Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- Q & A - UtterAccess.com Forums|-- Q & A - Access Wiki Options eg1View Member Profile Dec 11 2007, 06:06 AM Post#1Posts: 14Joined: 9-November 07From: Perth, Western AustraliaHi THereI am trying to use the outputTo method to export a report to rtf format. It all works fine on a development machine with full version of access 2007, but on another machine using the runtime it throws an error (2587: Can't complete the Output operation).Does anyone have any idea what the problem and more importantly a solution might be here. I have checked my references and as far as I can ascertain they are all in check.CheersEG eg1View Member Profi
sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 12 of 12 Thread: sendobject http://www.dbforums.com/showthread.php?1660389-sendobject-problem problem Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-17-10,12:14 #1 jpadilla View Profile View Forum Posts Registered User Join Date Sep 2010 Posts 5 Unanswered: http://www.fmsinc.com/microsoftaccess/email/sendobject.html sendobject problem Below is a sample of my code which is used to populate a message that must be e-mailed. When outlook comes up, it is seen in the proper format and shows the carriage returns as was formatted by my code. When the access 2003 message is sent, I lose the carriage returns. Can anyone help me with this one? Why is outlook defaulting to plain text when I use the sendobject command? c1 = " The following purchase requisition requires additional approval due to the following reason: " c1b = " [indicate with an X all that apply]" c2 = " [ ] Air Conditioners (DC and Facilities)" c3 = " [ ] Clothing And Jackets(FDC)" c4 = " [ ] Food Purchases (DC)" c5 = " [ ] Furniture(DC And access 2003 acformathtml Facilities)" ... Msg = Chr(13) & c1 & Chr(13) & c1b & Chr(13) & Chr(13) & c2 & Chr(13) & c3 & Chr(13) & c4 & Chr(13) & c5 & Chr(13) m1 = " I, John Doe, approve this requisition on " & Date " m2 = " Requisition: " & Left([fy], 3) & Me![dhs #] m3 = " Description: " & Me![DESCRIPTION] m4 = " Budget Code: " & Me![BCODE] m5 = " Object Code: " & Me![OCODE] m6 = " Total Cost: " & Me![Req Amt] m7 = " Requester: " & Me![CONTACT] m8 = " Suggested Vendor: " & Me![CONTRACTOR] Msg = Msg & Chr(13) & m1 & Chr(13) & Chr(13) & m2 & Chr(13) & m3 & Chr(13) & m4 & Chr(13) & m5 & Chr(13) & m6 & Chr(13) & m7 & Chr(13) & m8 DoCmd.SendObject acSendNoObject, , acFormatHTML, "jpadilla@dot.nyc.gov", "jpadilla@dot.nyc.gov", , "Approval for requisition " & Left([fy], 3) & [dhs #], Msg2, -1, "E:\fiscal programs\req\ReqApproval1.htm" Reply With Quote 09-17-10,12:35 #2 Sinndho View Profile View Forum Posts Moderator Join Date Mar 2009 Posts 5,440 Provided Answers: 14 Try replacing Chr(13) by vbNewLine which is Chr(13) & Chr(10) (or CrLf). Have a nice day! Reply With Quote 09-17-10,12:45 #3 jpadilla View Profile View Forum Posts Registered User Join Date Sep 2010 Posts 5 sendobject problem I tried doing what you suggested but it did not work. It looks like the problem lies with outlook, it keeps reverting back to "plain text". In the sendobject there is an html template option which I am trying to apply. Wo
Visual SourceBook Total Access Speller Total Access Startup Total Access Statistics Multi-Product Suites >> Overview of Suites Total Access Ultimate Suite Total Access Developer Suite Total Visual Developer Suite Visual Basic 6 >> Total Visual Agent Total Visual CodeTools Total Visual SourceBook Total VB Statistics Multi-Product Suites >> Overview of Suites Total Visual Developer Suite Total Visual Enterprise Suite Sentinel Visualizer Total ZipCode Database Catalog and Fliers Product Awards Product Reviews Product User Matrix Pre-Sale FAQs Version Compatibility Chart Language Support User Manuals Order News Announcements Current Newsletter Upcoming Events Product Reviews Media Videos Free Resources Overview Product Demos Microsoft Access Developer Help Center Microsoft Access Query Help Center Microsoft Access to SQL Server Upsizing Microsoft Outlook Tips Technical Whitepapers Tips and Techniques Technical Videos Consulting Overview Success Stories Technical Expertise Microsoft Access About About Us Contact Us Why Choose FMS? Awards Quality Pledge Total Access Emailer Microsoft Access 2016 Version is shipping! New X.7 Versions for Microsoft Access 2013, 2010, and 2007! New X.6 Versions for Microsoft Access 2003, 2002, and 2000 All Our Microsoft Access Products Emailer Info: PDF Factsheet Product Guide Rave Reviews Attach Files to Emails Email MS Access Reports Sending Emails via VBA Distributing Emailer Continuous Emailing Take a Tour FAQs User Manual "I was thrilled with how easy it was to run and I appreciated that I didn't need to build any special tables or queries." Sandra Daigle Microsoft Access MVP More Reviews Additional Info: Compare to the DoCmd SendObject Method Check for Updates License Terms DoCmd SendObject Command in Microsoft Access: Features and Limitations for Sending Emails Sending emails from Microsoft Access databases is a very powerful feature. Disseminating data and reports to your contacts can significantly improve your service and communications, and save paper and postage. Microsoft Access lets you send emails using VBA module code or a macro with the DoCmd.SendObject method. This works for simple emails, but it also has significant limitations. This paper discusses: Purpose of the SendObject Method Syntax of the S