Snapshot of report

[Jim Reilly]

I would like to email via code a report in snapshot format using the
sendobject function. It seems as if access vb does not support this format.
Any suggestions?

Thanks,

Jim Reilly

 

[Jim/Chris]

Try this. Watch out for word wrap.

DoCmd.SendObject acReport, "Report
name", "SnapshotFormat
(*.snp)", "toperson", "ccperson", "bccperson", "This is
the subject", "This is the message text", True, ""

'True will open the email before sending. False will send
' immediately

Jim

 

[Jim Reilly]

Thanks for the help. Unfortunately that is what I have
been trying. If I use it in snapshot view, it comes up
with "access can not find the field forms" as an error
message.

If I replace "SnapshotFormat(*.snp)" with acFormatRTF,
everything works smoothly, so I know the forms are okay.

Any other suggestions?

Jim Reilly

 

[Linda Titus]

Go to Microsoft Knowledge Base and get article 307184. It
tells specifically how to code for snapshot format in
sendobject action.

 

[Jim]

The following line works fine, except that the report is
in RTF format, which I do not want.

DoCmd.SendObject acReport, stDocName, acFormatRTF,
eMailAddress, , , "Test"

Substituting the next line of code generates an
error "Microsoft Access can not find the field 'Forms'
referred to in your expression. You may have misspelled
the field name or the field name may have been renamed or
deleted."

DoCmd.SendObject acReport, stDocName, "SnapshotFormat
(*.snp)", eMailAddress, , , "Test"

The only thing that changes is acFormatRTF is replaced
by "snapshotFormat(*.snp). It is not clear to me why it
acts so different,

Thanks for any suggestions.

Jim