of course, and again of course there are 1000 different ways of doing it.
my flavour of outlook mailer can be found at http://www.dbforums.com/showthread.p...ight=izymailer
(you will need a reference set to the outlook library)
then you have the problem of generating the distribution list. cant help you with macros, but in (DAO) code it goes something like this
private sub SendTheMail()
dim dabs as dao.database
dim recs as dao.recordset
dim distList as string
set dabs = currentdb
set recs = dabs.openrecordset("whateverYourTableIsCalled")
do while not .EOF
distList = !emailaddress & "; "
'kill trailing semicolon-space
distList = left$(distList, len(distList) - 2)
if izymailer (False, distList, "my subject", "my body text") then
Last edited by izyrider; 03-15-04 at 14:56.
currently using SS 2008R2