After SendObject need to set flag in table

[Ste4en]

I have a query that selects all records from tblAFP that have [ReadyforUpload] = true.

A macro runs that query and outputs that list in a spreadsheet attached to an email. This part works fine.

However I would like to insert date in [RecordSentDate] in the tblAFP table, once the email is processed - hopefully as part of the macro or do i need VBA?

thanks

Steve

 

[sfreeman@co.mer]

A simple update query should work fine.

Just update the date field with today's date using the same criteria that you used in the first query.

By the way, I assume that each time you run your e-mail query, you have fresh data in your table. If not, wouldn't you be sending old data along with the newly 'ReadyForUpload' records?

 

[Ste4en]

That worked fine. Just run the email query, filtered for [readyforupload] and then run the next update query to delete the [ReadyForUpload] flag and insert a date.

Thanks,

Steve