Because Windows Mail is removed from Windows 7 you must install a third party mail program
or use the free Windows Live Mail (also with newsgroups).
I see that a lot of people start using WLM now but Office has a problem with this program.
Note: you have the same problem if you use WLM in Vista
If you set WLM as your default mail program and try to mail from Office you get a general mail failure error
two times, the third time it is working. The reason for this is that Windows Live Mail isn’t fully
MAPI-qualified like Windows Mail or Outlook.
You have the same problem when you want to mail with SendMail in VBA so I want to change all my SendMail
code examples on my site with this workaround but hope you can test it for me before I do that.
Using a loop seems the best way as a workaround.
On Error Resume Next
For I = 1 To 3
.SendMail “”, _
“This is the Subject line”
If Err.Number = 0 Then
On Error GoTo 0
Set WLM as your default mail program first before you test the workbook that you can download here:
When you push the button in the workbook it creates a mail with the active sheet
Note: it will not send the mail it this example but show it.
I like to know this :
Is it working the first time when you push the button?
Is there a better way?
Thanks for testing
Regards Ron de Bruin