Disable Warning Message from Microsoft Outlook in Excel VBA
 

you can use the sendkeys command to send a the hotkey y to outlook.
This has the same effect as when you click yes, only the macro does it
for you this time. You have to wait 5 seconds before using te sendkey
command in order for it to work (outlook waits 5 seconds before
enabling the yes button)