Results 1 to 4 of 4
  1. #1
    LonghronJ is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Posts
    150

    Send email window to top

    I have a routine that composes an email with a query result. However, for some users, when the email is created, it hides behind their other applications. How do I either minimize all apps before launching the email, or bring the email window to the top, whichever is easier?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you can minimize access, docmd.minimize
    and hope Mail is behind it.

    If mail is not open you can Open it and force it to the front:
    call shell("c:\OUtlook\Outlook.exe",vbMaximizedFocus )

    If Outlook is already open, it will open a second copy, but you still get it on top.

    but access cant control other apps that are open. There may be an API that can.

  3. #3
    LonghronJ is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Posts
    150
    Ranman, I'll try the Access minimize for now. I can't guarantee the location of the Outlook file on everyone, so I'll bypass that option. Thanks.

  4. #4
    LonghronJ is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Posts
    150
    Ranman, I'll try the Access minimize for now. I can't guarantee the location of the Outlook file on everyone, so I'll bypass that option. Thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 12-28-2015, 04:11 PM
  2. Replies: 5
    Last Post: 09-14-2015, 07:24 AM
  3. Replies: 5
    Last Post: 05-07-2014, 09:25 AM
  4. Replies: 4
    Last Post: 04-13-2011, 10:11 AM
  5. Open Outlook window but don't send
    By Paul Taylor in forum Access
    Replies: 2
    Last Post: 04-07-2011, 11:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums