Yes, you can do all that, but there's no one function that can do exactly
what you describe. You'll need to code the creation of each e-mail message
(see the CreateItem method), then set the To property or add to the
Recipients collection, then call the MailItem.Attachments.Add method to
attach a file. Finally, you'll need to call the MailItem.Send method.
Note that automating the sending of e-mails will display a confirmation
dialog unless you code the solution in VBA within Outlook 2003. See this for
more info:
Microsoft Outlook "Object Model Guard" Security Issues for Developers:
http://www.outlookcode.com/d/sec.htm
--
Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog:
http://blogs.officezealot.com/legault/
"barryderay" wrote:
Hello,
I have an Access db that has a field designated for email address and one
for the name and location of a file I wish to attach to this email. The
attachment for each email address will be unique. Can I automate a process in
Outlook to send the attachment to every email address in my list?