E-mailing a current Report view as an attachment

[Guest]

Hi,

I have a form where users enter information. On the form I have a command
button that opens a report in print preview for only the selected record(Used
VB script found in this MS Forum.)

Now I want send the selected record as an email attachement after the Report
is printed. I tried using an Output to Macro linked to a custom menu button
but it is attaching all the data on the report rather then just the current
record. Is it possible to filter the output to just attach a report for the
current record?

In case your wondering why? This Database will be used in our Receiving area
to log packages received, print a lable for the package, and then send out an
e-mail communication to advise the recipient of the package recieved.

I am new at creating Access Databases to be used by other people. Any help
is greatly appreciated.

Thanks,

NikkiB

 

[Guest]

The snapshot format works! Thanks so much for the help!

 

[Guest]

I am trying to do the same and would like to know where NikkiB found the VB
script in this MS Forum.

Thanks,

Cassie