Add a number series to existing contacts (MS 2003)

A

Angie

I have over 1000 Contacts in my database. I'd like to add a unique 4 digit
ID Code Number for each Contact. ie; Numbers 1000 to 2000. Is there a quick
way to do this? I've added a user-defined field to my contacts, but I
couldn't find a way to export/import numbers from Excel to update existing
contacts. Any thoughts anyone?
Thank-you in advance
 
M

Michael Bauer [MVP - Outlook]

It could be done with VBA. But ensuring that the number really stays unique
isn't easy or done with just a few lines of code, respectively.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Mon, 21 Sep 2009 00:24:47 +1200 schrieb Angie:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook 2013: assign new categories to several thousand existing contacts 0
How do I import a contact list from excel to Outlook? 8
Odd behavior when importing contacts from Excel 8
adding area code when synchronizing with mobile 1
add Customer ID to Contacts form 2
Can't find all my contacts after O2007 reinstall 5
Problems Importing Excel to Outlook 1
Add new catagory to existing contacts 1

Top