$$Excel-Macros$$ change something in the attach macro

in the attachment, there are three email addresses in the macro, when i click on tab in sheet1 it sends this file to only one email, the last one, can anyone change this macro when i click on tab, it goes to all the email addresses. Thanks in advance -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E

Re: $$Excel-Macros$$ change something in the attach macro

In your macro, the lines:     Recipient = "a...@yahoo.com"     Recipient = "def2...@yahoo.com"     Recipient = "g...@yahoo.com"     means that the variable called "Recipient" is assigned "ABC", then immediately OVERWRITTEN with "DEF" and again overwritten with "GHI".  I believe a list of email ad