How do I make an editable database of addresses & make labels?

Hello... I'm trying to create a database of addresses that will need to be edited about once every six weeks. I need to be able to convert the addresses into a document that people can download from the internet. I have absolutely no idea how to do this. Do I create an Excel Worksheet? I work with computers as a designer and editor, but cannot make heads nor tails of this program.

I'm working on Word: Mac 2001... well, Office 2001 running on Mac Classic.

Any guidance will be greatly appreciated.

Thanks,
Kipley

Hi Kipley,

Excel is probably the best option for this, letting you manipulate data but
others see and edit it easily. Word is not. Excel is a spreadsheet
program, but I believe it's pretty straightforward to move data between
Excel and actual database programs like 4D or Filemaker Pro. It's also very
easy to set up addresses in Excel and use that spreadsheet as the data
source for a mail merge in Word, to produce labels, form letters, etc. Just
make a column for each separate element of the address (first name, last
name, city, state, etc), start a new row for every person, and then in Word
I think the Mail Merge (under Tools) will walk you through setting up
Labels, one for each row. Try it with five addresses or so, it's pretty
straightforward once you start experimenting.

This is not a particularly Mac-specific issue, but since the menus can be
different, if you need more help a Mac-specific group might be best (or
there is also a general word group devoted to mail merge). See below for
info on that.

DM

microsoft.public.mac.office.word
microsoft.public.mac.office
microsoft.public.mac.office.excel
microsoft.public.mac.office.powerpoint
microsoft.public.mac.office.entourage

You can access these through the MS site, via Google Groups, or by setting
up a newsreader.

For direct links to the Google interface for Mac NGs:
http://www.microsoft.com/mac/community/community.aspx?pid=newsgroups

For the substandard interface on the MS site:
http://communities2.microsoft.com/co...s/default.aspx
?guid=366BA05D-4181-BB41-B201-4C83D5F6024C

Newsreaders are usually most efficient--here's a link on how to configure a
newsreader (e.g. Entourage or Outlook Express)
http://www.microsoft.com/mac/communi...sgroups&page=n
ewsgroupsetup

Here's a link on how to spamproof your address to protect it if using
Entourage:
http://www.entourage.mvps.org/help/nospam.html
If using Outlook Express
http://homepage.ntlworld.com/techie.grim/macfaq/articles/046.html





"Kipley" wrote:

Hello... I'm trying to create a database of addresses that will need to be
edited about once every six weeks. I need to be able to convert the addresses
into a document that people can download from the internet. I have absolutely
no idea how to do this. Do I create an Excel Worksheet? I work with computers
as a designer and editor, but cannot make heads nor tails of this program.
I'm working on Word: Mac 2001... well, Office 2001 running on Mac Classic.

Any guidance will be greatly appreciated.

Thanks,
Kipley