How to Run an Export from the Search Accounts Screen
  • 23 Jan 2024
  • 3 Minutes to read
  • Dark
    Light
  • PDF

How to Run an Export from the Search Accounts Screen

  • Dark
    Light
  • PDF

Article summary

Exporting from the Search Accounts Screen:

There are many benefits of running an Export from the Search Accounts Screen if all you need is a simple List of Accounts with basic account information like address and phone numbers.  

Go to Accounts -> Search Accounts:

Here is the Search Accounts Screen.  Various buttons are boxed in different colors to explain their use below.

  1.  Find the accounts you would like to export
    1.  You can do so by easily pulling them up by Association.  
      1. Check off the box next to Association (boxed in BLACK)
      2. Select the Association you want and hit Search (boxed in PURPLE)
    2.  You can search for account via Notes.
      1. Check off the box next to Notes: (boxed in PINK)
      2. Type in the words you are searching for and hit Search (boxed in PURPLE)
    3. You can search for accounts NOT in an Association.
      1. Check off the box next to Not Asc: (boxed in BLUE)
      2. Select the Association the accounts should NOT be in and hit Search (boxed in PURPLE)
    4. You can search for accounts using any filter previously created or create a new one.
      1. Check off the box next to the work Filter (all this and below is boxed in ORANGE)
      2. Use the Magnifying Glass to smart search for a filter or
      3. Select the down arrow button next to the 3 dots to edit, copy or create a new filter 
      4. Once you have the filter you need, hit Search (boxed in PURPLE)
  2. The default format for your list is the "Account Lookup Standard" (boxed in GREEN)
    1. You may wish to change this lookup to see the columns displaying info differently
      Here is a listing of the different Lookups:

      Account Look Up Standard - Account ID, SystemDisplay1, All Names in separate columns, Address, City State Zip, Address ID, Tels, Email, Account Notes

      Account Look Up Mail Format 1 - Account ID, Last Name, Company Name, His Name, Her Name, Address Line1 - Line 6 (formatted for mailing), Date Entered, Entered By, Line Dear (for letters), Sort, Street Address split into individual columns, Address ID, Account Type - 1=personal, 2=business, Email

      Account Look Up Mail Format 2 - Account ID, Names, Company, Address1, Address2, CityStateZip, Country, Account Type, Line Dear, Sort, Last Name, Street Address in separate column.

      Account Look Up Mail Format 3 - Account Id, Account Code, Last Name, His Name, Her Name, Line1 - Line6, Date Entered, Entered By, Line Dear, Line Dear No Override (salutation not used), Sort, Both Titles, Both Firsts, Both Firsts2(Her Name first), His Full, Her Full, One First, One First Initial, One First2, Both Titles Last Name, His Title, Her Title Standard, System Display (how it appears in the program), Street Address in separate columns, City, State, Zip, Address ID, Salutation, Name Format, Account Notes, Both Inactive 0=False 1=True, Ignore Him, Ignore Her, Account Type, Email

      Account Look Up w/ All Address - Account ID, Company Name, Last Name, His Name, Her Name, Address, City State Zip, Address Type, Street Address in individual columns, Address ID, Address Notes, Tels, Email. An Account that has multiple addresses will display once for each address.

    2.  Use the Magnifying Glass to smart search for a different lookup or use the drop-down arrow
  3. Use the buttons boxed in yellow to help you select the accounts you wish to export and/or select them one at at time from the list.
    Note:
    If you wish to Export the entire list you do not NEED to select the entire list (although you may).  You would just select "No" when you get the pop-up discussed in Step 5.
  4.  Once you have the accounts you wish to export selected you can hit the Export button (boxed in PURPLE).
  5.  A box will pop-up asking you "Would you like to export only the selected record(s)?
    1. If you only want to Export the selected accounts then hit "Yes"
    2. If you do not care and wish to Export the entire list then hit "No".
  6.  To learn how to Download/Save your Export:
    1. As a .csv on Azure Web Browser - click here 
    2.  As an .xlx on Azure Web Browser - click here
    3. On Azure Desktop - click here
You can Export from all the Data Maintenance Screens as well!
This can be VERY useful!



Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.
ESC

Eddy AI, facilitating knowledge discovery through conversational intelligence