Opening Send Mail form

Opening Send Mail form

Post by Bob Mignau » Tue, 10 Mar 2009 04:07:17

On my own computer (Windows xp) I use the following code to open the Send
Mail box:

"Application.Dialogs(xlDialogSendMail).Show", and it works fine.

However, on another computer (Vista), I get the following error message:
"Run-time error 1004. Show method of Dialog class failed.

I would appreciate any suggestion to correct the problem.


Bob Mignault

Opening Send Mail form

Post by Michael Sa » Tue, 10 Mar 2009 07:39:18

You'll find some notes here.

What version of Excel is on each PC?

You don't mention it, but that procedure you are using is specifically
for sending the currently open Excel Workbook. It's not a general
procedure for opening a new message window.

Also, what is the default mail program on each PC?


Mike -