Recent content by Timax

  1. T

    HTML construct shows as plain text in email body

    ok, I figured this out! I changed to .HTMLBody = strMessage and it worked! Thank you
  2. T

    HTML construct shows as plain text in email body

    I just used outside email and still not getting HTML. These is got to be a way to send it as HTML
  3. T

    HTML construct shows as plain text in email body

    Can you please send me CDO that sends HTML? I am using CDO to send but don't see any options for HTML or plain text.
  4. T

    HTML construct shows as plain text in email body

    Thank you, Changed that.
  5. T

    Too few paramaters. Expected 2 in OpenRecordset

    I think post #15 (Use TempVars) is more close to the real solution. Thank you Sir!
  6. T

    Too few paramaters. Expected 2 in OpenRecordset

    I resolved this by replacing form references with TempVars and it worked :) Thank you all!!!!!
  7. T

    Email report in body of email

    Thank you!!!
  8. T

    Email report in body of email

    Thank you for the tip. I export as PDF, Attach and then delete? How do I delete this file after I send?
  9. T

    HTML construct shows as plain text in email body

    I used HTML construct when sending email in email body but receive as a plain text. What am I missing? here is my code: Function BuildHtmlBody(SQLStatement As String, ByVal Name As String) Dim html, State, Qty html = "<!DOCTYPE html><html><body>" html = html & "<div...
  10. T

    Too few paramaters. Expected 2 in OpenRecordset

    Can't do that. I use form references in queries that are way before this final query I use in openrecordset. Form is open. If I use debug.print and put this into query, everything works.
  11. T

    Too few paramaters. Expected 2 in OpenRecordset

    No, no tempvars in presecur. standard form references.
  12. T

    Too few paramaters. Expected 2 in OpenRecordset

    Dim db As ADO.Database Dim rs As ADO.Recordset Set db = CurrentDb sql = SQLStatement Set rs = db.OpenRecordset(sql, dbOpenSnapshot) Anything is wrong here? sql query is no problem when open outside of the function
  13. T

    Too few paramaters. Expected 2 in OpenRecordset

    Form is open. I researched that one first :)
  14. T

    Too few paramaters. Expected 2 in OpenRecordset

    Eval() did not help. I wrapped references with Eval() and query works fine but still same error in OpenRecordset... What else can I try?
  15. T

    Email report in body of email

    Thank you very much for your input on this. My problem is that I need to send report via email automatically and DoCmd.SendTo, opens up mail client. I need to automatically convert report to pdf, attach to an email (with email address that will be coming from complex query) and send it without...
See more
Top Bottom