Can you set up a simple address book in Excel

M

MaryAnn

Am interested in knowing if anyone has set up a simple address book, contact
list, in Excel as an alternative to the more complex address book in Outlook
and Access
 
D

Desert Piranha

MaryAnn said:
Am interested in knowing if anyone has set up a simple address book
contact
list, in Excel as an alternative to the more complex address book i
Outlook
and AccessHi Mary Ann,
Click to expand...

I just make that stuff from scratch.
Use one row & seperate columns for:

Name-Adderss-city-state-zip-aea code, tele-~~~

Then put text boxes at the top of the coumns like with the names yo
see above,
with sort codes attached. That way i can sort by name, street, are
code, zip or whatever,
just by clicking the top of the column i want it sorted by
 
M

MaryAnn

I had a request for one with alpha tabs in Excel but I don't want to set up a
separate worksheet for each letter of the alphabet. I think I'll decline the
request and put it in Access anyway. Thanks for replying!
 
Top