Need help adding a "placeholder" email address for Sharepoint

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Bailey - 09 Jan 2006 05:41 GMT

I was wondering if someone knew how to add a placeholder email address to
all contacts? SharePoint wont 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 "blank@blank.com" to all contacts that do not have anything in
their email field? I have searched high and low and cant seem to find
anything. Thanks in advance for you help!

Reply to this Message

Diane Poremsky [MVP] - 10 Jan 2006 13:35 GMT

export to excel and use fill to enter a dummy address in the email field
then import. another option would be to use vba to add it, but unless you
know vba, it's faster to export... if there are notes in the notes field on
the contacts, VBA might be better though, especially if the notes are long.

Signature

Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

>I was wondering if someone knew how to add a placeholder email address to
> all contacts? SharePoint wont allow you to import contacts that do not
[quoted text clipped - 7 lines]
> their email field? I have searched high and low and cant seem to find
> anything. Thanks in advance for you help!

Reply to this Message