One Button To Msg Box, Export To 2 Places, Email, And Reset Values :S

Hey all,

I've attached my access file...if anyone could help I would appreciate it very much!

If you click on the Export & Email tab on my form, there is a button which describes what i want to do in the caption.

Basically...

When the button is clicked i want a warning message box to appear saying do you want to continue Yes/No. No would just cancel it.

Yes would do the following:

Export an Excel file of "Magtable" and save to C:Magazine BackupMagazine Counter.xls and W:Magazine CounterMagazine Counter.xls

Then (i dont think the order of the following matters)

Email the excel file to two people.....if its easy to do this with no data input needed by the user (ie: not having to type the subject, who its too, body or press send.....if this is too complex then that is fine..having as much in as possible would be good though)

Then I want the values in Magtable, Amount to be reset to 0 - this may have to be done before the email is sent?

BTW the company i work at uses Lotus Notes only as an email program....As long as it pops up a new email in lotus notes with the excel file as an attachment then that would probablly be enough.


Hope this makes sense :S Any help would be VERY appreciated!

Thanks!
Acs