E-mail Report Form

[Rick]

I've built a form in excel and made it a report in
access. It is a hand receipt form that is populated with
data and sent to the printer. All works well. My problem
is that I want to also send the same report form in an e-
mail. What is the best way to send it. I've tried it
using a "Send Object" macro but it only sends the data,
not the form and data together. I want to be able to send
the form with data to the user so they can print it. Any
Ideas?

 

[Steve Schapel]

Rick,

What output format are you using in the SendObject macro? Probably
the only built-in format that will do what you want is Snapshot.
Another option is to print the report to a PDF file.

- Steve Schapel, Microsoft Access MVP

 

[Guest]

Steve,

Thanks for the quick reply. I tried using Snapshot and it
seems to work just fine. I didn't know what snapshot was
until now, thanks for the help.

Rick

 

[Steve Schapel]

Rick,

The only trouble with Snapshot format is that the recipient will need
to have Microsoft Snapshot Viewer installed on their computer in order
to us it. Not everyone has this, and if not it is a free download
from the Microsoft downloads website.

- Steve Schapel, Microsoft Access MVP