DTP


 
Lively discussions on the graphic arts and publishing — in print or on the web


Go Back   Desktop Publishing Forum > General Discussions > General Publishing Topics

Reply
 
Thread Tools Display Modes
Old 02-09-2007, 11:40 PM   #1
Aka Bubba
Member
 
Join Date: Feb 2007
Location: Anchorage, AK
Posts: 3
Default Small Newsletter & Labels

I am putting together a small local news letter for a local club. And I need to create a subscriber database that shows:

Subscription Date
Subscription Expiration
Name
Address
Phone

I remember doing this a while back when I was in school using Access and excel but that was so long ago I would not even know where to start. Is there any software out there now that you can simply type in the info and have print out the labels ready to apply?
Aka Bubba is offline   Reply With Quote
Old 02-10-2007, 06:41 AM   #2
ktinkel
Founding Sysop
 
ktinkel's Avatar
 
Join Date: Oct 2004
Location: In Connecticut, on the Housatonic River near its mouth at Long Island Sound.
Posts: 11,187
Default

Quote:
Originally Posted by Aka Bubba View Post
I am putting together a small local news letter for a local club. And I need to create a subscriber database that shows:

Subscription Date
Subscription Expiration
Name
Address
Phone

I remember doing this a while back when I was in school using Access and excel but that was so long ago I would not even know where to start. Is there any software out there now that you can simply type in the info and have print out the labels ready to apply?
Do you need other functions? Keeping track of expirations, renewal followups, payments, for example? Or just the labels?

For labels, there are small label printers that connect to your computer by USB. They work with common databases — not sure which, but suspect you couuld use Excel’s database functions.

   
__________________
[SIZE=2][COLOR=LemonChiffon]::[/COLOR][/SIZE]
[SIGPIC][/SIGPIC]
ktinkel is offline   Reply With Quote
Old 02-10-2007, 09:40 AM   #3
Aka Bubba
Member
 
Join Date: Feb 2007
Location: Anchorage, AK
Posts: 3
Default

Quote:
Originally Posted by ktinkel View Post
Do you need other functions? Keeping track of expirations, renewal followups, payments, for example? Or just the labels?
You got it! I was going to go get a Access for dummies book or something if there is no software at present that will accomplish this for me with having me to actually go in and build a database of sorts like access

Quote:
Originally Posted by dthomsen8 View Post
See DYMO printers

Quote:
Originally Posted by dthomsen8 View Post
Let us know what you decide.
If it is the DYMO as in the handheld / desktop. I have one and the software that came with it limits me as to what I actually want to achieve with it.

We will have anywhere between 200-300 news letters. I need a way to keep track of expirations, renewal follow-ups, payments, address, and contact info.

Last edited by ktinkel; 02-10-2007 at 01:58 PM. Reason: fixed problem with quotes
Aka Bubba is offline   Reply With Quote
Old 02-10-2007, 08:06 AM   #4
dthomsen8
Member
 
dthomsen8's Avatar
 
Join Date: Aug 2005
Location: Philadelphia, PA 19130
Posts: 2,158
Default Label Software

Some label printers come with software, and some also allow you to print stamps downloaded from the USPS.GOV site. See DYMO printers for that, if you are located in the USA. There are cheap and maybe free/shareware programs which do contact information, and are likely to interface with a label printer.

Let us know what you decide.
dthomsen8 is offline   Reply With Quote
Old 02-10-2007, 10:55 AM   #5
Steve Rindsberg
Staff
 
Join Date: Nov 2004
Posts: 7,571
Default

You didn't say whether you're on PC or Mac. If PC, have a look at an inexpensive program called My MailList Deluxe (it's available at places like Staples and the like).

I manage a mailing list for a group that puts on a bike ride once a year. We mail or email to a list of around 2000 and use it to track and schedule 125 or so committee members and volunteers.

It's flexible enough that I've been able to dump everybody into one monster file and use filters to separate out just the subgroups I'm after. It'll print letters, reports, mailing labels and even send bulk email.

It imports and exports Excel and other common database file formats quite handily, so you're not locked into its own file format.

I bought it just to get over the immediate problem of dealing with this list when I first took it over; figured I'd get out the first mailing then dump it for something better. Haven't found anything better and I'm gearing up to use it for the third year running.

   
__________________
Steve Rindsberg
====================
www.pptfaq.com
www.pptools.com
and stuff
Steve Rindsberg is offline   Reply With Quote
Old 02-10-2007, 01:39 PM   #6
Aka Bubba
Member
 
Join Date: Feb 2007
Location: Anchorage, AK
Posts: 3
Default

Steve

I am a PC user. I will look into it some more and see what the software is all about, but by the sounds of it. I think it will do exactly what I am after and need.

Thank you for the info.
Aka Bubba is offline   Reply With Quote
Old 02-11-2007, 01:54 PM   #7
Steve Rindsberg
Staff
 
Join Date: Nov 2004
Posts: 7,571
Default

You're welcome. Here's the URL by the way:

http://www.avanquestusa.com/products...y_mail_dlx.asp

   
__________________
Steve Rindsberg
====================
www.pptfaq.com
www.pptools.com
and stuff
Steve Rindsberg is offline   Reply With Quote
Old 02-12-2007, 10:42 AM   #8
Robin Springall
Member
 
Robin Springall's Avatar
 
Join Date: Feb 2005
Location: Ealing Common, London W5, where I duplicate CDs and DVDs.
Posts: 1,259
Default

I use Microsoft Works for our residents' association: the Works database is quick and easy, and you can use its field to do mail merge address labels in the Works version of Word. The great thing is that the suite is bundled free with many PCs.

   
__________________
Robin
Intellectually challenged, alcoholically propelled
Robin Springall is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Seeking Newsletter Designer BobRoosth Print Design 6 01-26-2007 07:22 AM
Help! PDF Newsletter Doc Mitzi123 General Publishing Topics 29 04-11-2006 11:15 PM
Tired of Word for publishing newsletter cotu General Publishing Topics 9 02-24-2006 01:29 PM
Free newsletter, font bargains ktinkel Fonts & Typography 0 02-11-2005 02:52 PM


All times are GMT -8. The time now is 05:10 PM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2022, vBulletin Solutions, Inc.
Contents copyright 2004–2019 Desktop Publishing Forum and its members.