2

What are the possible solutions to fix the error message "Excel is waiting for another application to complete an OLE action" that occurs while running VBA code to send an Excel sheet through Outlook?

edit

• try
• code

asked 2023-07-16 19:05:06 +0000

plato
56 ●5 ●5

edit retag flag offensive close merge delete

add a comment

1

answered 2023-07-16 19:22:02 +0000

djk
21 ●1 ●1

1. Close all other applications running in the background that may be using Outlook or Excel.
2. Check if Outlook is set as the default email client in the system settings. If not, set it as the default email client.
3. Try using the latest version of Microsoft Office and ensure that all updates are installed.
4. Ensure that the VBA code is written correctly and there are no syntax errors or logical errors.
5. Try disabling add-ins in Outlook and Excel to see if they are causing the issue.
6. Try running the VBA code in Safe Mode.
7. Try repairing or reinstalling Microsoft Office.
8. Verify that the email address entered in the VBA code is valid and the receiver is accepting emails from unknown sources.
9. Check that there are no security measures in place that restrict sending emails through Outlook, such as firewalls or antivirus software.
10. Try using a different email provider or email client to send the email.

edit flag offensive delete link more

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss