automate Excel data-random cells to Access dB table

[Mister Wayne]

I have an automated (VBA) Excel 2007 sheet to allow employees to enter parts request information.
When they are finished, they click a <SAVE> button which does the following:
1. Saves the file by a specific filename based on user data entered in several cells.
2. Sends me an email with pertinent information so I can process the order.

I would like to add code in the <SAVE> event which would also add a new row in the table of an Access data base (not opened-if possible) and copy specific cells information.
It would always be the same cells, but not necessarily in the same row/column. The database table would always contain the same column information from the same cell.
I.E. "E7" = name; "E8" = user's email address; "E9" = date; "E10" = Customer's name; "E11" = Job number.
I know this example has contiguous cells, but there are more I didn't include and I would like the flexibility of choosing by individual cell as this is a new venture and I may not always have any contiguous cells.

I'm fairly handy using VB code but the concept is foreign. I used the Microsoft CDO object to send the email.

Any help appreciated!!

Thanks so much,
Mister Wayne

 

[Mister Wayne]

I'm really new to this... Can someone help me better explain the process, or ask the questions?
Thanks!

 

[sergioMabres]

Here an excellent sample code to insert a record into Access mdb data base from Excel
Cheers
Sergio

https://www.mrexcel.com/forum/micro...visual-basic-applications-form-access-db.html

 

[Mister Wayne]

Sergio,

THANKS so much! The link--and subsequent links, are going to help me get this project going!
I am on the work-release plan... When work releases me, I can delve into this project. LOL!

I may come 'calling' again once I start coding if things don't seem to be flowing well.
But, this is certainly a start.

Best wishes to you and thank you again!
Wayne