Share via

Application.Dialogs(xlDialogSendmail).Show

Anonymous
2013-05-21T13:37:05+00:00

I'm using Windows 7, Excel 2010, and Novel for email.  The problem I'm getting is that the Novel new email message box does not appear.  Is there a different command I can use in the macro to force an email message to appear in the Novel window?  The error message I get says "Excel is waiting for another application to complete an OLE action".  I checked for add-ins and there is no other application running in Excel.

Thank you for your help!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-05-21T22:33:18+00:00

    Try inserting a mailto: hyperlink in a worksheet cell.

    Does clicking that link launch your mail client?

    If so you can do Sheets("Whatever").Range("WhereTheHyperlinkIs").Hyperlinks(1).Follow

    (change the sheet name and range name/address obviously) to launch the mail client programmatically.

    If not, it would be worth checking that your Mailto: protocol is associated with the correct program.  (e.g. Internet Explorer > Internet Options > Programs > Set Programs > Associate a protocol with a program > Protocols: MailTo

    Was this answer helpful?

    0 comments