Hello,
How to make my code below work well under Outlook, also works well in Excel?
Thank you for your help.
code.JPG
Hello,
How to make my code below work well under Outlook, also works well in Excel?
Thank you for your help.
code.JPG
You are putting an obstacle in the way of the people who might have a solution. Put code not a picture of code.
To debug, mouse-click anywhere in the code. Press F8 repeatedly to step through the code. http://www.cpearson.com/excel/DebuggingVBA.aspx
If your problem has been solved in your thread, mark the thread "Solved" by going to the "Thread Tools" dropdown at the top of the thread. You might also consider rating the thread by going to the "Rate Thread" dropdown.
Use the same method as I showed in answer to your other recent thread. Create an Outlook application and declare the Outlook variables as Objects.
Graham Mayor - MS MVP (Word) 2002-2019
Visit my web site for more programming tips and ready made processes
http://www.gmayor.com