output form as snapshot

[pbrown77]

I am tring to make a code that when the user clicks the button the current record, via report or just a snapshot of the record will be e-mailed.

The below code is currently being used but it says the format is not currently available.


docmd.sendobject acsendform, "frmexp","snapshotformat (*.snp)","brownp",,"TEST","TEST MSG"



Any ideas?

If it must first open a report to export, is there a way to code it that the report will open using the current record only and automatically e-mail. Thereby reducing the need for the user to remember any record id, etc to use as criteria.

Thanks!

 

[Remou]

Hi
I think it should be:
"Snapshot Format"
Not "snapshotformat (*.snp)", as above.