View Full Version : Cannot get excel to email sheet via outlook
abigaia
08-30-2016, 01:23 PM
I am attempting to have a formula sheet that I have made emailed through outlook, however I cannot get the two to connect. I suspect there is something incorrect in my button to run the macro but there may be foggy lines in the coding. Any help would be greatly appreciated!
abigaia
08-31-2016, 10:42 AM
I attached the incorrect file. I have now attached the correct one
Kenneth Hobs
08-31-2016, 12:54 PM
Looks fine to me. I changed the value for .To to my email. I ran it manually. You had .Display set. It and my added .Send worked fine.
Did you need instructions on how to set the click event for the button control?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.