I have an access 2007 vba application that creates and displays an email before sending. Display is done using .DISPLAY Most of the time it works as expected, the outlook message displays on the screen, the user edits and sends it, and control returns to the Access form. But, sometimes the outlook message does not pop up to the user. The user has to look around in their task bar at the bottom of the screen to find the new message. They find it there, click on it to activate it,send it, and then control returns to access form. It seems to happen randomly. Outlook is already open and it doesn't seem to matter where they were in outlook.
Do I need to add code to activate the new mail item in addition to .display ? What would this code be? Also, if I do this, would control return to my Access application after user sends the message?