Hoefully this is an easy one. I have a website which is used to track business opportunitites for the company. Salespeople add any potential work to this database so all can view it. It is a Frontpage 2003 site with two access databases (one for each of our two companies). Users enter data via forms and it all works great.
Our MD has requested to be able to email the contents of the database to a 3rd party at any given time. He does nto want them to have access to the live site. Ideally he would press a button, the data would be downloaded into a file (preferably Excel or PDF), open a new email for him and attach the file. There are never more than 20 -30 records in the file.
Don't know the best way to do this - possibly using access reporting on the site? The only way I can see to do it is map a drive to the actual MDB file on his machine and have him email it using the Access frontend - not nice.
Any help would be great.