G
Ginger
I have a report in an access 97 database that has a 300
page report. Each page needs to be emailed to the
corresponding employee, if that employee has an email
address. If he does not, then it needs to be printed.
Can each page be emailed to each through OutLook or does it
have to be exported to EXCEL, then emailed? I need to know
the best method for doing this. Should coding go in the
page event or in the click event of the button that brings
up the report. I am thinking that it should probably be in
the click event.
and one more question...should a loop be done for changing
the SQL for the datasource for the report as it goes to
each new record? Like this:
do until eof
report.datasource = sql "where it filters for the employee
for the row it is on"
email report
I haven't had any experience with the email in ACCESS and I
know ACCESS 97 is an older version that can't do as much as
the newer versions.
Thank you in advance for your assistance.
Ginger
page report. Each page needs to be emailed to the
corresponding employee, if that employee has an email
address. If he does not, then it needs to be printed.
Can each page be emailed to each through OutLook or does it
have to be exported to EXCEL, then emailed? I need to know
the best method for doing this. Should coding go in the
page event or in the click event of the button that brings
up the report. I am thinking that it should probably be in
the click event.
and one more question...should a loop be done for changing
the SQL for the datasource for the report as it goes to
each new record? Like this:
do until eof
report.datasource = sql "where it filters for the employee
for the row it is on"
email report
I haven't had any experience with the email in ACCESS and I
know ACCESS 97 is an older version that can't do as much as
the newer versions.
Thank you in advance for your assistance.
Ginger