Sending a record to a report for formatting, and then emailing it.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Access 2000, and trying to update a database I inherited. At present, there's a form in which you select one or more criteria (employee, team lead, case opening date, etc.) to determine which records are displayed in a subform in the lower part of the form. If you want to edit a record, you can then select the record and click a button, which opens another form and loads that record into it (this newly opened form is also the one used to create new records). I hope that makes sense...

Anyway, I have been asked to make a change so that once a record is sent to the second form, the user can click a button and email that record. I have played with the SendObject function, and can get it to attach the record in one of the available file formats, but it shows up in table format and is really ugly. I want to be able click the button and have the record sent to a report (the template for which I already have), and then be able to email the report in .snp or .rtf, since it's just a lot easier to read. I don't, however, know how to do that. Help?
 
An easy way to do this is:
1.) After you ahve your report ready make a macro that
will use SendObject Action and then in arguments you will
set the rest of it, like a report, name of report, output
format , etc..
2.)make sure that report that will get a correct record
and then from the form that you you need to email this
make a command button then runs that macro.
That is it.

-----Original Message-----
I'm using Access 2000, and trying to update a database I
Click to expand...
inherited. At present, there's a form in which you select
one or more criteria (employee, team lead, case opening
date, etc.) to determine which records are displayed in a
subform in the lower part of the form. If you want to edit
a record, you can then select the record and click a
button, which opens another form and loads that record
into it (this newly opened form is also the one used to
create new records). I hope that makes sense...
Anyway, I have been asked to make a change so that once a
Click to expand...
record is sent to the second form, the user can click a
button and email that record. I have played with the
SendObject function, and can get it to attach the record
in one of the available file formats, but it shows up in
table format and is really ugly. I want to be able click
the button and have the record sent to a report (the
template for which I already have), and then be able to
email the report in .snp or .rtf, since it's just a lot
easier to read. I don't, however, know how to do that.
Help?
 
Back
Top