Creating an Excel Spreadsheet from Access

[ChrisJLT]

Hi, I have created an Excel template and want to populate this with
information form an Access table and then email the completed sheet out as an
attachment. Can this be done? If so are there any examples of this I can view?

 

[Arvin Meyer [MVP]]

Sure, it can be done. Have a look at the code to do it:

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