![]() |
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? |
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