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.

Regards,

Bob Mignault
 
 
 

Opening Send Mail form

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

You'll find some notes here.
http://www.yqcomputer.com/

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 - http://www.yqcomputer.com/