I was wondering if someone knew how to add a placeholder email address to
all contacts? SharePoint wont seem to allow you to import contacts that do
not have
a email address, and I have a client with 4800 contacts and about 90% don't
have email addresses. Manually entering a email address for each would be a
giant pain. I'm wondering if there a tool or option in outlook that will
simply add " to all contacts that do not have anything in
their email field? Maybe there is away to import the contacts without a
email address, i cant seem to find it anywhere. I have searched high and low
and cant seem to find
anything. Thanks in advance for you help!

Here's a workaround:

Use a table view EG Phone List, then Group the Contacts By Email address,
minimised, then give one the the people with no address the addresss
. Drag all other without an address into the group


Read my footer if you don't know the Group By function.


Judy Gleeson [MVP Outlook]
Acorn Training and Consulting
www.acorntraining.com.au

Everyone - turn on your Advanced Toolbars and learn how to use the Field
Chooser and Group by Box!!


"Mike Bailey" wrote in
message ...
I was wondering if someone knew how to add a placeholder email address to
all contacts? SharePoint wont seem to allow you to import contacts that
do
not have
a email address, and I have a client with 4800 contacts and about 90%
don't
have email addresses. Manually entering a email address for each would
be a
giant pain. I'm wondering if there a tool or option in outlook that will
simply add " to all contacts that do not have anything
in
their email field? Maybe there is away to import the contacts without a
email address, i cant seem to find it anywhere. I have searched high and
low
and cant seem to find
anything. Thanks in advance for you help!

thanks for the feedback, sorry for the cross group posting, i was getting
told to put as it in different groups, so i tried a bunch at once.

That works for every field but not the actual email address, it wont let me
drag and drop based on email addresses. its gives me a circle with a line
through it. if i do anything else like phone, fax or whatever, it allows me
to do that. is this a setting? or is it something with my outlook and
exchange, even though this is not the GAL, its just a personal one.


"Judy Gleeson MVP Outlook" wrote in message
...
Here's a workaround:

Use a table view EG Phone List, then Group the Contacts By Email address,
minimised, then give one the the people with no address the addresss
. Drag all other without an address into the group


Read my footer if you don't know the Group By function.


Judy Gleeson [MVP Outlook]
Acorn Training and Consulting
www.acorntraining.com.au

Everyone - turn on your Advanced Toolbars and learn how to use the Field
Chooser and Group by Box!!


"Mike Bailey" wrote in
message ...
I was wondering if someone knew how to add a placeholder email address
to
all contacts? SharePoint wont seem to allow you to import contacts that
do
not have
a email address, and I have a client with 4800 contacts and about 90%
don't
have email addresses. Manually entering a email address for each would
be a
giant pain. I'm wondering if there a tool or option in outlook that
will
simply add " to all contacts that do not have anything
in
their email field? Maybe there is away to import the contacts without a
email address, i cant seem to find it anywhere. I have searched high
and low
and cant seem to find
anything. Thanks in advance for you help!

don't know if this will help you. i had the same problem, someone in
this group (jokingly) suggested a dummy email address, i put the same
dummy address in each contact without a legitimate email address,
solved my problem.

On Tue, 10 Jan 2006 12:12:23 -0500, "Mike Bailey"
wrote:

thanks for the feedback, sorry for the cross group posting, i was getting
told to put as it in different groups, so i tried a bunch at once.

That works for every field but not the actual email address, it wont let me
drag and drop based on email addresses. its gives me a circle with a line
through it. if i do anything else like phone, fax or whatever, it allows me
to do that. is this a setting? or is it something with my outlook and
exchange, even though this is not the GAL, its just a personal one.


"

Yeah I got that to work, but I got 4793 contacts trying to find a more
efficient way.


wrote in message
...
don't know if this will help you. i had the same problem, someone in
this group (jokingly) suggested a dummy email address, i put the same
dummy address in each contact without a legitimate email address,
solved my problem.

On Tue, 10 Jan 2006 12:12:23 -0500, "Mike Bailey"
wrote:

thanks for the feedback, sorry for the cross group posting, i was getting
told to put as it in different groups, so i tried a bunch at once.

That works for every field but not the actual email address, it wont let
me
drag and drop based on email addresses. its gives me a circle with a line
through it. if i do anything else like phone, fax or whatever, it allows
me
to do that. is this a setting? or is it something with my outlook and
exchange, even though this is not the GAL, its just a personal one.


"

Can you copy and paste into thousands at once?? Maybe try Cut, then
select a whole heap and try paste?

Sorry - I didn't try my previous suggestion - obviously if it won't do it,
Outlook is treating the email field in a special way - darn!

Judy Gleeson [MVP Outlook]
Acorn Training and Consulting
www.acorntraining.com.au

Everyone - turn on your Advanced Toolbars and learn how to use the Field
Chooser and Group by Box!!


"Mike Bailey" wrote in
message .. .
Yeah I got that to work, but I got 4793 contacts trying to find a
more
efficient way.


wrote in message
...
don't know if this will help you. i had the same problem, someone in
this group (jokingly) suggested a dummy email address, i put the same
dummy address in each contact without a legitimate email address,
solved my problem.

On Tue, 10 Jan 2006 12:12:23 -0500, "Mike Bailey"
wrote:

thanks for the feedback, sorry for the cross group posting, i was
getting
told to put as it in different groups, so i tried a bunch at once.

That works for every field but not the actual email address, it wont
let
me
drag and drop based on email addresses. its gives me a circle with a
line
through it. if i do anything else like phone, fax or whatever, it
allows
me
to do that. is this a setting? or is it something with my outlook and
exchange, even though this is not the GAL, its just a personal one.


"