Retrieve data from a form and insert into preformatted excel template

[santad]

Ok I'm totally head stuffed right now.
I've been developing a database to qoute automatically on vehicles for clients. The way we had been originally qouting for these types of lease arrangements where to calculate the figures by hand, then i found a way to create these automatically.

I'm at the point and i'm totally stuck.

I have a preformatted Excel sheet that i email to the clients. I have created a form with subforms in access calculating all the figures i wish to input into these notes.

What i want to do is to setup a command button that will copy the data into an pre-formatted excel sheet for email. Is there a way this can be done?

 

[Coop]

Check your email, I sent you a form that will solve this. You can either copy the code or add the form to you database.