Email Macro Problem
Posted by jo on February 15, 2002 6:51 AM
I have a macro that sends a copy of the workbook to our secretary. We've put this code in
However, when we click on the button the email shows up w/out her name in the to box. We type it in and she gets it twice. (We can put someone elses name in and still she will get it too). What are we doing wrong?
This is the entire code
'Sends a copy of single Worsheet as email
Application.ScreenUpdating = False
Application.ScreenUpdating = True