Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Email button > using a filter

Status
Not open for further replies.

Bmstenner

Technical User
Jul 22, 2002
88
AU
Here we go:

I have an access database, with several tables, forms etc, on the switchboard, there is a button, subordinate to this i have created a button that will email the data (as a generated report) that is entered into that form to whoever@email.com.

I also have another button which, when clicked will ask for a date and when a date is entered, it grabs that information from a table and generates a report, I can email this by clicking "file > send to email recipient".

How can I implement so when a button is clicked, it will use the days date, generate the report and email it to the specified recipient?

Any help would be appreciated, thanks for your time.


Brendan
 
Base your report on a parameter query.
Point the query parameters to the form where you have the date and recipient displayed.
Check the SendObject method or action...
And that's all...

Good luck
[pipe]
Daniel Vlas
Systems Consultant
danvlas@yahoo.com
 
Hi Daniel,

How would I go about doing this?

Thanks,


Brendan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top