Hello John,

Without sending an email to your current list and sorting through the undeliverables, one way is to use Excel.

Do you have the email addresses of your current students?

If you do, get that into an Excel sheet and the same with your ListServ list in the same workbook. What you want to find are the duplicates in both sheets. People not in your ListServ list but who are not in your current student list have probably gone. People not duplicated in your current student list can probably be added to your listserv list.

There's a nice explanation about how to find duplicates in a single workbook but on separate sheets at https://www.excelcampus.com/tips/compare-sheets-duplicates/

A little tip is not to include the header rows in the formula or when highlighting the other list. I have found that Excel does not find all the matches if you do that.

Highlight the email addresses in the current students list, and apply the formula to those. I use a sheets named "check" for things I want to find duplicates of, and the last formula I used when doing this was =COUNTIF(check!$A$2:$A$753,A2)>0

There are probably other ways of doing it, but I use Excel a lot and knowing how to do this is very handy.

Ray

Networks Financial Institute
Scott College of Business
Indiana State University

From: LISTSERV List Owners' Forum <[log in to unmask]> On Behalf Of Johnnie W Adams
Sent: Monday, February 20, 2023 9:42 AM
To: [log in to unmask]
Subject: How to revive an old list?

CAUTION: This message originated from outside of Indiana State University. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Hi, folks,

     I've been asked about a LISTSERV whose owner left us in 2021 and what to do with it. It's a list with student subscribers, so I'm sure there's been a lot of turnover.

     What's the best way to flush that list of subscribers no longer here--that is, with inactive emails?

Thanks,

     John A

--
John Adams
Senior Linux/Middleware Administrator  | Information Technology Services
+1-501-916-3010 | [log in to unmask]<mailto:[log in to unmask]> | http://ualr.edu/itservices<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fualr.edu%2Fitservices&data=05%7C01%7Craymond.thomas%40INDSTATE.EDU%7Cd07f3c33c84e40fe070108db1350aa60%7C3eeabe396b1c4f95ae682fab18085f8d%7C0%7C1%7C638125009461185656%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=0Uwulto%2FLV1fe%2Bk%2BUUnoCPr%2FcJbXhHs9f6ra0WnAAn0%3D&reserved=0>
UA Little Rock


Reminder:  IT Services will never ask for your password over the phone or in an email. Always be suspicious of requests for personal information that come via email, even from known contacts.  For more information or to report suspicious email, visit IT Security<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fualr.edu%2Fitservices%2Fsecurity%2F&data=05%7C01%7Craymond.thomas%40INDSTATE.EDU%7Cd07f3c33c84e40fe070108db1350aa60%7C3eeabe396b1c4f95ae682fab18085f8d%7C0%7C1%7C638125009461185656%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2BpQTqOum6WoVWa0QAOk7Q1K4PehXd1BKsKlSmsLhZzg%3D&reserved=0>.

________________________________

To unsubscribe from the LSTOWN-L list, click the following link:
http://peach.ease.lsoft.com/scripts/wa-PEACH.exe?SUBED1=LSTOWN-L&A=1<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fpeach.ease.lsoft.com%2Fscripts%2Fwa-PEACH.exe%3FSUBED1%3DLSTOWN-L%26A%3D1&data=05%7C01%7Craymond.thomas%40INDSTATE.EDU%7Cd07f3c33c84e40fe070108db1350aa60%7C3eeabe396b1c4f95ae682fab18085f8d%7C0%7C1%7C638125009461185656%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=verZiYVeWz0y%2BcBJBdTX9eJoYlHn2WbSqFjFKfrpZfo%3D&reserved=0>

############################

To unsubscribe from the LSTOWN-L list:
write to: mailto:[log in to unmask]
or click the following link:
http://peach.ease.lsoft.com/scripts/wa-PEACH.exe?SUBED1=LSTOWN-L&A=1