Send report via e-mail - just once

[Steven R via AccessMonster.com]

Is it possible to have a report sent ( maybe scheduled once a week ) just
once - I want to have e-mail sent automatically but only want the records
being printed on the report show up once - say for example I'm sending loan
information out to loan reps on loans maturing in 90 days - I want to send a
report as an e-mail attachment to the appropriate loan rep, listing the loans
expiring, but just once - when the same report gets sent out next day or the
next week, I don't want those loans showing up.

Can this be done somehow ? I'm thinking of a report scheduler, OR having a
field updated on the event of the e-mail being sent - although that would be
tricky ...

 

[Al Camp]

Steven,
Upon reading your post a few times, I think I see what you're trying to
do...
I would add a HasPrintedDate field to the table that contains your
maturing loans data.
Using the same query criteria that you used to developed the report,
create an Update query to run immediately afterwards, that would set the
HasPrintedDate to Date() for those records.
You'll have to alter the query for the report for HasPrintedDate IS
NULL.
Using a HasPrintedDate serves double duty... it's presence or abscence
gives you a boolean value to work with, and the date value itself allows you
to find all those records that reported on a certain week... in case you
might have to do a re-report. You could delete the HasPrintedDate on that
set of records, and re-run a duplicate report.

 

[Steven R via AccessMonster.com]

Al,
I will get started on that - thanks so much !
Steve

Steven,
Upon reading your post a few times, I think I see what you're trying to
do...
I would add a HasPrintedDate field to the table that contains your
maturing loans data.
Using the same query criteria that you used to developed the report,
create an Update query to run immediately afterwards, that would set the
HasPrintedDate to Date() for those records.
You'll have to alter the query for the report for HasPrintedDate IS
NULL.
Using a HasPrintedDate serves double duty... it's presence or abscence
gives you a boolean value to work with, and the date value itself allows you
to find all those records that reported on a certain week... in case you
might have to do a re-report. You could delete the HasPrintedDate on that
set of records, and re-run a duplicate report.

Is it possible to have a report sent ( maybe scheduled once a week ) just
once - I want to have e-mail sent automatically but only want the records

[quoted text clipped - 12 lines]

be
tricky ...