CSV For contact users

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dan1el
    Senior Blueparker
    • Jun 2011
    • 385

    #1

    CSV For contact users

    Hi,

    Does anyone know if it is possible to extract a CSV file for users that only wish to be contacted?

    Thanks
    Daniel
  • Dave
    Senior Blueparker
    • Dec 2007
    • 3981

    #2
    Just download all users. Open up in excel, sort by the contact field and then block delete the records for people who don't want to be contacted. Very quick and will be done in a couple of minutes max.
    Regards,

    Dave

    Comment

    • dan1el
      Senior Blueparker
      • Jun 2011
      • 385

      #3
      Thanks Dave,

      Could you provide a little more detail on how to do that? sorry for being a pain, but I am learning

      Thanks
      Daniel

      Comment

      • Dave
        Senior Blueparker
        • Dec 2007
        • 3981

        #4
        Go into users, user manager and then click on the disk icon that has a down arrow on it. This will then create the CSV file and when finished it displays an excel icon. You can then click on this to open up or right click to save on your computer.

        Then open up in excel, highlight all columns and click data sort and sort by the contact column. It will have either a 0 for no contact or 1 to allow contact. Just double check this in user manager for one record because I am not sure I have these the right way round and are not near my pc to check.
        Regards,

        Dave

        Comment

        • dan1el
          Senior Blueparker
          • Jun 2011
          • 385

          #5
          Thanks Dave

          Sorry for the late reply...been very busy the last couple of days!

          Cheers
          Daniel

          Comment

          Working...