Can you make Snapshot format default selection?

[Autoeng]

I have a report which is exported in Snapshot format to Outlook for distribution. I would like to skip the screen where you select the send format. How can I code the button to default to snapshot format? Person who sent report will select email recipients from their address book and the name of the report is fine for the name of the .snp file so I don't need any variables for those.

Thanks in advance,
Autoeng

 

[danvlas]

For Access 2K/XP:
DoCmd.OutputTo acOutputReport, "ReportName", acFormatSNP, "OutputFile", "AutoStartTrueFalse"

For Access 97:

DoCmd.OutputTo acOutputReport, "ReportName", "Snapshot Format", "OutputFile", "AutoStartTrueFalse"

HTH,
Dan

 

[Autoeng]

Found that this will automatically attach the snapshot to an email.

Dim stDocName As String

stDocname = "your report"
DoCmd.SendObject acReport, stDocName

 

[Autoeng]

My above post is incorrect. I forgot to include the Snapshot call. It should be.

Dim stDocName As String

stDocname = "your report"
DoCmd.SendObject acReport, stDocName, "Snapshot Format"