Display outlook mail from VBA

[sparda663]

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]

I solved it with a "SetforegroundWindow" code on the internet. Thanks for reading