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?