I currently have 180+ email addresses and I need to send emails out to for a Verterans Club at a college (I work in the VA [Veterans' Affairs] office at OCC in New Jersey).
Currently I am using Distribution Lists (DLs) inside of Outlook 2003 but there is a limit of about 80 emails per DL- meaning that I have have 2 full DLs and one DL with a few addresses in it. I get a list of emails generated by our system but updating the DLs can be manually intensive. My current system is:
1) Generate the report. This gets emailed to me with each email address on its own line. (not a problem)
2) Save the email list as a text file stripping out blank lines and extraneous information. (not a problem) Date the file.
3) When I need to update the DL I will take a diff between the two files (I use unxutils/diff.exe to do this). (problem for non-techies)
4) From the diff I find out what email addresses were added and which where deleted (last time I ran after 7 days there were 7 adds and 1 delete). (problem for non-techies)
5) Manuallly update the 3 DLs having to guesstimate which DL the delete(s) will come from and placing the adds in the last DL. (time consuming)
I am thinking of going lower tech and just saving the email addresses from the report as a text file. When it comes time to send an email just opening that up to copy and paste the email addresses into the To: line.
Anyone got an opinion on what the "best" method would be?
Thanks in advance!
Currently I am using Distribution Lists (DLs) inside of Outlook 2003 but there is a limit of about 80 emails per DL- meaning that I have have 2 full DLs and one DL with a few addresses in it. I get a list of emails generated by our system but updating the DLs can be manually intensive. My current system is:
1) Generate the report. This gets emailed to me with each email address on its own line. (not a problem)
2) Save the email list as a text file stripping out blank lines and extraneous information. (not a problem) Date the file.
3) When I need to update the DL I will take a diff between the two files (I use unxutils/diff.exe to do this). (problem for non-techies)
4) From the diff I find out what email addresses were added and which where deleted (last time I ran after 7 days there were 7 adds and 1 delete). (problem for non-techies)
5) Manuallly update the 3 DLs having to guesstimate which DL the delete(s) will come from and placing the adds in the last DL. (time consuming)
I am thinking of going lower tech and just saving the email addresses from the report as a text file. When it comes time to send an email just opening that up to copy and paste the email addresses into the To: line.
Anyone got an opinion on what the "best" method would be?
Thanks in advance!