Excel VBA using Autohotkey app with Outlook mail send

Hi

I just downloaded Autohotkey as I was told that it could automatically click the send button
when I run Excel VBA code to display multiple mail messages.
I have no idea as to how to set this up with Autohotkey. Can someone please help?
I found the following but am not sure how to implement it
Thanks
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
KimputerCommented:
I said, right mouse click on the green H icon in the system tray. Then Edit, then add the provided code on top of the file, save it, right mouse click on icon again, Reload script.
0
 
KimputerCommented:
In the System tray, Autohotkey, Edit:

add to the top of the script:

#Persistent
SetTimer,CheckForMsgBox2,200
return

CheckForMsgBox2:      ;Closes popup windows
IfWinExist, Microsoft Office Outlook ahk_class #32770
	ControlClick, Button3, Microsoft Office Outlook ahk_class #32770, Allow
	ControlClick, Button4, Microsoft Office Outlook ahk_class #32770, Allow
return

Return

Open in new window


Give the Reload script command (systray again) and it should work
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi

I am not sure where the tray is. If I click on the Autohotkey icon I get the following message. I click yes and nothing happens

1
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
KimputerCommented:
The System Tray is where all the small icons are, the usual default location is bottom right corner. It's the green "H" icon, right mouse click on it.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi
When I open it I see the following text. Do I just overwrite it? Or do I add the code you mentioned at the top? Thanks
Script lines most recently executed (oldest first).  Press [F5] to refresh.  The seconds elapsed between a line and the one after it is in parentheses to the right (if not 0).  The bottommost line's elapsed time is the number of seconds since it executed.

---- C:\Users\murbro\Documents\AutoHotkey.ahk
016: Return (659.90)

Press [F5] to refresh.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.