B
bondtk
I've read other posts similar to this, but can't seem to quite get the
response I need so I'll post my specific problem.
Problem: Proposals are sent out to a customer. Eventually they expire if
we never are awarded the work. However, we never update the status on the
proposals to tell if they were canceled or lost so they have this pending
status for a long time skewing reports, etc.
Desired Solution: I'd like to create a query that only pulls a list of
proposals sent out still pending but are like 90 days past the proposal date
(this is the easy part I can already do). Then I would like Access to
automatically email each person responsible for the various proposals in the
query, insert a reminder email date in a table to know when they were last
sent an email reminder (so they don't get one every day but maybe every 7
days past the 90 days). The query would only have the list of pending props
past 90 days with email reminder date no more than 7 days from each reminder
(the reminder date would change after each email was sent out). I'd like the
code to send the email in the background without having the user ever knowing
it went out. I currently have that kind of feature (email in the background)
but for single items shown on a form after a button is pushed. I need this
to loop through an entire query only if it's populated. I think my main
problem is looping through the query as I could tweak my email code within
the loop. (We use Lotus Notes-bummer). Hope someone has some ideas for this
problem.
Thanks,
Troy
response I need so I'll post my specific problem.
Problem: Proposals are sent out to a customer. Eventually they expire if
we never are awarded the work. However, we never update the status on the
proposals to tell if they were canceled or lost so they have this pending
status for a long time skewing reports, etc.
Desired Solution: I'd like to create a query that only pulls a list of
proposals sent out still pending but are like 90 days past the proposal date
(this is the easy part I can already do). Then I would like Access to
automatically email each person responsible for the various proposals in the
query, insert a reminder email date in a table to know when they were last
sent an email reminder (so they don't get one every day but maybe every 7
days past the 90 days). The query would only have the list of pending props
past 90 days with email reminder date no more than 7 days from each reminder
(the reminder date would change after each email was sent out). I'd like the
code to send the email in the background without having the user ever knowing
it went out. I currently have that kind of feature (email in the background)
but for single items shown on a form after a button is pushed. I need this
to loop through an entire query only if it's populated. I think my main
problem is looping through the query as I could tweak my email code within
the loop. (We use Lotus Notes-bummer). Hope someone has some ideas for this
problem.
Thanks,
Troy