Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel VBA using Autohotkey app with Outlook mail send

Posted on 2014-04-09
6
Medium Priority
?
948 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
  • 3
  • 3
6 Comments
 
LVL 37

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 37

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 37

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
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…

877 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