Snapshot viewer

[PeDa]

How do I generate a Snapshot Viewer file of a report based on a programatically generated query (i.e. a report I can't just open in Preview mode and then choose File | Export ...). I now print these reports and distribute photocopies, but would now like te distribute them by e-mail (to my customers who don't have Access thenselves).

 

[Remou]

Hi
Have you checked out SendObject?
[tt]DoCmd.SendObject acSendReport, "Report1", acFormatSNP, "EMailTo", "CC", , "Email Subject", "MessageText", True[tt]

 

[PeDa]

Hello Remou,

Yes indeed. My problem is: in the situation I describe, when should I envoke SendObject? My report only comes briefly into existence when I programatically set Me.RecordSource in the Report_Open event. Should I envoke SendObject in some report event?

Best wishes,

Peter D.

 

[Remou]

Sorry, reading was turned off, probably still is Here are a couple of ideas. If you can use Outlook, you can save your Snapshot and send it as an attachment.
If the query is being generated programmatically, can it be use to change the report, rather than putting it in the on open event? For example:

Set rpt = Reports("Report1")
With rpt
    .RecordSource = "MyQuery"
End With
DoCmd.Save acReport, "Report1"

 

[dRahme]

DoCmd.OutputTo acOutputReport, "YourReport", acFormatSNP

 

[PeDa]

The suggestion from dRahme is indeed the answer; thank you both.

Best wishes,
PeterD