Solved

Excel VBA using Autohotkey app with Outlook mail send

Posted on 2014-04-09
6
844 Views
Last Modified: 2014-04-09
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
0
Comment
Question by:murbro
  • 3
  • 3
6 Comments
 
LVL 35

Expert Comment

by:Kimputer
Comment Utility
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
 

Author Comment

by:murbro
Comment Utility
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
 
LVL 35

Expert Comment

by:Kimputer
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:murbro
Comment Utility
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
 
LVL 35

Accepted Solution

by:
Kimputer earned 500 total points
Comment Utility
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
 

Author Closing Comment

by:murbro
Comment Utility
Thanks very much
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Learn more about how the humble email signature can be used as more than just an electronic business card. When used correctly, a signature can easily be tailored for different purposes by different departments within an organization.
Resolve Outlook connectivity issues after moving mailbox to new Exchange 2016 server
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now