RE: [IMail Forum] Merge two mail lists
Regards, [EMAIL PROTECTED] -- Original Message -- From: Matthew Lohr [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 8 Jun 2001 09:00:56 -0400 if you have sql server you can easily do it import the first list into a table that doesn't allow duplicates. Then import the second one and it will only import the unique records -- Original Message -- From: Rod Dorman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 7 Jun 2001 11:24:35 -0400 d u s t i n wrote: Hi there... I'm looking for an easy way to merge two existing Imail mailing lists, and remove any duplicate enteries... A quick 'n dirty method would be to concatenate the two lists, sort it, then edit it and remove the dupes. -- [EMAIL PROTECTED] The avalanche has already started, it is too Rod Dorman late for the pebbles to vote. Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
RE: [IMail Forum] Merge two mail lists
hi, upload both lists to excel and check for duplicates and save as single text file. This is easy and fast. RR -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Demo Account Sent: Tuesday, June 12, 2001 12:13 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: [IMail Forum] Merge two mail lists Regards, [EMAIL PROTECTED] -- Original Message -- From: Matthew Lohr [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 8 Jun 2001 09:00:56 -0400 if you have sql server you can easily do it import the first list into a table that doesn't allow duplicates. Then import the second one and it will only import the unique records -- Original Message -- From: Rod Dorman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 7 Jun 2001 11:24:35 -0400 d u s t i n wrote: Hi there... I'm looking for an easy way to merge two existing Imail mailing lists, and remove any duplicate enteries... A quick 'n dirty method would be to concatenate the two lists, sort it, then edit it and remove the dupes. -- [EMAIL PROTECTED] The avalanche has already started, it is too Rod Dorman late for the pebbles to vote. Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
RE: [IMail Forum] Merge two mail lists
if you have sql server you can easily do it import the first list into a table that doesn't allow duplicates. Then import the second one and it will only import the unique records the 32-bit unixdos tookit from http://www.profsoftware.com/ can do this job in milliseconds for many $1000´s less. :))) Len http://MenAndMice.com/DNS-training http://BIND8NT.MEIway.com : ISC BIND 8.2.4 for NT4 W2K http://IMGate.MEIway.com : Build free, hi-perf, anti-abuse mail gateways Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
RE: [IMail Forum] Merge two mail lists
d u s t i n wrote: Hi there... I'm looking for an easy way to merge two existing Imail mailing lists, and remove any duplicate enteries... A quick 'n dirty method would be to concatenate the two lists, sort it, then edit it and remove the dupes. -- [EMAIL PROTECTED] The avalanche has already started, it is too Rod Dorman late for the pebbles to vote. Ambassador Kosh Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
Re: [IMail Forum] Merge two mail lists
It was just using the internal DB. Thanks. Dustin - Original Message - From: Matthew Lohr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 08, 2001 6:00 AM Subject: RE: [IMail Forum] Merge two mail lists if you have sql server you can easily do it import the first list into a table that doesn't allow duplicates. Then import the second one and it will only import the unique records -- Original Message -- From: Rod Dorman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 7 Jun 2001 11:24:35 -0400 d u s t i n wrote: Hi there... I'm looking for an easy way to merge two existing Imail mailing lists, and remove any duplicate enteries... A quick 'n dirty method would be to concatenate the two lists, sort it, then edit it and remove the dupes. -- [EMAIL PROTECTED] The avalanche has already started, it is too Rod Dorman late for the pebbles to vote. - Ambassador Kosh Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Sent via the WebMail system at lohrtech.com Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
Re: [IMail Forum] Merge two mail lists
IMail'l List Servers use files for storing members addresses, so combine the 2 user.lst and user.txt files. Finding duplicates will require a tool to do that. Sorry, I have no recommendations for one, but I'm almost sure there must be one! Daniel Donnelly - Original Message - From: :: d u s t i n :: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 8:14 PM Subject: [IMail Forum] Merge two mail lists Hi there... I'm looking for an easy way to merge two existing Imail mailing lists, and remove any duplicate enteries... Any words of wisdom? Thanks in advance. d Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
Re: [IMail Forum] Merge two mail lists
What I ended using was a list tool at www.analogx.com it allows you to remove duplicate emails. I ran it on both files, then saved the new one. The only downside was that on the one file that listed the email address and the name, it replaced the names with the full email address... so the file was as follows. [EMAIL PROTECTED] [EMAIL PROTECTED] Which was acceptable for me since I had to get this done. So once it was done, I just sent an email out to my list , and stated that if they wanted to unsubscribe that they would have to use their email address in both fields. The only bummer of the whole thing, was that I also had to add a listbot list into the same list, and listbot only exports 1 email address per line, so i had to modify the second file and add the and name. thank god it was only an 800 email address list, but it still sucked! Dustin - Original Message - From: Daniel Donnelly [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 6:56 AM Subject: Re: [IMail Forum] Merge two mail lists IMail'l List Servers use files for storing members addresses, so combine the 2 user.lst and user.txt files. Finding duplicates will require a tool to do that. Sorry, I have no recommendations for one, but I'm almost sure there must be one! Daniel Donnelly - Original Message - From: :: d u s t i n :: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 8:14 PM Subject: [IMail Forum] Merge two mail lists Hi there... I'm looking for an easy way to merge two existing Imail mailing lists, and remove any duplicate enteries... Any words of wisdom? Thanks in advance. d Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/