mauserme Posted January 19, 2013 at 04:00 AM Share Posted January 19, 2013 at 04:00 AM (edited) As we near substansive action in the General Assembly, now is the time to post an updated contact list for the 98th General Assembly. About a week ago a fellow member quietly offered to help with this update behind the scenes. I determined then to post this as a collaboration between he and I but, after seeing the amount of work and dedication he put forth, I can only call this more a product of oldude's effort than my own. Thank you, sir, for making this project a success. And by way of invitation to all members there are data fields still to be filled, particularly in regard to new Senators who's contact information is yet to be published. Please post here, or PM oldude or myself, any additional information you might come across. S-Phone = Springfield Phone NumberS-Fax = Springfield Fax NumberD-Phone = District Phone NumberD-Fax = District Fax Number House Contacts https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0ApKXRqVgygdsdDdDa1VCcjlZTURNamwtZTBULTFrUkE&output=html https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0ApKXRqVgygdsdEVpcmZMMmpCYlg4bFZ3a1FBUVFUQnc&output=html Edited to add a link to the 97th General Assembly Contact List for future reference. Edited to add Facebook links. Edited February 24, 2013 at 01:48 AM by mauserme Link to comment Share on other sites More sharing options...
mauserme Posted January 19, 2013 at 04:00 AM Author Share Posted January 19, 2013 at 04:00 AM (edited) S-Phone = Springfield Phone NumberS-Fax = Springfield Fax NumberD-Phone = District Phone NumberD-Fax = District Fax Number Senate Contacts https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0ApKXRqVgygdsdEhlX2ptcFFNSlZNaTJTSXoycDBWhat the hey!!!E&output=html https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0ApKXRqVgygdsdGZ6ME80N2FpdVZoajZ5eWpFUGRSOHc&output=html Edited 2/23/2013 to add links to web contact forms for Senators without email address (thanks oldude). Senator Napolean Harris 15th Legislative District Senator Thomas Cullerton 23rd Legislative District Senator Julie Morrison 29th Legislative District Senator Melinda Bush 31st Legislative District Senator Steve Stadelman 34th Legislative District Senator Pat McGuire 43rd Legislative District Senator Andy Manar 48th Legislative District Senator Jennifer Bertino-Tarrant 49th Legislative District Edited to add Facebook Links Edited February 24, 2013 at 01:50 AM by mauserme Link to comment Share on other sites More sharing options...
F12Mahon Posted January 19, 2013 at 04:23 PM Share Posted January 19, 2013 at 04:23 PM (edited) Here is my state Rep. Eugene IL house90th District, Illinois General Assembly Tom Demmer Websitehttp://tomdemmer.com/ emailtom@tomdemmer.com Springfield Office:222-N Stratton Office Building Springfield, IL 62706 (217) 782-0535 District Office:1221 Currency Court Suite BRochelle, IL 61068(815) 561-3690(815) 561-3691 FAX Edited for formatting Edited January 19, 2013 at 04:26 PM by F12Mahon Link to comment Share on other sites More sharing options...
oldude Posted January 19, 2013 at 06:57 PM Share Posted January 19, 2013 at 06:57 PM Reserved for updates. Thanks F12Mahon got them. When I get a few more I'll send an updated spread sheet to mauserme.Any one that gets new email addresses or if any emails are returned as permanently failed PM mauserme or myself and we'll get the sheet updated. Link to comment Share on other sites More sharing options...
F12Mahon Posted January 19, 2013 at 07:37 PM Share Posted January 19, 2013 at 07:37 PM :Here is Senator Bivins info. Eiugene State Capitol Office M103A State HouseSpringfield, Illinois 62706Phone: 217-782-0180Fax: 217-782-9586Legislative Assistant: Offices: 50 W. Douglas St., Suite 1001Freeport, IL 61032Phone: 815-223-0037Fax: 815-284-0207Legislative Assistant: 629 N. Galena Ave.Dixon, IL 61021Phone: 815-284-0045Fax: 815-284-0207 Link to comment Share on other sites More sharing options...
mauserme Posted January 20, 2013 at 05:08 AM Author Share Posted January 20, 2013 at 05:08 AM I'm on it guys. Both are updated. Link to comment Share on other sites More sharing options...
C0untZer0 Posted January 20, 2013 at 02:36 PM Share Posted January 20, 2013 at 02:36 PM What's amazing to me is that motivated individuals here on this board are able to compile this information. And at CAPWIZ they were able to put together the information: http://www.capwiz.com/nra/state/main/?state=IL&view=myofficials&action=chgaddr#0 But at the Illinois State Board of Elections, which receives nearly $13 a year from the state, where people are actually paid to make this information available, they're still struggling to populate their web app with the same information: http://gis.elections.il.gov/map_viewer/default.aspx Link to comment Share on other sites More sharing options...
mauserme Posted January 20, 2013 at 03:31 PM Author Share Posted January 20, 2013 at 03:31 PM I added district numbers this morning for the following Reps: Josh Harms (+s-phone)Frances Ann HurleyJeanne IvesStephanie KifowitCharles Meier (+ s-phone and email)Marty MoylanRon SandackSue SchererDerrick SmithSilvana TabaresBarbara Wheeler (+s-phone and s-fax)Kathleen Willis Link to comment Share on other sites More sharing options...
Lou Posted January 31, 2013 at 07:15 PM Share Posted January 31, 2013 at 07:15 PM Ron Sandack moved from the Senate and got elected to the House so he now has a new e-mail and will be closing out the senate one soon. New = repsandack@gmail.com Link to comment Share on other sites More sharing options...
mauserme Posted January 31, 2013 at 07:31 PM Author Share Posted January 31, 2013 at 07:31 PM Thanks Lou. We've been waiting for those office and district specific email addresses to get updated. Link to comment Share on other sites More sharing options...
oldude Posted February 9, 2013 at 04:46 PM Share Posted February 9, 2013 at 04:46 PM (edited) Help Needed Some of the test emails that have been sent out have came back failed. If you do not have an email listed for your reps (listed above) or recieve a failed email call your reps district office and ask them for an email address. These spread sheets are not perfect. They are a work in progress and your input is greatly needed and appreciated You can also google your reps name and see if you can find an online contact form (usually from their campaign website). Fill it out, type in any message you may have i.e. a thank you if they have sponsored 997/1284. If you have any updated contact info, please let us know. A PM is preferred to save bandwith. Either mauserme or I will get the speadsheets updated ASAP. We would like to have as much correct info as possible before it's needed Thanks for your helpoldude Edited February 23, 2013 at 06:48 PM by oldude Link to comment Share on other sites More sharing options...
Federal Farmer Posted February 21, 2013 at 03:50 PM Share Posted February 21, 2013 at 03:50 PM I need these lists to share with the FPC but my workplace firewall hides that particular content. Can someone put them into an attachment and post or pm? Thanks. Link to comment Share on other sites More sharing options...
mauserme Posted February 21, 2013 at 04:53 PM Author Share Posted February 21, 2013 at 04:53 PM Link to comment Share on other sites More sharing options...
flw Posted February 23, 2013 at 07:23 AM Share Posted February 23, 2013 at 07:23 AM Is there a link, so I can download only the spreadsheet? If not, is there a way to capture the spreadsheet only without capturing the whole web page? Link to comment Share on other sites More sharing options...
Lou Posted February 23, 2013 at 03:19 PM Share Posted February 23, 2013 at 03:19 PM Is there a link, so I can download only the spreadsheet? If not, is there a way to capture the spreadsheet only without capturing the whole web page? Mauser - I'd like to be able to print it out and or save a copy. How do I do that? A PM or e-mail attachment maybe? Link to comment Share on other sites More sharing options...
oldude Posted February 23, 2013 at 03:38 PM Share Posted February 23, 2013 at 03:38 PM (edited) never mind Edited February 23, 2013 at 03:40 PM by oldude Link to comment Share on other sites More sharing options...
mauserme Posted February 23, 2013 at 03:45 PM Author Share Posted February 23, 2013 at 03:45 PM (edited) If you're using Firefox, right click within eiiher frame, hover on "This Frame", and choose any of the top 3 options - Show Only this Frame, Open Frame in a New Tab, or Open Frame in a New window. This will give you a full page display. Or just use these links: House https://docs.google.com/spreadsheet/pub?key=0ApKXRqVgygdsdDdDa1VCcjlZTURNamwtZTBULTFrUkE&output=html Senate https://docs.google.com/spreadsheet/pub?key=0ApKXRqVgygdsdEhlX2ptcFFNSlZNaTJTSXoycDBWhat the hey!!!E&output=html I've also attached PDF's of the data - current to the dates shown at the top. 98th General Assembly House Contacts - Sheet1.pdf 98th General Assembly Senate Contacts - Sheet1.pdf Edited February 23, 2013 at 04:03 PM by mauserme Link to comment Share on other sites More sharing options...
Lou Posted February 23, 2013 at 04:15 PM Share Posted February 23, 2013 at 04:15 PM Thanks Kieth!!! Link to comment Share on other sites More sharing options...
mauserme Posted February 23, 2013 at 08:22 PM Author Share Posted February 23, 2013 at 08:22 PM I've added some links oldude found for Senate contact pages where emails were not found. See Post #2. Link to comment Share on other sites More sharing options...
glockready Posted February 23, 2013 at 08:53 PM Share Posted February 23, 2013 at 08:53 PM As we near substansive action in the General Assembly, now is the time to post an updated contact list for the 98th General Assembly. About a week ago a fellow member quietly offered to help with this update behind the scenes. I determined then to post this as a collaboration between he and I but, after seeing the amount of work and dedication he put forth, I can only call this more a product of oldude's effort than my own. Thank you, sir, for making this project a success. And by way of invitation to all members there are data fields still to be filled, particularly in regard to new Senators who's contact information is yet to be published. Please post here, or PM oldude or myself, any additional information you might come across. S-Phone = Springfield Phone NumberS-Fax = Springfield Fax NumberD-Phone = District Phone NumberD-Fax = District Fax Number House Contacts https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0ApKXRqVgygdsdDdDa1VCcjlZTURNamwtZTBULTFrUkE&output=html Edited to add a link to the 97th General Assembly Contact List for future reference. I tried using these today, and I had a lot get kicked back to me as some of members on the list are no longer members of the 98th General Assembly. Link to comment Share on other sites More sharing options...
Federal Farmer Posted February 23, 2013 at 09:54 PM Share Posted February 23, 2013 at 09:54 PM Please report the failed email addies here. Link to comment Share on other sites More sharing options...
mauserme Posted February 23, 2013 at 10:57 PM Author Share Posted February 23, 2013 at 10:57 PM (edited) I tried using these today, and I had a lot get kicked back to me as some of members on the list are no longer members of the 98th General Assembly. That's the current list of House Representatives. Which came back? Edited to ask if you were using the 98th General Assembly Contacts? That link to the 97th General Assembly at the bottom of what you quoted is a list of archived info.. Edited February 23, 2013 at 11:02 PM by mauserme Link to comment Share on other sites More sharing options...
mauserme Posted February 24, 2013 at 01:52 AM Author Share Posted February 24, 2013 at 01:52 AM House and Senate Facebook links are now available in the 2 opening posts. Some of these are campaign sights that have recent activity, while others do not share their wall. If anyone finds better links please let oldude or me know. Link to comment Share on other sites More sharing options...
abolt243 Posted February 24, 2013 at 02:00 AM Share Posted February 24, 2013 at 02:00 AM Hey guys, on the FB page, looks like the cells need to be shifted down one row at Gabel to sync the names and addresses. Just those three rows down to Halbrook. Everything below Halbrook is good. Thanks for this, and just in the nick of time!! Tim Link to comment Share on other sites More sharing options...
mauserme Posted February 24, 2013 at 02:03 AM Author Share Posted February 24, 2013 at 02:03 AM (edited) I'm on it... ... OK - should be good to go. Circumstances haven't allowed for the normal level of proofing today. Edited February 24, 2013 at 02:06 AM by mauserme Link to comment Share on other sites More sharing options...
Jeckler Posted February 24, 2013 at 02:06 AM Share Posted February 24, 2013 at 02:06 AM Jim Oberweiss contact email: jimo@ilga.gov Link to comment Share on other sites More sharing options...
mauserme Posted February 24, 2013 at 02:09 AM Author Share Posted February 24, 2013 at 02:09 AM Jim Oberweiss contact email: jimo@ilga.gov Done! Link to comment Share on other sites More sharing options...
StreuB1 Posted February 24, 2013 at 02:25 AM Share Posted February 24, 2013 at 02:25 AM (edited) Is it possible that we can create a cell in those spreadsheets and publish that cell only seperate from the actual spreadsheets? I suggest the cell contain a concantination statement that pools all the email1 and email2 cells into one copyable string that people can copy and past into their email "TO:" field. ie. A1, A2, A3, ... This way people can copy and paste the entire list of rep's/senators email addresses to make eBlasts easier and more accurate. Thoughts? Edited February 24, 2013 at 02:26 AM by StreuB1 Link to comment Share on other sites More sharing options...
StreuB1 Posted February 24, 2013 at 02:39 AM Share Posted February 24, 2013 at 02:39 AM (edited) =A1&", "&A2&", "&A3&", "&A4&", "&A5&", "&A6&", "&A7&", "&A8&", "&A9&", "&A10 Keep repeating and replace the cell numbers with the actual. I thought there was a more automated way to do it. I know I have 2 programs I wrote at work that did something like this but don't have my notes here at home. If someone can send me the excel file I will do the leg work, verify it and then send it back. Willing to help out. Edited February 24, 2013 at 02:40 AM by StreuB1 Link to comment Share on other sites More sharing options...
mauserme Posted February 24, 2013 at 04:51 AM Author Share Posted February 24, 2013 at 04:51 AM I think oldude already has something you might be interested in. I'll drop him a note. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now