Automatic generated email

Hello:

First post "woot woot"!

I am looking for a way to generate an automatic email sent to a group. Let me explain in detail.

I have a workbook with two tabs, an active list that is manually updated every day or two and a sheet that completed items are moved to. What I am looking to do is; once an item is moved from the active tab to the completed tab I want to automatically generate an email (in outlook) to a user group stating item XYZ has been completed.

I have already had the user group email established and tested. My VB skills are very beginner, so easier the better.

Thank you