Automate sending

[snappl3]

I'm working on a database for suppliers and they have to fill out a checklist
for our records. Is there anyways I can automate Access to send out this
file via outlook 6 months prior to when their last checklist is going to
expire? Help??? Thanks in advance for the input!

 

[Daniel Pineault]

One approach would be to setup an AutoExec macro to call a sub/function with
would run a query to check which record fall within your criteria and then
for each one send an e-mail using the SendObject Method.

This check would then get run everytime the db is opened. So you'd need to
log e-mails in a table to avoid multiple e-mail get sent (but this can easily
be integrated into your based query)

If you need more detailled help just let me know.

 

[Steve]

hi i was just reading your responce to this question and i must say i agree
with you i have been doing exactly that for a very long time and it has been
working very well untill recentley. and it has just stoped working it sends
the first mail just fine and then it just loops through the rest but dos not
seem to activate sendobject at all and the mail is not sent.
i was wondering if you could offer me some assistance with this as i have
been searching for a long time and have not found a solution yet.