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
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