Thank you for your replies,
I ended up combining the two codes together, sending a copy of the sheet and the CDO code. It works fine but there is a slight problem here. When a mail is sent out, i enclose an attachment to it. The problem here is the first person gets one attachment file, the second person gets two attachment files, the 3rd gets 3 attachment files. This is not right. It keeps on appending the previous to the current one. That's why it keeps on adding depending on the number of people to be sent to. What's right is each persons should get only one attachment file. There is something wrong in the code i may have overlooked.
Here is the code
I even tried to store the filename into the array, myattach but to no avail.
wonder what i have done wrong here.
Thank you in advance
Bookmarks