You can automate Outlook to do this; there's quite a bit of code floating
around that'll show you how to do this. A good place to start is here:
http://www.granite.ab.ca/access/email.htm
Generally speaking, you build a recordset of all your recepients and their
associated data, iterate that recordset via a loop, writing and sending a
new email message for each person. Several of my apps have this type of
functionality builtin; however, I don't use Outlook for this. Instead, I
purchased an 3rd party tool (
www.codestone.co.uk) that I use in virutally
every application. Since then, I haven't had any email issues, I can send
attachments, multipart messages, etc etc. You can also do this in Outlook (I
believe) but for the 79 USD price tag for CSMail, it just wasn't worth
taking the time to learn these things via Outlook. Plus, my code isn't
dependant on what version of Outlook is on a particular machine, I don't
have to worry with the security issues surrounding Outlook, etc.
We want to send out a monthly email to a select group of our customer (about
200 each month) and we also want to list all of the different products
they've ordered. Getting the data together is the easy part, but how would
we send this out in an email? We would also like to send the emails
directly to the Outbox (who wants to click send 200 times?). I can set up a
report to display the data, but I'm not sure what can be done after that by
Access and also how to do it. Can the data in the report be the body of the
email? Even though there is one customer and multiple products? Any
suggestions on this would be greatly appreciated!
