Export Pre-formatted excel worksheeet?

[specious]

Help please,
I have an input form that is filled out by one department and the information is then e-mailed to another department. The problem is that I need to e-mail a certain format (Pre-formatted form in Excel), but the e-mail export in Access only exports a flat file in Excel format. Is is possible to paste the informatin to certain cells within the Excel file that is being exported? If so, how is it done? Where do I look for tips on how to get started on this?
Thanks in advance.

 

[DBEngine]

One place with some helpful info is at:

http://www.mvps.org/access/modules/mdl0035.htm

--DB

 

[specious]

Thanks DBEngine