View Single Post
  #2  
Old March 15th 06, 08:01 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default Send mass email and attach file!

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?

Ads