D
dbrockedlin
Guest
I have an orders database which uses a main form and a sub form to collect data for orders. My Boss wants me to feed this information to an Excel spreadsheet in specific cells (Its a legacy thing) which he can then e-mail to head office as a purchase order form! I think I should be using a macro to do this but my knowledge in this area is sketchy to say the least!!!! I would like him to be able to press a button and it all happens for him, ie the data is sent from the form and the subform into a spreadsheet (Purchase Order) template and then saved as a particular file name which he can then attach to his e-mail. I'm certain its possible using macros but am at a loss! Can anyone help me?
Many Thanks
Many Thanks
