One solution might be to write code that would loop through a recordset of
today's inbound calls, inserting each person's email address into an email
created in Microsoft Outlook using Automation.
There are a number of gotchas that might catch you out, so I recommend
testing your solution in a non-production environment before going live.
For example, if you plan to send one email to all of today's callers, it
might be best if you put their email addresses in the blind carbon copies
(bcc) field, not the To field - otherwise everyone will get to see everyone
else's email address, which might contravene your privacy policy. This
won't apply if you send one email to one person, so long as you don't mind
having many Sent Items. This might be a better way forward when email
addresses are taken down incorrectly, as you will then need to provide a
means to resolve the wrong addresses and you won't want to stall the
outgoing surveys to other customers whose email addresses are good. You may
need to tidy up your solution with a non-bound form that starts the process.
The form could give you the means to enter a start and end date for the
query that'll be the basis of the recordset. This will give you more
flexibility that processing only today's calls. Finally, after the email
has been sent, you might want to mark the records using an update query so
that a further email isn't sent in future.
I suggest you search the Microsoft website for Outlook Automation code
examples. Alternatively, there is a simple solution starting on page 598 of
the "Access Cookbook" published by O'Reilly. The same book covers creating
recordsets. If you want to start coding Outlook in a deeper way, check out
Sue Mosher's "Microsoft Outlook Programming". (Sue contributes to the
Outlook Newsgroup.)
Regards
Geoff
