PDA

View Full Version : Display outlook mail from VBA



sparda663
05-28-2015, 12:36 AM
Hi everyone :) ,

I wanted to know how i can display an outlook E-Mail from my VBA application when i directly show my UserForm on the opening of the workbook? When i launch my application from the debugger (VBA with play button) i can see my mail when the code execute the ".Display" command, but, when i launch my application directly from the workbook, the mail is created but is not shown, it stay on the taskbar (i have to do ALT+TAB to go on it). If anyone know where is the problem it would be very helpful.

Thanks.

sparda663
05-28-2015, 01:47 AM
I solved it with a "SetforegroundWindow" code on the internet. Thanks for reading