Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Send mass email and attach file! (http://www.outlookbanter.com/outlook-vba/8354-send-mass-email-attach-file.html)

barryderay March 15th 06 06:23 PM

Send mass email and attach file!
 
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?

Eric Legault [MVP - Outlook] March 15th 06 08:01 PM

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?



All times are GMT +1. The time now is 05:53 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com