Need Macro that will create & send emails w/ attachments from a list in Excel

My email application is Outlook 2000. Here is what I am trying to do.

I want an Excel Macro linked to "Button 2" in the "EmailMaster.xls" file that when clicked will do the following:

Create an email for each customer (this sample file contains 3 customers, but my real file has 50 customers).

Column A contains the customer's first name, column B contains the customer's email address, column D contains the text copy that will go in the subject line, column E contains the body of the email, and column F is the PATH of the file that is to be attached to the email.

I have everything working EXCEPT for the attachment piece. Can anyone help?

Thank you in advance for your help.

Figured it out myself. All that was needed was a pair of parenthesis on the ".Attachment.Add" line like this;

Please Login or Register  to view this content.