Can you set up a simple address book in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MaryAnn - 19 Aug 2006 03:59 GMT

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

Reply to this Message

Desert Piranha - 19 Aug 2006 05:10 GMT

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 i
> 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 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

--
Desert Piranh

Reply to this Message

MaryAnn - 20 Aug 2006 15:12 GMT

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!

> MaryAnn Wrote:
> > Am interested in knowing if anyone has set up a simple address book,
[quoted text clipped - 13 lines]
> code, zip or whatever,
> just by clicking the top of the column i want it sorted by.

Reply to this Message