Hello, I have created a worksheet for my company that covers all areas of our business. I have inserted ActiveX buttons allowing me to email only certain cell ranges directly to the body of the receiving email address. I have also created a terms and conditions box as well as contact information, these need to be added to all out going emails. I have no problem emailing the one set of selected ranges, IE ("B73:L116"), however when i try to add in my other ranges to the same VB Code, it is crashing both Excel and Outlook. Please could anyone let me know what i might be doing wrong. I have only really been using Excel to this extent for a few months so any basic talk would be extremely helpful. Thank you all very much in advance.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!