Yes, use the button.
It sounds like you should open a recordset containing the employee info.
Loop through the recordset using the data to set the criteria for the
report. No need to change report source.
Then send or print as determined by existance of email address.
Exactly how you export the report depends on what is in it. Bear in mind the
the only built-in Access export method that will retain lines, images, etc.
is the snapshot format.
They would need to download the small, free snapshot viewer from Microsoft.
I have not used it myself in an app as I have been using PDF. You might want
to search the newsgroup postings for more info on it.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
