EMAIL NOTIFICATION THAT NEW RECORD HAS BEEN ADDED

[Hiccup]

I have an Access 2000 Form I use for adding a new Record to a Table of "Request" Records. The Form has a "Submit Request" Command Button. The button has a Macro with the "SendObject" command. The Object being an email notification that a Request has been submitted. I get the email and the Record is added to the Table and everything is working great except the email has a Word document attached to it that shows all of the Records in the Table.

What I want is that the attached Word document in the email show only the newly added Record, not all of the Records.

I thought of using a Filter Query to filter out all of the Records except the last one added, but I'm not sure how to set that up.

Anyone have any ideas??

Ed "Hiccup" Hicks

 

[JoeEskimo]

Write a macro that:
Runs the query to show the new record
Exports the query as word doc to a specified location on harddrive.

Now call your SendObject Macro and attach the exported file from above macro.