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

MaryAnn Wrote:
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 AccessHi Mary Ann,

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 you
see above,
with sort codes attached. That way i can sort by name, street, area
code, zip or whatever,
just by clicking the top of the column i want it sorted by.


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=573337

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!

"Desert Piranha" wrote:


MaryAnn Wrote:
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 AccessHi Mary Ann,

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 you
see above,
with sort codes attached. That way i can sort by name, street, area
code, zip or whatever,
just by clicking the top of the column i want it sorted by.


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=573337