The 2010-2011 Ohio Municipal, Township and School Board Roster maintained by the Ohio Secretary of State lists 1,309 townships with a 2010 population totaling 5,680,042; meaning approximately 49% of the State's population were residents of townships.
1 Click Mail Recipient (as Attachment) if you want to send a worksheet as an e-mail attachment. 2  Type the e-mail information in the appropriate boxes, and then click Send. 3  To cancel this action and return to Excel, press ESCAPE. On the File menu, point to Send To. 2  Click Mail Recipient. 3  Type the e-mail information in the appropriate boxes, and then click Send this item to be sent. 4  To cancel this action and return to the Excel workbook, click File, point to Send To, and then click Mail Recipient.
I use the macro to transfer all the information over to the blank before emailing it out. You could also copy the sheet you want to send to a new workbook, email it and then close this new workbook without saving it.I also had to create an array of names to send the email to and pull these names into the macro.The command I use to send the email is: ActiveWorkbook.SendMail Recipients:=NameArray, Subject:=ESub To define the NameArray. I use a For/Next statement to read a list of names to send the email to.ow do I create a button which when I click should be able to send the excel sheet (only that particular sheet where that button is). Thanks. Add your answer. Source. Submit Cancel.