Congress Plus
How-To Guide
Congress Plus is a Windows Software Program that contains a database of Members of Congress and Congressional Staff. It is used by Congressional Relations Offices as an on-line Congressional Directory, Contact Manager, Grass Roots Contacts Database, and a Communication and Office Productivity Tool.
Features of the Program by Section
Members of Congress(Page 4)
|
This is the most popular section of the program. It contains a listing the 540 Members of Congress. § Query the database to create targeted lists of Members of Congress and Staff. (See How-To Filter) § Lists can then be used to send email. (See How-To Email or the 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 Members. [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). § You can also see the state executive branch of each state. (See How-To Filter for State Executives) These include the Governor, Lt. Governor, Secretary of State, and Attorney General of each state. Mailings can be performed to the state executive branch. |
HTML Email (Page 6)
Available in the Professional Version or as an add-on to Standard Version |
|
|
|
State Legislators
Available as an add-on to Standard or Professional 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) |
State General Info
Included with the State Legislators add-on option |
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.
|
Congress Committees(Page 13) |
This section contains detailed information on each committee and subcommittee, including rosters, key committee staff, and committee jurisdiction. § You can print roster reports. (see How-To Print Committee Rosters) § Print mailing labels. (see How-To Print Committee Staff Labels) § Save merge files which are addressed to the committee mailing address. Individual committee staff can be selected for these mailings. (see How-To Create Committee Mailings) § Link directly to the committee web site for hearing schedules and other information. (see How-To Open Committee Websites) § To combine several committees into one list, use the Members of Congress section. (see How-To Filter for Committees) |
Congress Leadership(Page 14) |
This section contains Senate and House Leadership plus leadership staff. § Senate and House Leadership plus leadership staff are displayed. (see How-To View Leadership and Staff and How-To Print Leadership Reports) |
Zip to DistrictMatch(Page 15) |
This section allows you to find the Members 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(Page 16)
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. Congressional 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 Members of Congress. (see How-To Email an Action Alert) § Merge email is a unique feature where each email can contain the contact information of the recipients Member's of Congress. (see How-To Send a “Contact your Legislators” Email) § Print constituent lists and economic impact statements. (see How-To Print Grass Roots Reports) |
Issue/Bill Tracking(Page 18)
Automated service available in the Professional Version or as an add-on to Standard Version
|
This section allows you to centralize Bill and Issue information. § Centralize Bill and Issue information. (see How-To Add Bills and How-To Add Issues) § Record contact history. (see How-To Manage Whip Lists, How-To Create Journal Entries or How-To Add User Defined Fields) § Produce whip lists. (see How-To Manage Whip Lists) § Eliminate all data entry and instantly update the database with the latest Bill Information from Thomas using the Automated Issue/Bill Tracking upgrade. (see How-To Update Bill Summaries) [Available in the Professional Version or as an add-on to Standard Version – see price list] |
Vote Tracking(Page 20)
Automated service available in the Professional Version or as an add-on to Standard Version |
This section allows you to record and analyze floor votes. § Produce Vote Report Cards. (see How-To Create a Vote Summary/Report Card) § Enter votes on you own. (See How-To Add and Record Votes Manually) § Automated Vote Database option. (see How-To Import Votes) [Available in the Professional Version or as an add-on to Standard Version – see price list] |
Journal(Page 21)
|
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) |
Members of Congress
This option allows you to change the list order of the Members of Congress; the default is alphabetical by last name.
1. Click the Members of Congress button on the main menu.
2. From the gray menu bar select Sort.
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 Congress 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 Members of Congress (File, Email Staff)
Most Members of Congress do not have public email addresses it is best to choose a Staffer to direct the email to even if you formally address it to the Member.
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 Congress 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, Congressional Staff, 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 Congress Plus, click Members of Congress, 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 Congress 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 Congress Plus.
2. Click on the Members of Congress button from the main menu.
3. Select the desired Members. 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, Members of Congress.
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 Congress 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 Congress 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 Congress Plus, create/import your letter and send your broadcast fax.
Use the these fields: |
For this result: |
«FormalName» «CapStreet1» «CapStreet2» «CapCityStZip»
Dear «Salutation»,
|
The Honorable Neil Abercrombie U.S. House of Representatives 1502 Longworth House Office Building Washington, DC 20515-1101
Dear Congressman Abercrombie, |
8 Main Report Types
§ List of Members (opt. Staff Column) - This will print the basic Name/Address/District information and can include a staff column such as Chiefs of Staff, with their email addresses.
§ List of Members Selected Staff, UDFs - This will print basic name and contact information and will allow you to choose which Staff and User Defined Fields that you would like to include in the report.
§ List of Members w/Staff, Cmtes – This will print basic name and contact information along with a full listing of staff names and committee assignments.
§ List of Members w/User Defined Fields – This will print basic name and contact information along with a listing of the UDFs associated with each of those Members and each UDFs’ values.
§ Member Detail Report – This report allows you to include basically all the information in the Members’ 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 Member 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 Member(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 the Journal Section
1. Start Congress Plus.
2. Click the Members of Congress button from the main menu.
3. Highlight the Member 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, 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 Member’s Detail Record
1. Start Congress Plus.
2. Click the Members of Congress button from the main menu.
3. Double click on the Member you wish to make a journal entry for or click on the View Details button after highlighting the Member.
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 Congress Plus.
2. Click on the Members of Congress button on the main menu.
3. Filter your list of Members. (Ex. States/Counties, Florida)
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 Member 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 Members you want to have this UDF or click the Select All button. Clicking a selected Member will unselect them.
9. Click OK.
10. A screen will appear asking, “About to Add New Fields for Selected Members. Are you sure?” then click OK.
11. Those Members should now have a UDF called 'Reception Invitation’ with the Text field value “emailed”, and the Number and Date field values blank.
1. Start Congress Plus.
2. Click on the Members of Congress button on the main menu.
3. Highlight the Member’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 Member only.
7. Click Save. The changes will appear in the grid.
1. Start Congress Plus.
2. Click on the Members of Congress button on the main menu.
3. Highlight the Member’s name and click View Constituents for Selected Legislator.
4. The Grass Roots grid will open showing the constituents of the Members you filtered for that are in your database.
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 Member the next six are for communicating with these grass roots contacts.
1. Start Congress Plus
2. Click on the Members of Congress 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 file to export: Congress or Committees
7. Choose which information to include in the file with the check boxes
8. Click OK and Save the file, PDA_Congress.csv or PDA_Committees.csv, somewhere you will find it easily.
9. Close Congress Plus
10. 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
11. Start your desktop program
12. Click Contacts
13. Create 2 Categories: Congress and Cong Cmtes. Later when you update the data you will delete all the entries for these categories and import the new data from Congress Plus
14. Import the files PDA_Congress and PDA_Committees, make sure the fields are lining up correctly
15. Now sync with your handheld so that the desktop overwrites your handheld.
1. First choose the chamber for the committee you are interested in by clicking the dot next to Senate, House or Joint.