Automate email and attach excel worksheet or workbook

[wilma2299]

I'm trying to create a macro in Outlook that will send an email with
an excel attachment. I have a list of different excel files and each
file needs to go to a specific person. i.e. To: Joe Smith Attachment:
Joe Smith.xls and so on. Is this possible?

 

[Michael Bauer [MVP - Outlook]]

Simply create one MailItem per recipient with the CreateItem function, then
use Recipients.Add and Attachments.Add.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Quick-Cats - The most effective way to assign Outlook categories:
http://www.shareit.com/product.html?productid=300120654&languageid=1
(German: http://www.VBOffice.net/product.html?pub=6)

Am 11 Apr 2007 20:07:32 -0700 schrieb wilma2299:

 

[wilma2299]

Thank you for the quick response. I was hoping to create a generic
macro that would do everything and not have to go through and create a
macro for each person.

 

[Michael Bauer [MVP - Outlook]]

That's what I told you One macro can create as many items as you like.
And you would need one for each recipient if everyone should receive
different attachments.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Quick-Cats - The most effective way to assign Outlook categories:
http://www.shareit.com/product.html?productid=300120654&languageid=1
(German: http://www.VBOffice.net/product.html?pub=6)

Am 12 Apr 2007 04:44:28 -0700 schrieb wilma2299: