PDA

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?