Export as fixed format - Email Window

[Claire Jackson]

Hi all,

I have a working form which exports the current excel document as a PDF to send via email.

What I am trying to get is for the draft email message to them pop up as the active window on my PC. Currently it just flashes at the bottom of my screen and I have to click on it to open the email to send it.

Any help would be greatly welcome.

Thanks in advance

 

[John_w]

Try AppActivate with the subject of the email, something like this, where OutMail is the Outlook MailItem object:

    With OutMail
        .Subject = "Your subject"
        .Display
        AppActivate .Subject
    End With

Or this, where OutApp is the Outlook Application object:

        OutApp.ActiveInspector.Activate