E-Mailing an Acces Report (PDF FORMAT ?) 1

[Berny33]

I want to send Access Reports by E-Mail (orders to suppliers) with the exact same graphics settings than i'm able to have on paper...

I use the commande line below :

DoCmd.SendObject acSendReport, stDocName, acFormatRTF, Recipient, , , "ORDER FROM [company name]", "Good day from " & Username & "...", True

The RTF format is superb but no graphics are going thru. HTML format is worst because it is almost impossible to align the fields and columns (no graphics either). So i was thinking of other possibles solutions. Does anyone knows if it would be possible to use about the same code but to change the document format to so PDF using ADOBE ACROBAT ?

NOTES: of course, orders are sent to the suppliers as an attachment.

Thanx in advance...

 

[JohnLowell]

The best bet would be to use the Access Snapshot.
It is free from Microsoft. The end user would also need to have Snapshot installed to view the report.

If you really want to send your reports as PDF, you have to have Adobe Acrobat (the full version) installed. This would install the Distiller or the PDFWriter as printers. You would then direct your reports to print to one of these printers.