Small Newsletter & Labels

[Aka Bubba]

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?

[ktinkel]

Originally Posted by Aka Bubba

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.

[Aka Bubba]

Originally Posted by ktinkel

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

Originally Posted by dthomsen8

See DYMO printers

Originally Posted by dthomsen8

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.

[dthomsen8]

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.

[Steve Rindsberg]

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.

[Aka Bubba]

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.

[Steve Rindsberg]

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

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

[Robin Springall]

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.