Re: DoCmd.OutputTo

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

To send a report, use this command:

DoCmd.SendObject acSendReport, strReportname, acFormatRTF, strRecipient,
strCC, strBCC, strSubject, strMessage

The string variables can be populated however you want, either from the db,
from code, from the user, whatever.

The two constants, acSendReport, and acFormatRFT are the only things that
are literals.

"Opal" <tmwelton@xxxxxxxxxx> wrote in message
news:44167565-33ba-46b1-9ebc-31d4b5865b4e@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Is it possible to code in VBA a parameter response in order to output
a report in
rich text format?



.

Relevant Pages

  • Re: DoCmd.OutputTo
    ... DoCmd.SendObject acSendReport, strReportname, acFormatRTF, strRecipient, ... I am trying to Output a report ... The report is based on a query with the criteria ...
    (microsoft.public.access.modulesdaovba)
  • Re: DoCmd.OutputTo
    ... DoCmd.SendObject acSendReport, strReportname, acFormatRTF, strRecipient, ... I am trying to Output a report ... The report is based on a query with the criteria ...
    (microsoft.public.access.modulesdaovba)
  • RE: SendObject error
    ... The first thing I noticed was that there doesn't seem to be any report referenced to be attached. ... DoCmd.SendObject acSendReport, REPORTNAME, acFormatRTF, _ ... Public Sub ResetForm() ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access 2003 and Emailing via Outlook
    ... DoCmd.SendObject acSendTable, "Employees", acFormatRTF, myemail@myemail.com, ... > DoCmd.SendObject acSendReport,, acFormatRTF, response ... > EditMessage parameter ... > For more information on SendObject method, ...
    (microsoft.public.access.formscoding)
  • Re: Error emailing Excel attachment
    ... On Jul 20, 9:52 am, Stephanie ... When send an email with at RTF attachment, ... DoCmd.SendObject acSendReport, "Member List", acFormatRTF, Me.EmailName,, ...
    (microsoft.public.access.formscoding)