Email Macro Not working right.


Posted by Dee on January 14, 2002 11:49 AM

I have the following Macro in a file that is shared through our Network. (Executes w/a button). It works great most of the time, however, the boss can't get it to work. We use Outlook 2000 for our In-office & outside email. But, when he clicks on the button, the email program that comes up is Outlook express & won't send to anyone inside the office. How can I specify the Macro to use Outlook only?

Sub SendSheet()

'Sends a copy of single Worsheet as email
Application.ScreenUpdating = False
Sheet1.Copy
Application.Dialogs(xlDialogSendMail).Show
ActiveWorkbook.Close SaveChanges:=False
End Sub

Posted by Mark on January 14, 2002 12:46 PM

Check his/her computer to see which program is set as the default program. Sounds like its MOE.

Posted by Dee on January 14, 2002 12:54 PM

Re: I don't understand... What is MOE?

Posted by Mark on January 14, 2002 12:57 PM

Sorry, Microsoft Outlook Express*


Posted by Dee on January 14, 2002 1:41 PM

Thank you. That was the problem.... (NT)




Posted by Mark on January 14, 2002 1:48 PM

Glad I could help**