Email when new data added to table from excel

[JHadley]

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

[ranman256]

Build a query that has all the info you want to email
then the command would be:

DoCmd.SendObject acSendQuery, "qsQuery", acFormatXLS, "name@aol.com", , , "Subject", "message"

[JHadley]

Thanks for the response. May I ask, how do you set this up to automatically email the newest row in the query to the email address in the Email field upon update? Wouldn't the code you offered only work if triggered manually?

[June7]

Need code behind a form, possibly in the AfterUpdate event. Can send data as an attachment as shown by ranman but if this is just one record of data, consider:

strMsg As String

strMsg = "This is new data: " & Me!field1 & ", " & Me.field2

DoCmd.SendObject , , , "address", , , "Subject", strMsg