Email a form/report

[Guest]

I am not versed in coding and inherited an Access database that was setup with a data entry form for HR to use to record and disseminate information about New Hires. The dissemination is via email (a button on the form). The user can also print the record (another button on the form).

1. When the email button is clicked, Access attaches a report to the email.
a. One problem I have is that if I click the email button after completing data entry on the form, a blank report as well as the actual report are generated and attached to the email. Can you help determine how to eliminate this?

b. Another problem is that the output, regardless of whether I specifiy html or rtf or doc in the code, does not include a border around the information as is visible in the report output. It seems to strip it off the email attachment as well as the printed version. Any suggestions on including the border on the printed form and on the email attachment?

Thank you.

 

[DellaCroce]

Tahir,
I don't have a solution for you but I was wondering if you could help
me. I need to set up a similar situation of creating a report, saving it
to disk, then attaching it and send it out via Email. You seem to have
done most of that coding for your application. Could you show me the basics
of how. Then in implementing them, maybe I could help you with your
problem.
Thanks
Greg

I am not versed in coding and inherited an Access database that was setup

with a data entry form for HR to use to record and disseminate information
about New Hires. The dissemination is via email (a button on the form). The
user can also print the record (another button on the form).

1. When the email button is clicked, Access attaches a report to the email.
a. One problem I have is that if I click the email button after

completing data entry on the form, a blank report as well as the actual
report are generated and attached to the email. Can you help determine how
to eliminate this?

b. Another problem is that the output, regardless of whether I

specifiy html or rtf or doc in the code, does not include a border around
the information as is visible in the report output. It seems to strip it off
the email attachment as well as the printed version. Any suggestions on
including the border on the printed form and on the email attachment?