Hello,
I am using Ron's code in order to attached a worksheet to an email and send
it out. Now, in the same workbook that the worksheet is (the one I am
emailing out), there is a worksheet called "Data" which houses the email
addresses of all the people I would like to send the email to. The list is
in Column A - starting Row 1 and the list continues to be added to. Each
email address is in its own cell.

How do I incorporate some code to collect all of the email addresses and put
them in the ".to = xxxxxxx"? I only want to sent one email to all of the
receipents.

Any assistance would be appreciated.

Mike