Good Morning All,
I have a few stores that don't use PC's and can only use webmail.com for email. I have an excel workbook that will automatically send emails in outlook when one of the sheets is updated, but my stores don't have that option. I in turn created a workbook that they could fill out and send, which really only updates an Access database on a shared network drive. This is great for tracking on my end, but I am now stuck trying to find a way to get the Access database to generate an email when the table is updated.
The database is very simple. The excel document my stores use will automatically add a new row of data in the table "req". I attached a test database with the table set up like the one I use. If there is any possibility of making this happen I'd greatly appreciate the feedback.
**EDIT** Just to clarify, I'd need the email to go the address in the newly updated row in the table, and the first 10 columns of data in that same row would need to populate in the body of the email.
James