how do you "send" an email in outlook, keystrokes CTRL+Enter ???

[BSALV]

when you prepare mails in excel for Outlook, you can choose display, save and send.
Normally Outlook doesn't allow the "send", it comes with a popup that an external programs tries to send and you can agree or disagree ...
If you use "display" instead and manually do CTRL+Enter, the mail is send.
I try to do that now with Application.SendKeys ("^{Enter}"), True but that doesn't work.
How do you send 10-20 mailings at once without interfering.

     Select Case Range("Mailmethode").Value
                                        Case "Display": .display           'zo alle 5 en dan in 1 keer
                                        Case "Send"
                                             .display
                                             DoEvents
                                             Application.Wait (Now + TimeSerial(0, 0, 5))     'wacht een beetje
                                             DoEvents
                                             Application.SendKeys ("^{Enter}"), True     'hopelijk werkt de CTRL+Enter                             'zo 1 per 1 doorzenden"
                                             DoEvents
                                             Application.Wait (Now + TimeSerial(0, 0, 10))     'wacht een beetje
                                            DoEvents
                                        Case "Save": .Save     'opslaan als concept
                                   End Select

 

[Logit]

Mail from Excel with Outlook (VBA)

 

[BSALV]

it's not what i was looking for. I know that site, but there is no information about how to send the mail without those annoying popups.
If possible, i'd like to use ".display" and then perform a "CTRL+Enter" with Sendkeys (but for one or another reason, that doesn't work) or another solution.

 

[Logit]

If you haven't tried using code from that site, rather than using the code you posted, give it a try.

If the 'pop ups' still occur using code from the suggested website, the issue is with OUTLOOK itself and not the code. For example: Outlook must be open and running at the time you
are sending emails via VBA; you must have a legitimate email address assigned to Outlook (mine is a Yahoo account). There may be other requirements as well depending on circumstances.

 

[BSALV]

i used the code of that site almost 8 years now, but it works a little bit different with 365.
Indead it's more an Outlook then an Excel-problem.