A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - General Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

E-mail database



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old May 26th 07, 07:04 PM posted to microsoft.public.outlook
Walkman
external usenet poster
 
Posts: 3
Default E-mail database

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  
Old May 26th 07, 07:17 PM posted to microsoft.public.outlook
John Blessing
external usenet poster
 
Posts: 60
Default E-mail database


"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  
Old May 26th 07, 07:30 PM posted to microsoft.public.outlook
Walkman
external usenet poster
 
Posts: 3
Default E-mail database

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  
Old May 26th 07, 08:00 PM posted to microsoft.public.outlook
Milly Staples [MVP - Outlook]
external usenet poster
 
Posts: 4,696
Default E-mail database

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  
Old May 26th 07, 09:25 PM posted to microsoft.public.outlook
Walkman
external usenet poster
 
Posts: 3
Default E-mail database

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  
Old May 26th 07, 09:45 PM posted to microsoft.public.outlook
John Blessing
external usenet poster
 
Posts: 60
Default E-mail database


"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
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
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


All times are GMT +1. The time now is 07:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.