I have coded an automatic process of sending multiple emails in excel VBA. But I don't want each email to be sent until I press "Send" button in Outlook by myself. For example, there are 3 persons I need to send email. The macro generates and displays the email for the first person and wait for me to press the "Send". When I press the "Send", the macro loops to next person and displays the email and wait for me to send.
I don't know how to write this code for allowing me to press "Send" button in Outlook and then trigger next round.
Here is my code. Thank you very much.
Bookmarks