I've searched the threads for a couple of days, and while I found some that came close to answering my question I thought I'd finally just post it and either get some responses or links to what you think are relevant responses.

I have a form in Access that once complete I want the user to hit a button and it saves that form's data in Excel and automatically re-names the new Excel file based on a combination of fields in the form (ie. date, cust_nbr, etc). Then I want to email that form (excel file?) to several people. Then I'd like a message box in access to say something like "Form Successfully saved at (folder/file location) and emails sent to person1 & person 2".

I know that's a lot of different stuff going on there, so perhaps we just start with the first one - code to save as excel and auto-name the form (also once this works I want the form to be blanked-out and ready for a new entry).

I'm pretty new to VB so any help or at least direction would be appreciated. Thanks!