Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access or Excel for contact info lists & creating mailing labels
Is there any advantage to using Access over Excel for a simple database
containing names, addresses, phone numbers and basic biographical information? I will eventually want to create mailing labels from the database and extract email addresses to send group emails. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access or Excel for contact info lists & creating mailing labels
Ask an Access person this question and they will respond "You should never
use Excel for a database!" Ask an Excel person this question and they say, "Why, sure you could do it." My response would be: it depends. You say that the database will be simple. But how much data are you talking about? Thousands of names? Or much less? Also: do you contemplate making the database more complex over time? If you are dealing with a lot of data, or you think that this database is the genesis of something more complex, then Access is probably a safe bet. Else, use Excel. Dave -- Brevity is the soul of wit. "KatieVolunteers" wrote: Is there any advantage to using Access over Excel for a simple database containing names, addresses, phone numbers and basic biographical information? I will eventually want to create mailing labels from the database and extract email addresses to send group emails. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access or Excel for contact info lists & creating mailing labels
Katie
I have used both and don't remember much difference although querying and filtering seemed easier using Access but that could be my failing memory. I stick with Excel now because I learned how to make double-numbered raffle tickets using Excel and Word's mailmerge. Some things are just more important than others<g Gord Dibben MS Excel MVP On Wed, 17 Jan 2007 12:58:01 -0800, KatieVolunteers wrote: Is there any advantage to using Access over Excel for a simple database containing names, addresses, phone numbers and basic biographical information? I will eventually want to create mailing labels from the database and extract email addresses to send group emails. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access or Excel for contact info lists & creating mailing labels
Katie,
With Access, you can store the data and make your mailing labels (it's a Report, and there's a wizard for labels). Pulling the data you need is easy. In Excel, you'll have to use Word or Access to do the labels (either can use an Excel list) , unless you want to write macro code in Excel (why bother?). The Mail Merge in Word also has querying capability to pick the records you want. If you don't already have Access or Excel, consider putting the list in a Word table and doing it all there. Or use Excel (if you already have it) for the list, and Word for the labels using the Excel list. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "KatieVolunteers" wrote in message ... Is there any advantage to using Access over Excel for a simple database containing names, addresses, phone numbers and basic biographical information? I will eventually want to create mailing labels from the database and extract email addresses to send group emails. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Discussion (Misc queries) | |||
How do I create mailing labels from microsoft excel | New Users to Excel | |||
Mailing Labels - Excel | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) |