?
Solved

Excel VBA using Autohotkey app with Outlook mail send

Posted on 2014-04-09
6
Medium Priority
?
914 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:Murray Brown
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 36

Expert Comment

by:Kimputer
ID: 39988923
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:Murray Brown
ID: 39988951
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 36

Expert Comment

by:Kimputer
ID: 39988975
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:Murray Brown
ID: 39989045
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 36

Accepted Solution

by:
Kimputer earned 2000 total points
ID: 39989711
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:Murray Brown
ID: 39989776
Thanks very much
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
In this article I discuss my selections of the Top Four free Outlook OST File Viewers available. Open, view and read even damaged OST files by using these tools. They all provide a clear preview of all data such as emails, notes, tasks, calendars, e…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…
Suggested Courses

800 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