"Mo" wrote in message
...
1-the sheets are not automatically emailed, I have to go into Outlook and
send. However, nothing is happening. I don't received the emails (I have
a
Yahoo account).

Sounds like you have a wrong email address.

2-The emails are not deleted after being send (I assume the macro does
that).

No it doesn't. It kills the file it creates, but it doesn't delete the
email. It doesn't know what mail client you are using.