Hi - I found the following and am trying to use it to copy my excel sheet from 2010 and mail (display) it using Outlook 2003 (don't ask about the old Outlook version

I'm not a VBA expert, so don't know what is going wrong, however the sheet 'standard' is not being copied (I need to copy, paste special as there are numerous formulas on the sheet) AND excel is closing as part of the email routine. Can anybody tell me what I am doing wrong?

Thanks in anticipation

Code :

Please Login or Register  to view this content.