State Plus
How-To Guide
State Plus is a Windows Software Program that contains a database of Legislators and Members of Congress. It is used by Legislative Relations Offices as an on-line Legislative Directory, Contact Manager, Grass Roots Contacts Database, and a Communication and Office Productivity Tool.
Features of the Program by Section
Legislators(Page 2)
HTML Email (Page 4)
Available in the Professional Version or as an add-on to Standard Version
|
This section contains the State Legislators of all 50 states. § Query the database to create targeted lists of State Legislators. (see How-To Filter) § Lists can then be used to send email. (see How-To Email or HTML EMAIL SERVICE ) § Create fax lists. (see How-To Export a Fax List) § Create mail merge data files. (see How-To Mail Merge) § Print reports. (see How-To Print Reports) § Print labels. (see How-To Print Labels) § Store contact history notes. (see How-To Create Journal Entries) § Add database fields. (see How-To Add User Defined Fields) § Select Grass Roots Contacts that are constituents of the listed legislators. [Available only in the Professional Version] (see How-to View Constituents) § Export data for use in a Palm or other PDA. (see How-To Export Data to your PDA) § Correspondence can be sorted in Room/Building order for easy hand delivery. (see How-To Sort your List) |
General Information
|
This section contains contact information for the State Governments and the Offices of State Legislatures. § Find contact information for a State Legislature’s House Clerk or Secretary of the Senate. § Go directly to a State’s House/Assembly or Senate website or the main government website.
|
Zip/DistrictLookup(Page 11) |
This section allows you to find the Legislators who represent a Zip code or Zip+4. § See who represents a Zip code or Zip+4. (see How-To Find the Legislators that Represent an Address) § Link to the U.S. Post Office web site to lookup a Zip+4 for any address. (see How-To Get the Zip+4 for any Address) |
Grass Roots Contacts(Page 12)
Available only in the Professional Version |
This section allows you to maintain a Grass Roots Key Contacts Database. § Import records directly from your membership or employee databases. Legislative District assignment is performed automatically when new records are entered or databases are imported. (see How-To Import Your Membership/Employee Database) § Action Alerts can be prepared and sent to constituents of specific Legislators. (see How-To Email an Action Alert) § Merge email is a unique feature where each email can contain the contact information of the recipients Legislators’. (see How-To Send a “Contact your Legislators” Email) § Print constituent lists and economic impact statements. (see How-To Print Grass Roots Reports) |
Journals(Page 14)
|
This section allows you to record contact history notes. § Record contact history notes. (see How-To Create Journal Entries) § Group by category, subject, etc. (see How-To Filter Journals) § Include in reports. (see How-To Print Journal Reports) |
Legislators
This option allows you to change the list order of the Legislators; the default is alphabetical by last name.
1. Click the Legislators button on the main menu.
3. Choose your list order: Last Name, State/District, Room (ascending order) or Room in Descending Order (these two options make hand-delivery easier), or in Party/Last Name order.
If you are a State Plus© Professional subscriber or if you subscribe to the HTML Email service as an additional option please go to the HTML Email Service section. |
To Email Legislators (File, Email Legislators)
To Add Merge Codes to your Message - Personalize each message by adding merge fields.
Use the these fields: |
For this result: |
<< Legislator’s Name+Address >>
Dear << Legislator’s Title+Lastname >>
|
The Honorable Neil Abercrombie U.S. House of Representatives 1502 Longworth House Office Building Washington, DC 20515-1101
Dear Congressman Abercrombie, |
Troubleshooting Email Current versions of Outlook contain security settings that may cause a window to pop-up for each email that says, “A program is trying to access email addresses you have stored in Outlook. Do you want to allow this? If this is unexpected, it may be a virus and you should choose “No”.” This is actually not unexpected it is your State Plus attempting to send the email messages you just created. You can answer “Yes” in fact you will need to hit “Yes” for each email you are sending. If you were sending a large number of them this could be time consuming and tedious. Here is what you can do:
|
HTML Email ServiceUsing this optional service, you can compose and send email messages in both HTML and Plain Text simultaneously. The email jobs are uploaded to The Soft Edge, Inc. email server for speedy, hassle free delivery. Knowledge of HTML Source programming is unnecessary. |
§ HTML version can contain website, webpage, and email hyperlinks. (See How-To Add Hyperlinks) § The HTML messages can contain web page like graphical content and links. (See How-To Add an HTML Template and/or How-To Add a Graphic Signature) § The messages can be sent to Legislators or Grass Roots contacts. (See How-To SendEmail) § Messages Templates can be saved and retrieved to speed the message creation process. (See How-To Save an Email Message or How-To Open a Saved Message) § Creating a HTML message is as easy as using your word processor. (see How-To Format an Email Message) § A log of all email jobs is also maintained. Messages can be retrieved from the email log database and reused. (See How-To Filter for Recipients of a Previous Email and How-to Open Sent Messages) § The message "From" address can be another person's email address. (See How to SendEmail) § You can Preview the messages in both HTML and plain text. The plain text Preview displays the message after inserting the live merge data. (See How-To SendEmail) § Test copies of the messages can be sent back to the sender or to a predefined approval group. (See How-To SendEmail) |
1. In order to get graphic content for your emails you need a Template (a graphic frame/border). If you do not have a Template send us your digital letterhead or logo (a Word document or PDF is fine) and we can make one for you! If you have a graphic designer that you would like to make the templates, it is very simple, contact The Soft Edge for more information.
2. After you have emailed us your letterhead, we will email an HTM document back to you. Please DO NOT OPEN the HTML Template! Right click on the attachment and save it. Make sure you remember where you saved it.
3. Now open your State Plus, click Legislators, click SendEmail, and choose Legislators.
4. Click the HTML Template button. Browse for your template (the HTM document you just saved), highlight it and click Open. It will show the template filename in the top blue bar.
5. Click Preview to view the HTML template.
6. If everything looks okay then hit Save and give it a name like Letterhead. Now you have saved a blank message with the letterhead attached for future use.
7. Close State Plus.
® Use dropdown boxes to choose your fonts and font sizes
® Use B (bold). I (italics) and U (underlined) buttons
® Use the align left, align center and align right buttons
® Use the bullets button, the increase indent and the decrease indent buttons
® Setting text colors – Click the arrow next to the colored triangle. Click Pick Font Color to choose from a number of color swatches. Click Enter Font Color to type in an exact color value. (Hex Value as RRGGBB) If you are trying to match a color to your logo or template precisely, the designer of the logo/template should be able to give you that value.
® Use the / button or click Insert, Horizontal Line to add a horizontal line to your email
If you have a graphic signature, i.e. a scanned image of a signature that you would like to include in your emails, it needs to be placed on an internet accessible server. The Soft Edge can do this for you if you send us the signature file. Then using the “absolute address” of the image you may add the file to an email.
Creating a fax list for use with Xpedite or other online broadcast fax service
1. Start State Plus.
2. Click on the Legislators button from the main menu.
3. Select the desired Legislators. Refer to the Filter section for directions on how to make your selections.
4. Click File on the gray menu bar on top and click Save As/Export Data. Select Mail Merge Data File, Legislators.
5. A screen will appear asking you to save the file. You may either save the file to the directory shown (the default directory) or change the location. Remember where State Plus is saving the file!
6. In the Save as File Type change the file type to Xpedite Mail Merge (*.csv) or Xpedite FaxReach (*.csv) depending on which Xpedite Service you are using. If you are not using an Xpedite service the default Excel (*.csv) format should work perfectly well.
7. Exit State Plus.
8. Go to the Xpedite website, or whichever fax service or software you use. If you do not have an account and/or login or have forgotten it you will need to contact Xpedite. Call The Soft Edge, Inc. (703-442-8353) and we will direct you to an account representative at Xpedite that can help you.
9. Follow the directions to import the data/file that was created with State Plus, create/import your letter and send your broadcast fax.
10. Click Print. The labels should be printing.
11. Click Close.
Use the these fields: |
For this result: |
«FormalName» «CapStreet1» «CapStreet2» «CapCityStZip»
Dear «Salutation»,
|
The Honorable William F. Adolph Jr. Capitol Bldg. House Box 202020 Harrisburg, PA 17120-2020
Dear Representative Adolph,
|
OR: |
For this result: |
«FormalName» «DistStreet1» «DistStreet2» «DistCityStZip»
Dear «Salutation», |
The Honorable William F. Adolph Jr. 920 W Sproul Rd Springfield, PA 19064-1241
Dear Representative Adolph, |
8 Main Report Types
§ List of Legislators - This will print the basic Name/Address/District information
§ Legislator Detail Report – This report allows you to include basically all the information in the Legislators’ records. A form will come up that allow you to choose what information is included and what is excluded.
§ Committee Rosters – This Report is independent from the onscreen grid. It will give you options as to which Committee(s) you would like to print rosters for.
§ List Legislators by County - This Report is independent from the onscreen grid. It allows you to choose a state and print an alphabetical county listing for that state with the Legislator(s) that represent that county or part of that county.
§ Do Not Send Email Report - This Report is independent from the onscreen grid. It will give you the list of email addresses that are on your do not send list.
Create a Journal from Legislators Section
1. Start State Plus.
2. Click the Legislators button from the main menu.
3. Highlight the Legislator you wish to make a journal entry for.
4. Click Tools on the gray menu bar on top.
5. And choose Make a Journal Entry, then choose For Selected Legislator or For All Listed Legislators.
6. Type in a Subject.
7. Choose an Entry Type. Ex. Phone call, Email, etc.
8. To choose or add Contact(s). Click Select. A new window will appear.
a. At the top is a dropdown box labeled “Show Names From:” with different lists of contact names. Select from the list you want and the contacts on that list will appear in the box on the bottom left.
b. Click on a name on the left to add it to the list on the right. To add a new name that is not yet on the list, type the name in box above the list on the left and then click the Add button.
c. You may choose to add another name. Select another name from the list by highlighting it or choose another name from another list and click Add.
d. To remove a person from the list on the right, highlight the name in the right column and click the Remove button.
e. Click OK. All of the names that were in the right hand list will now appear in your journal entry.
9. Choose an Author. Either type in a name or select one from the pull down menu.
10. Date and Time can be changed to any past or future date or time. You may choose to time phone calls by using the Timer feature or type in values (Hours: Minutes: Seconds).
11. Record any notes or comments (text only).
12. At the bottom of the window is a button called Categories. When you click on this button another screen will appear. Select a Category already listed by checking the box. You may choose more than one.
® You may add or remove a Category from this list by clicking on the Add/Remove Categories button on the lower right side. Another screen will appear. Either highlight a category you wish to remove and click the Remove button or type the name of a new Category and click the Add button. Click Ok.
13. You may also add an attachment to the journal using the buttons at the bottom of the page.
14. If you are networked and do not wish to share access to this Journal entry, check the Private box in the lower right corner. Only you (and the admin) will have access to this Journal entry.
15. Click Save. You will be returned to the list of journals.
Make a Journal Entry from the Legislator’s Detail Record
1. Start State Plus.
2. Click the Legislators button from the main menu.
3. Double click on the Legislator you wish to make a journal entry for or click on the View Details button after highlighting the Legislator.
4. Click on the Journal tab.
5. Click the New button.
6. Create your journal entry (see preceding section for details on making journal entries)
7. Click Save.
1. Start State Plus.
2. Click on the Legislators button on the main menu.
3. Filter your list of Legislators.
4. Click Tools on the gray menu bar on top and choose Add User Defined Field.
5. Type in a Field Name. (Ex. Reception Invitation) This is a bit like a group of three fields actually, each for a different type of data. When you create a UDF all three types are created automatically. You are not required to add values to all the fields but we suggest you add values to at least one of the fields.
® FieldName_Text (text only)
® FieldName_Number (numbers only, no commas, no symbols)
® FieldName_Date (date only)
(For this Example type in “emailed” in the text field then as you receive responses you can go to each Legislator and change the Reception_Invitation_Text value to “Confirmed” or “Declined”)
6. Click on the Step 2 tab.
7. In the Select Names for List From: dropdown box choose Legislators Listed in Grid.
8. Click to highlight the individual Legislators you want to have this UDF or click the Select All button. Clicking a selected Legislator will unselect them.
9. Click OK.
10. A screen will appear asking, “About to Add New Fields for Selected Legislators. Are you sure?” then click OK.
11. Those Legislators should now have a UDF called 'Reception Invitation’ with the Text field value “emailed”, and the Number and Date field values blank.
1. Start State Plus.
2. Click on the Legislators button on the main menu.
3. Highlight the Legislator’s name and click View Details.
4. Click the User Defined Fields Tab.
5. Highlight the UDF you would like to edit and click the Edit button above.
6. You may now change the Field Name, and its Text value, Number value, and/or Date value for this Legislator only.
7. Click Save. The changes will appear in the grid.
1. Start State Plus.
1. Start State Plus.
2. Click on the Legislators button on the main menu.
3. Highlight the Legislator’s name and click View Details.
4. Click the Grass Roots tab, here you will see the list of your grass roots contacts that have home or work addresses in this Legislator’s district
5. You can now email these grass roots contacts, export a mail merge data file, print labels, print reports, etc. Click File, the first six options are for communicating with the Legislator the next six are for communicating with these grass roots contacts.
1. Start State Plus
2. Click on the Legislators button on the main menu
3. Click File, SaveAs/Export Data, PDA or Palm Pilot Data File
4. Click the Print Instructions button and print these more detailed instructions.
5. Select the destination, in other words the program on your desktop that you sync your handheld device with. Outlook, Palm Desktop or Lotus.
6. Choose which information to include in the file with the check boxes
7. Click OK and Save the file, PDA_Legislators.csv, somewhere you will find it easily.
8. Close State Plus
9. Make sure that your desktop software and your handheld have identical contact data, if not then do a sync before moving on to the next step
10. Start your desktop program
11. Click Contacts
12. Create a Category: Legislators. Later when you update the data you will delete all the entries for these categories and import the new data from State Plus
13. Import the file PDA_Legislators.csb, make sure the fields are lining up correctly
14. Now sync with your handheld so that the desktop overwrites your handheld.
If you have an entire database of contacts that you would like matched you may be interested in our State Plus Professional Version which allows for a Grass Roots Database to be imported, matched to Legislative Districts and used to send and manage outreach to those contacts.
Or inquire about our Zip Match services. For a one time fee The Soft Edge will match all the Contacts in your database to their Legislative Districts.
1. Open State Plus.
2. Click Zip/District Lookup on the main menu.
3. Type in a 5-digit zip code.
4. You may get a number higher than 1 in the box labeled as Possibles then more than one Legislative District falls within this zip code but it will give you the best guess district number. (This is the district that overlaps this zip code, with the highest number of registered voters.) Click OK.
5. It will then take you to the Legislators grid showing only the two Senators and the “best guess” Congressional and Legislative Representatives.
6. To be certain you need the zip+4 (Close and see below)
1. Open State Plus.
2. Click Zip/District Lookup on the main menu.
3. Click the US Post Office Zip+4 button, this will take you to the U.S. Post Office Website.
4. Type in the complete street address and click Submit.
5. You will get the +4 for that address. Copy the entire zip+4 and close your browser.
6. Paste in the zip code and the +4 and Click OK.
7. You will be back at a Legislators grid with only the Legislators that represent that address. Here you can see details about the Legislators, print labels and reports etc.
The fastest way to get started is to import an existing database. The types of databases State Plus supports are: ASCII comma separated/delimited, DBase 3 & 4, FoxPro 2.0 & 2.5, Access and Paradox 3.x and 4.x. If you have an unsupported database, export your data as an ASCII Comma Delimited file.
1. Start State Plus.
2. Click the Grass Roots button on the main menu.
3. Your grid will initially be empty. Click File on the gray menu bar on top and then select Import/Update.
4. A screen will appear asking you to choose the type of database you are importing. Highlight your selection and click OK. For ASCII files, before you import, check to make sure that the first record contains the field names.
5. Browse for the file you wish to import. Highlight the file and click Open.
6. A screen will appear asking you to match the field list of State Plus (grid on the right) with your file fields (grid on the left). You need to click and hold on a State Plus field and drag it over to the appropriate matching field. Ex: Your file's field name = Org. Name, State Plus Field List Name = Company Name
7. If you have extra fields you wish to import into State Plus, but there isn't a matching field name, you can place them under User Defined Field. You can use this field as many times as you wish.
8. After you have finished matching all the fields, click the Replace Records button. When it's finished, it will tell you that the table was imported successfully. Click OK.
9. Your grid should now contain all the contacts you imported. Each Grass Roots contact is automatically linked to their Legislators as constituents at the time of data entry or file import. (It will match to a 5-digit ZIP code but a 9-digit ZIP+4 is more accurate. If you have only 5-digit zip codes contact The Soft Edge, Inc. for more information about our services to add the Zip+4.)
1. Start State Plus.
Use this field: |
For this result: (Example) |