![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
I am new to Outlook, so I am still getting my feet wet and trying to maximize
the program. I work for a professional association that has a email contact list of members of about 1500 different email addresses. When we get new email addresses to add to our list, i need to be sure that they are not duplicates of addresses we already have. Any ideas on how to do this, without making a separate contact for each email address in outlook? I tried an excel spread sheet, but that will not notify me of a duplicate, it will only show me duplicates it I sort it alphabetically. For example, if I am adding " to the end of our list, and that email address is already in the list toward the top, I need something that will indicate to me that the address is already there. |
#2
|
|||
|
|||
![]() "Walkman" wrote in message ... I am new to Outlook, so I am still getting my feet wet and trying to maximize the program. I work for a professional association that has a email contact list of members of about 1500 different email addresses. When we get new email addresses to add to our list, i need to be sure that they are not duplicates of addresses we already have. Any ideas on how to do this, without making a separate contact for each email address in outlook? I tried an excel spread sheet, but that will not notify me of a duplicate, it will only show me duplicates it I sort it alphabetically. For example, if I am adding " to the end of our list, and that email address is already in the list toward the top, I need something that will indicate to me that the address is already there. I am not sure from your description, what you are using to store the list. If it is as Outlook Contacts, then OUtlook itself will warn you. If it really is in a database, then you need to run a Select query. -- John Blessing http://www.LbeHelpdesk.com - Help Desk software priced to suit all businesses http://www.room-booking-software.com - Schedule rooms & equipment bookings for your meeting/class over the web. http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace, send newsletters |
#3
|
|||
|
|||
![]()
I am not using anything currently that will do what I want. Right now I am
using Excel with one address per line. When I add a new addresses however, I have to re-sort alphabetically and then look line by line for duplicates which is very slow and annoying. So I am looking for something that will notify my when I input the new address if it already exists to speed things up "John Blessing" wrote: "Walkman" wrote in message ... I am new to Outlook, so I am still getting my feet wet and trying to maximize the program. I work for a professional association that has a email contact list of members of about 1500 different email addresses. When we get new email addresses to add to our list, i need to be sure that they are not duplicates of addresses we already have. Any ideas on how to do this, without making a separate contact for each email address in outlook? I tried an excel spread sheet, but that will not notify me of a duplicate, it will only show me duplicates it I sort it alphabetically. For example, if I am adding " to the end of our list, and that email address is already in the list toward the top, I need something that will indicate to me that the address is already there. I am not sure from your description, what you are using to store the list. If it is as Outlook Contacts, then OUtlook itself will warn you. If it really is in a database, then you need to run a Select query. -- John Blessing http://www.LbeHelpdesk.com - Help Desk software priced to suit all businesses http://www.room-booking-software.com - Schedule rooms & equipment bookings for your meeting/class over the web. http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace, send newsletters |
#4
|
|||
|
|||
![]()
Outlook's contacts will do that as John said.
-- Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. After furious head scratching, Walkman asked: | I am not using anything currently that will do what I want. Right now | I am using Excel with one address per line. When I add a new | addresses however, I have to re-sort alphabetically and then look | line by line for duplicates which is very slow and annoying. So I am | looking for something that will notify my when I input the new | address if it already exists to speed things up | | "John Blessing" wrote: | || || "Walkman" wrote in message || ... ||| I am new to Outlook, so I am still getting my feet wet and trying to ||| maximize ||| the program. ||| ||| I work for a professional association that has a email contact list ||| of members of about 1500 different email addresses. When we get new ||| email addresses to add to our list, i need to be sure that they are ||| not duplicates ||| of addresses we already have. ||| ||| Any ideas on how to do this, without making a separate contact for ||| each email address in outlook? I tried an excel spread sheet, but ||| that will not notify me of a duplicate, it will only show me ||| duplicates it I sort it alphabetically. ||| ||| For example, if I am adding " to the end of our list, ||| and that ||| email address is already in the list toward the top, I need ||| something that will indicate to me that the address is already ||| there. || || I am not sure from your description, what you are using to store the || list. If it is as Outlook Contacts, then OUtlook itself will warn || you. If it really is in a database, then you need to run a Select || query. || || || -- || John Blessing || || http://www.LbeHelpdesk.com - Help Desk software priced to suit all || businesses || http://www.room-booking-software.com - Schedule rooms & equipment || bookings for your meeting/class over the web. || http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, || find/replace, send newsletters |
#5
|
|||
|
|||
![]()
So then I would make 1500 different contacts, one for each of the email
addresses? "Milly Staples [MVP - Outlook]" wrote: Outlook's contacts will do that as John said. --Â Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. After furious head scratching, Walkman asked: | I am not using anything currently that will do what I want. Right now | I am using Excel with one address per line. When I add a new | addresses however, I have to re-sort alphabetically and then look | line by line for duplicates which is very slow and annoying. So I am | looking for something that will notify my when I input the new | address if it already exists to speed things up | | "John Blessing" wrote: | || || "Walkman" wrote in message || ... ||| I am new to Outlook, so I am still getting my feet wet and trying to ||| maximize ||| the program. ||| ||| I work for a professional association that has a email contact list ||| of members of about 1500 different email addresses. When we get new ||| email addresses to add to our list, i need to be sure that they are ||| not duplicates ||| of addresses we already have. ||| ||| Any ideas on how to do this, without making a separate contact for ||| each email address in outlook? I tried an excel spread sheet, but ||| that will not notify me of a duplicate, it will only show me ||| duplicates it I sort it alphabetically. ||| ||| For example, if I am adding " to the end of our list, ||| and that ||| email address is already in the list toward the top, I need ||| something that will indicate to me that the address is already ||| there. || || I am not sure from your description, what you are using to store the || list. If it is as Outlook Contacts, then OUtlook itself will warn || you. If it really is in a database, then you need to run a Select || query. || || || -- || John Blessing || || http://www.LbeHelpdesk.com - Help Desk software priced to suit all || businesses || http://www.room-booking-software.com - Schedule rooms & equipment || bookings for your meeting/class over the web. || http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, || find/replace, send newsletters |
#6
|
|||
|
|||
![]() "Walkman" wrote in message ... So then I would make 1500 different contacts, one for each of the email addresses? IMO, a database is by far the most flexible place to keep information like this. But only if you know what you are doing. e.g. you need to know what "select" and in particular "select distinct" means. If you don't and can't pay someone who does, put them in Outlook instead. -- John Blessing http://www.LbeHelpdesk.com - Help Desk software priced to suit all businesses http://www.room-booking-software.com - Schedule rooms & equipment bookings for your meeting/class over the web. http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace, send newsletters |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail merge and Access database help. | Malhyp | Outlook - Using Forms | 1 | January 20th 07 03:55 PM |
creating mail list from column in external database | Glen | Outlook - General Queries | 1 | September 14th 06 11:22 PM |
Export e-mail strings to database | [email protected] | Outlook and VBA | 3 | May 23rd 06 09:40 PM |
Export e-mail strings to database | [email protected] | Outlook and VBA | 0 | May 22nd 06 03:32 PM |