Access 2002

  • Thread starter Thread starter Ismail
  • Start date Start date
I

Ismail

I just want to know if there is a function in Access 2002
which enables me to email or fax a report page.
 
Hi,

There is a Method of the DoCmd Object called SendObject:

i.e.

DoCmd.SendObject acSendReport, "rptName" _
, acFormatSNP, "(e-mail address removed)", , , "REPORT" _
, "Please find report attached", True

There are different formats available.

I.e.

acFormatSNP - Snapshot Format (*.snp)
acFormatTXT -MS-DOS Text (*.txt)
acFormatXLS - Microsoft Excel (*.xls)
acFormatRTF - Rich Text Format (*.rtf)

Only Snapshot format will look the same as the report, but the recipient
will need to have Snapshot Viewer installed to be able to read and print the
*.snp file.

HTH

--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/
 
Back
Top