Email report from form in exported format

[cath_hopes]

hi there!

I've a print button on my form that prints a report version of the same current form. This works fine.

I would like now to add another button to the form that opens the email editor with the report version as an attachment. Since the email recipient is unlikely to have Access installed, I would like this attachment to be in a different file format, .pdf or .snp, for example.

To achieve this I guess I need to use perhaps the DoCmd 'Output To' and then 'SendObject' in the VBA behind my new button. Or maybe a macro? The thing is I don't want to have to save the new format file anywhere unless it can be automatically deleted by the VBA once the email has been sent/ closed. The hard drive will just become clogged with unnecessary files.

Has anyone done something like this /any suggestions?

Thanks in advance,
Catherine

 

[gemma-the-husky]

easiest way is to open the report in preview mode

then you can select file/send (or right click the report and select send)

which will immediately invoke your email client.

--------
if you have a fax avaialble you can also print to the the faxclient in this way

file/print - select the fax lcient

 

[cath_hopes]

Thanks Gemma - I've downloaded Microsoft Snapshot viewer and am using your solution for my all my reports and it works - except for one of them that has subreports. I'm starting a new thread for that.

Many thanks again - I've learned (& continue to learn) so much from this forum.
Catherine