Bonnema on mon 12 jan 98
Dear Clayarters,
Does anyone know of a site where I could get a template for a retail
mailing list for Filemaker Pro? I use a Mac.
Thanks to the people who answered my post about workshops in figure
sculpture. We found a great one in Scottsdale Az. Also a great place to
visit in January if you come from Maine where ice is not nice right now. I
will respond individually to those who wrote to me when I get my old
computer from the shop, hopefully your names will still be on the hard
disk.
Garret Bonnema
--
Garret Bonnema
bonnema@megalink.net
Paul Lewing on tue 13 jan 98
Garret,
I use a dedicated program on my Mac for mailing lists called
MyMailList. It does everything you'd ever want a mailing list program
to do AND NOTHING ELSE! I love it. It cost me $20 about 5 years ago
at Egghead Software. However I hear that Egghead has quit selling Mac
software. So call MySoftware Cop. in Menlo Park, Cal, at 415
325-9372.
Paul Lewing, Seattle
Wendy Rosen on wed 14 jan 98
I'm sure that any contact management template that comes with FMP is a good
start in compiling any database... be sure to add the following.
A field for: Birthdate
Anniversary
Spouses Name
Spending Limit
Customer Type: Wholesale/Retail
Type of Work
Call Back Date
Memo Field (For demographic data.. soccer mom, etc...)
Source Code (Where you saw them first)
Other Sources (Other places you saw them)
Email address
Fax (Many affluent customers have them at work or even home)
The CALL BACK field should be set on a "tickle" or "nag" feature... your
database will automatically bring up all the people you need to call today,
this week, this month, etc... as soon as you open the file! This is
especially good for wholesale customers who might be a little slow pay!
That's all that I can think of at the moment... I'd love to hear what
others have to say. Our database can tell us the name of customers pets,
hobbies, product types and sooo much more. It really helps us create
stronger relationships and discover new needs in the community.
Wendy
>----------------------------Original message----------------------------
>Dear Clayarters,
>Does anyone know of a site where I could get a template for a retail
>mailing list for Filemaker Pro? I use a Mac.
>
>Thanks to the people who answered my post about workshops in figure
>sculpture. We found a great one in Scottsdale Az. Also a great place to
>visit in January if you come from Maine where ice is not nice right now. I
>will respond individually to those who wrote to me when I get my old
>computer from the shop, hopefully your names will still be on the hard
>disk.
>Garret Bonnema
>
>--
>Garret Bonnema
>bonnema@megalink.net
*******************************************
Wendy Rosen
The Rosen Group
Niche & AmericanStyle Magazines
http://americanstyle.com
3000 Chestnut Ave #304 Baltimore, MD 21211
Voice: 410/889-3093 Fax: 410/243-7089
*******************************************
Olivia T Cavy on thu 15 jan 98
Wendy's suggestions make very good business sense. However this is
information can and should be kept manually until you start to use your
computer for customer database purposes. I also keep some of the personal
information in my rolodex telephone book which I use for phone numbers.
That way when I phone, if the customer's partner or employee answers the
phone, I'll be sure to know the name, etc.
I used to speak with the man who controlled the storeroom of our local
HUD office (before they started putting their manuals on line). I chatted
with him the first time and found out that the love of his life was his
pet dog LuLu. So each year when I phoned him to get copies of updated
manuals (which I used in my day job) first I'd ask about LuLu. It was
always quite pleasant. Five minutes later I'd ask for copies of the
books. More than once he'd say he only had a few copies but he was going
to send ME one. I was really sorry when he retired.
The other suggestion in setting up a database is to use a separate field
for data entry of each type of information you might want to use as a
"sort" field. City should be a separate field from state, which is
separate from zip code. Last name should be separate from first name.
I also like to have a separate field which I call salutation. This is for
the way you will address letters. Dear Mr. X or Dear Dan or Dear Dr. Y or
Dear Nickname. We've all seen letters addressed to Dear Mr or Ms
Clayworks instead of Dear Firstname!
BTW I also keep a memo field which allows for several sentences of
information.
Furthermore, when someone gives me a business card, as soon as feasible
I will jot down on the back of the card some information about that
person to help me remember him/her. I might include some notable physical
characteristics, or the date and event where I received the card or where
they live if different from the business address or a mutual
acquaintance. The office supply places sell small boxes with alpha tabs
designed to hold business cards, and I put the cards in one of these
boxes. (Hey- there's another ceramics item to make for all you
box-makers.) I recently came across a card from someone whose name and
computer related business I didn't recognize. When I turned the card
over, I read that this was the juggler at a picnic I'd attended 4 years
ago.
Dan, Wendy's suggestion to use a regular databases works fine. What is
nice is to use an integrated program where you enter the information on a
database program and then use a word processor to call up information
when writing letters, mailing labels and envelopes. Any simple database
program will work fine, but Wendy's suggestion to have one that reminds
you of any dates you've entered in the tickle file would be really nice.
Bonnie
Bonnie D. Hellman
Pittsburgh, PA
work email: oliviatcavy@juno.com
home email: mou10man@sgi.net
On Wed, 14 Jan 1998 10:20:59 EST Wendy Rosen
writes:
>----------------------------Original
>message----------------------------
>I'm sure that any contact management template that comes with FMP is a
>good
>start in compiling any database... be sure to add the following.
>
>A field for: Birthdate
> Anniversary
> Spouses Name
> Spending Limit
> Customer Type: Wholesale/Retail
> Type of Work
> Call Back Date
> Memo Field (For demographic data.. soccer mom, etc...)
> Source Code (Where you saw them first)
> Other Sources (Other places you saw them)
> Email address
> Fax (Many affluent customers have them at work or even
>home)
>
>The CALL BACK field should be set on a "tickle" or "nag" feature...
>your
>database will automatically bring up all the people you need to call
>today,
>this week, this month, etc... as soon as you open the file! This is
>especially good for wholesale customers who might be a little slow
>pay!
>That's all that I can think of at the moment... I'd love to hear what
>others have to say. Our database can tell us the name of customers
>pets,
>hobbies, product types and sooo much more. It really helps us create
>stronger relationships and discover new needs in the community.
>
>Wendy
>
>
>>----------------------------Original
>message----------------------------
>>Dear Clayarters,
>>Does anyone know of a site where I could get a template for a retail
>>mailing list for Filemaker Pro? I use a Mac.
>>
>>Thanks to the people who answered my post about workshops in figure
>>sculpture. We found a great one in Scottsdale Az. Also a great place
>to
>>visit in January if you come from Maine where ice is not nice right
>now. I
>>will respond individually to those who wrote to me when I get my old
>>computer from the shop, hopefully your names will still be on the
>hard
>>disk.
>>Garret Bonnema
>>
>>--
>>Garret Bonnema
>>bonnema@megalink.net
>
>
>
>*******************************************
>Wendy Rosen
>The Rosen Group
>Niche & AmericanStyle Magazines
> http://americanstyle.com
>
>3000 Chestnut Ave #304 Baltimore, MD 21211
>Voice: 410/889-3093 Fax: 410/243-7089
>*******************************************
>
Jennifer Boyer on fri 16 jan 98
Another field that is very useful in your mailing list is a _region_ field.
I have letter codes in mine. A is for local customers, B is for out of
state customers, and customers from the region of each show I do have a
code for that region. I can now do a mailing for a very specific bunch of
people. This is much more flexible than sorting by zip code. I use
Clarisworks, which is an integrated program package. The database takes
care of my mailing list, and mail merges for letters are a snap. Labels are
very easy too.
Jennifer in VT
where we stayed <<<1.5 degrees>>> above freezing rain temp during the
storm....phew. I just read that HALF the trees in northern NY were
seriously damaged...:-(
>----------------------------Original message----------------------------
>Wendy's suggestions make very good business sense. However this is
>information can and should be kept manually until you start to use your
>computer for customer database purposes. I also keep some of the personal
>information in my rolodex telephone book which I use for phone numbers.
>That way when I phone, if the customer's partner or employee answers the
>phone, I'll be sure to know the name, etc.
>
>I used to speak with the man who controlled the storeroom of our local
>HUD office (before they started putting their manuals on line). I chatted
>with him the first time and found out that the love of his life was his
>pet dog LuLu. So each year when I phoned him to get copies of updated
>manuals (which I used in my day job) first I'd ask about LuLu. It was
>always quite pleasant. Five minutes later I'd ask for copies of the
>books. More than once he'd say he only had a few copies but he was going
>to send ME one. I was really sorry when he retired.
>
>The other suggestion in setting up a database is to use a separate field
>for data entry of each type of information you might want to use as a
>"sort" field. City should be a separate field from state, which is
>separate from zip code. Last name should be separate from first name.
>
>I also like to have a separate field which I call salutation. This is for
>the way you will address letters. Dear Mr. X or Dear Dan or Dear Dr. Y or
>Dear Nickname. We've all seen letters addressed to Dear Mr or Ms
>Clayworks instead of Dear Firstname!
>
>BTW I also keep a memo field which allows for several sentences of
>information.
>
>Furthermore, when someone gives me a business card, as soon as feasible
>I will jot down on the back of the card some information about that
>person to help me remember him/her. I might include some notable physical
>characteristics, or the date and event where I received the card or where
>they live if different from the business address or a mutual
>acquaintance. The office supply places sell small boxes with alpha tabs
>designed to hold business cards, and I put the cards in one of these
>boxes. (Hey- there's another ceramics item to make for all you
>box-makers.) I recently came across a card from someone whose name and
>computer related business I didn't recognize. When I turned the card
>over, I read that this was the juggler at a picnic I'd attended 4 years
>ago.
>
>Dan, Wendy's suggestion to use a regular databases works fine. What is
>nice is to use an integrated program where you enter the information on a
>database program and then use a word processor to call up information
>when writing letters, mailing labels and envelopes. Any simple database
>program will work fine, but Wendy's suggestion to have one that reminds
>you of any dates you've entered in the tickle file would be really nice.
>
>Bonnie
>
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Jennifer Boyer
Thistle Hill Pottery
Montpelier, Vt. 05602
jboyer@plainfield.bypass.com
| |
|
