Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by duncanb7
at 2024-03-28 11:48:49
ModifyPoint:500 Replies:4 POST_ID:828455USER_ID:11059
Topic:
Outlook Groupware Software;Visual Basic Programming;Microsoft Office Suite
I found one strange problem, when I am doing sent email to my client in VBA,
VBA code at .send (see attach code) will come one dialog box to warn and ask me whether to continue to
send the message that might be virus" and then I manually press "yes to finish
the rest the VBA code. The Client doesn't recevie any email until
I re-open outlook software and quit it. THe client can receive the email right away. Why ?
and the other question, how to avoid the message warning dialog window, and I try
to set Application.DisplayAlerts = False but it is not working at all
Please advise for those two question and view my attach VBA code for email send
VBA code at .send (see attach code) will come one dialog box to warn and ask me whether to continue to
send the message that might be virus" and then I manually press "yes to finish
the rest the VBA code. The Client doesn't recevie any email until
I re-open outlook software and quit it. THe client can receive the email right away. Why ?
and the other question, how to avoid the message warning dialog window, and I try
to set Application.DisplayAlerts = False but it is not working at all
Please advise for those two question and view my attach VBA code for email send
Function sendmail()Set app = CreateObject("outlook.application")Set itm = app.CreateItem(0)Application.DisplayAlerts = FalseWith itm.Subject = "dail report".To = "duncanuk9@hotmail.com.hk".Body = "daily last report"'.Display.Send """"""""""""""""""Warning dialog window will came out to ask me whether to continue ?End WithSet app = NothingSet itm = NothingEnd Function 1:2:3:4:5:6:7:8:9:10:11:12:13:14:15:16:
Author: duncanb7 replied at 2024-03-28 12:41:34
I think I can handle your 3 option suggestion, Could you answer me the first question, please advise?
Expert: Chris Bottomley replied at 2024-03-28 12:31:23
The expectation is that with the clean quit the outlook mail will be sent immediately ... did you check?
Chris
Chris
Author: duncanb7 replied at 2024-03-28 12:07:11
I think I can handle your 3 option suggestion, Could you answer me the first question, please advise?
Accepted Solution
Expert: Chris Bottomley replied at 2024-03-28 11:56:57
500 points GOOD
I note you are not quitting the outlook instance.
As for the security warning:
1. You can modify your code to use redemption: | http://www.dimastr.com/redemption/
2. You can use an outlook add-in i.e: | http://www.mapilab.com/outlook/security
3. Or finally you can use clickyes | http://www.contextmagic.com/
From my perspective ... if you do a lot of VBA programming then redemption is a good solution ... personally I rarely use it now.
I now use the maplab security add-in of option 2. The first time you do something it asks if you want to continue, and if you click the always take this option it never bothers you again ... and it's free for both personal and commercial usage.
3. Personally I have never used clickyes but there are those who advocate so I include it for information
Chris
As for the security warning:
1. You can modify your code to use redemption: | http://www.dimastr.com/redemption/
2. You can use an outlook add-in i.e: | http://www.mapilab.com/outlook/security
3. Or finally you can use clickyes | http://www.contextmagic.com/
From my perspective ... if you do a lot of VBA programming then redemption is a good solution ... personally I rarely use it now.
I now use the maplab security add-in of option 2. The first time you do something it asks if you want to continue, and if you click the always take this option it never bothers you again ... and it's free for both personal and commercial usage.
3. Personally I have never used clickyes but there are those who advocate so I include it for information
Chris
Function sendmail()Set app = CreateObject("outlook.application")Set itm = app.CreateItem(0)Application.DisplayAlerts = FalseWith itm.Subject = "dail report".To = "duncanuk9@hotmail.com.hk".Body = "daily last report"'.Display.Send """"""""""""""""""Warning dialog window will came out to ask me whether to continue ?End Withapp.quitSet app = NothingSet itm = NothingEnd Function 1:2:3:4:5:6:7:8:9:10:11:12:13:14:15:16:17:
