Email data using Access SendEmail macro action

Question

How can I send email with the last inserted record data using SendEmail macro action? or is this a job only for vba?

Thank You

Answer 1

I'm sitting in Query design mode and trying to figure out how to use Max in criteria. is this possible?

then i was just going to email the query

Answer 2

Something like:

select * from Orders

where OrderDate = (select Max(OrderDate) from Orders)

Answer 3

Ah, SendEmail is available in data macros. You would have to concatenate the Body argument with your field values. Sounds doable, but not something I have done myself.

Answer 4

how do I set query criteria for the most recent date?

Answer 5

I'm not familiar with the SendEmail macro action, but I know there is EMailDatabaseObject. So if you created a report that shows the last record, you can mail it out as a report converted to PDF that way.