E-mail Report Results (1 Viewer)

[Capilano]

Is it possible to e-mail an Access Report? Our staff waste alot of paper by printing the Report off and then having to fax it. This is very wasteful, expensive and time consuming.

Any suggestions would help.

Pat

 

[BukHix]

You can use the SendObject command and there are many arguments that you can use so it may be helpful to look it up in the Help file for specifics. Here is a sample to get you started:

    DoCmd.SendObject acReport, "ReportName", "RichTextFormat(*.rtf)", _
        "someone@somewhere.com", , , "Optional Subject", "Optional Text", True
        
    '"ReportName" = Put your report name here.
    '"someone@somewhere.com" = Email Address.
    '"Optional Subject" = Optional text for subject line.
    '"Optional Text" = Optional text for the body

 

[Capilano]

Thanks very much. I will give it a try.

Pat

 

[Baldrick]

Does anyone know if you can use this for an Outlook Distribution List (replacing someone@somewhere.com with DL.Everyone.Everywhere)?

 

[David Mack]

Rich Text will not always retain the formatting of your report. I recommend sending the report in snapshot view instead. The report looks great, takes up only a few Kbytes and cannot be altered by the end user...

 

[DocManDobie]

THIS is the exact e-mail type you need, follow this hyperlink
http://www.mvps.org/access/general/gen0010.htm

The form gives a drop down to choose an attachment, ie, report, table, query or blank e-mail, then to, cc, bcc and a drop down which will display all your e-mail contacts. I reccon it even works better that outlook by far. Have a go its an amazing e-mail form. When you import it, goto the drop down for the TO field, in properties goto destinct source and change i to your table and the field which contains the e-mail addresses.

You also have the option to e-mail as RTF, TXT, HTML etc

Have fun

[This message has been edited by DocManDobie (edited 02-28-2002).]

 

[BukHix]

Does anyone know if you can use this for an Outlook Distribution List

Yep I do it all the time.

 

[steffenn]

If you have Adobe, you can do the following:
Go to FILE then PRINT.
Change the name of your printer to ACROBAT PDFWRITER and click on OK. You will be asked where to store the information (identify the folder(s) and file name). This will create a PDF file. It can now be sent as an attachment to an email.