If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
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? |
Ads |
#2
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I attach a meeting request for someone else to send? | HelpNeeded | Outlook - Calandaring | 0 | March 14th 06 05:36 PM |
Moved and need to notify my database. Mass email? | Steve Byrd | Outlook - Using Contacts | 2 | March 2nd 06 08:28 PM |
Can't Attach | Max | Outlook - Installation | 0 | February 11th 06 11:06 PM |
Contacts - Mass "File As" Change | sjs | Outlook - Installation | 3 | January 26th 06 04:47 PM |
File send send Link by Email problems in IE after Thunderbird Install | Woody | Outlook - General Queries | 0 | January 8th 06 12:26 AM |