Problem Creating mailing lists - Virtual Assistant Forums

e-IndyOffice · #1 (**permalink**) 06-23-2009

Several clients have approached me requesting mailing lists to use for email and newsletter marketing. Both clients just have business cards only - no created list.

Please suggest the best way to create a usable mailing list. I know how to do in excel only. I am aware it can be done in Access, but don't know this program.

Any suggestions?

Janet

Action Jackson VA · #2 (**permalink**) 06-23-2009

First question:
1> Are you creating it to give to them?
2> If so, go with Excel as they may be more famillure with it than Access.
3> If not, What email program are you using? I use Outlook and create a distribution list with it. Google, Yahoo, and many other email programs also allow you to do this. Then I can send out E-Mail blasts to those on the list. I do it in the fashion of sending it TO: myself and then BCC the email list.

virtuallyrobin · #3 (**permalink**) 06-23-2009

I think using Excel is the best method also if it is something you are putting together for a client. The method Andrea mentioned is the exact thing I do in Outlook. If you need any assistance with getting it set up, let me know... I'd be happy to help out.

Robin
__________________
Virtually Robin

Essential Office Solutions · #4 (**permalink**) 06-24-2009

Janet;

You mention the clients want to use these lists for emailing -- if that is the case what program will they be emailing and are these mass emails?

The CAN-SPAM Act requires that an address must be given the option to opt out of the future mailings and must not be used again. To effectively due this a true email program should be used such as I Contact. Using Excel makes this very easy as the Excel file can be imported into this type of program and it will eliminate duplicates.

You should check with your clients and get a clear picture of their intentions for these lists and suggest the appropriate program for their use. The forum has many threads regarding I Contact, CAN-SPAM Act and questions relating to this topic.

Good luck,

e-IndyOffice · #5 (**permalink**) 06-24-2009

Ladies,

Thank you for your input. I have been suggesting using Excel for the database since most people know how to use it. Since I have not used a email program yet, I wanted to be sure most email programs such as mail chimp, etc. the excel spreadsheet can be imported to use with the email program.

Thanks for your help and suggestions.

Janet

divajant · #6 (**permalink**) 06-24-2009

I am new to this website, and I am so glad to be here! I have never heard of the CAN-SPAM act. I maintain an email list for a newsletter that I publish monthly. What do I need to do to stay legit? Thanks for info by the way.

Olinda Services · #7 (**permalink**) 06-25-2009

Excel is an excellent way to input addresses and can easily upload into Outlook or other programs. I use AWeber for my clients newsletters and emailings and you can input address from Excel and also export reports to AWeber. Many companies now limit how many emails you can send out before you are labeled as a spammer. Be very careful about sending emails for clients from your personal or professional email address. I now exclusively use a double opt-in for clients to protect myself. I maintain email lists ranging from 20 to hundreds. The cost for AWeber is minimal when it is divided between the clients that I support.

e-IndyOffice · #8 (**permalink**) 06-25-2009

Lisa,
Thank you for your comments and introduction to AWeber. I will use a mailing service like mailchimp to avoid being labeled a spammer. I will look at AWeber as another option to use.

Janet