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.