I create Outlook mail in Excel VBA, but the mail screen may not be active after execution, so please tell me how to activate it (frontline).

Asked 2 years ago, Updated 2 years ago, 81 views

When I create Outlook mail in Excel VBA, the mail screen may not be active after execution. How do I activate it?

The code looks like the following

DimobjOutlookAsOutlook.Application
 DimobjMailAsOutlook.MailItem
 SetobjOutlook=CreateObject("Outlook.Application")
 SetobjMail=objOutlook.CreateItem(olMailItem)
 With objMail
 .To="[email protected]" 
 .Subject="Regarding 〇 の 〇" 
 .BodyFormat=olFormatPlain 
 .Body="Email Body" 
 .Display
 End With

2022-09-30 19:51

2 Answers

I got here because I wanted to do the same thing.

.Display
and
End With

during .GetInspector.Activate
If you put in one line, it's done.

2022-09-30 19:51

I also found that the above corrections do not come forward.

Therefore, I am trying to rewrite it as follows.

before modification:

.GetInspector.Activate

modified:

.GetInspector.Display(False)

2022-09-30 19:51

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656

Popular Questions

548 rails db:create error: Could not find mysql2-0.5.4 in any of the sources

979 In Java servlet, when SHA-256 sends WW-Authenticate header for digest authentication, the client does not return the result.

709 When building Fast API+Uvicorn environment with PyInstaller, console=False results in an error

549 PHP ssh2_scp_send fails to send files as intended

642 /usr/bin/google-chrome:symbol lookup error:/usr/bin/google-chrome: undefined symbol:gbm_bo_get_modifier

© 2024 OneMinuteCode. All rights reserved.