E-mailing a current Report view as an attachment

N

NikkiB

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
 
J

jahoobob

NikkiB said:
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
Click to expand...
Try Send To in the macro. I use the Snapshot format as it maintains
all of the Access format.
 
C

Cassie

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

Thanks,

Cassie
 
Top