mauserme Posted January 19, 2013 at 04:00 AM 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
mauserme Posted January 19, 2013 at 04:00 AM Author 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
F12Mahon Posted January 19, 2013 at 04:23 PM 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
oldude Posted January 19, 2013 at 06:57 PM 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.
F12Mahon Posted January 19, 2013 at 07:37 PM 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
mauserme Posted January 20, 2013 at 05:08 AM Author Posted January 20, 2013 at 05:08 AM I'm on it guys. Both are updated.
C0untZer0 Posted January 20, 2013 at 02:36 PM 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
mauserme Posted January 20, 2013 at 03:31 PM Author 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
Lou Posted January 31, 2013 at 07:15 PM 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
mauserme Posted January 31, 2013 at 07:31 PM Author 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.
oldude Posted February 9, 2013 at 04:46 PM 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
Federal Farmer Posted February 21, 2013 at 03:50 PM 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.
flw Posted February 23, 2013 at 07:23 AM 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?
Lou Posted February 23, 2013 at 03:19 PM 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?
oldude Posted February 23, 2013 at 03:38 PM Posted February 23, 2013 at 03:38 PM (edited) never mind Edited February 23, 2013 at 03:40 PM by oldude
mauserme Posted February 23, 2013 at 03:45 PM Author 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
mauserme Posted February 23, 2013 at 08:22 PM Author 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.
glockready Posted February 23, 2013 at 08:53 PM 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.
Federal Farmer Posted February 23, 2013 at 09:54 PM Posted February 23, 2013 at 09:54 PM Please report the failed email addies here.
mauserme Posted February 23, 2013 at 10:57 PM Author 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
mauserme Posted February 24, 2013 at 01:52 AM Author 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.
abolt243 Posted February 24, 2013 at 02:00 AM 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
mauserme Posted February 24, 2013 at 02:03 AM Author 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
Jeckler Posted February 24, 2013 at 02:06 AM Posted February 24, 2013 at 02:06 AM Jim Oberweiss contact email: jimo@ilga.gov
mauserme Posted February 24, 2013 at 02:09 AM Author Posted February 24, 2013 at 02:09 AM Jim Oberweiss contact email: jimo@ilga.gov Done!
StreuB1 Posted February 24, 2013 at 02:25 AM 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
StreuB1 Posted February 24, 2013 at 02:39 AM 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
mauserme Posted February 24, 2013 at 04:51 AM Author 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.
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