.: How to Make a CSV file for your mailing list.
By:Bill Boyd
Category:Home / Internet Marketing / Email
First lets look at WHAT it is, and Why would we want to make one?
CSV means Comma Separated Value, so that means; a ‘value’ that is separated by commas. It is usually made in XL or a txt file.
A ‘value’ is explained, in context below.
CSV files are the most common kind of format used by most software programs for importing data. This means that if we want to put several hundred names and addresses (values) into a “bulk mailing program” we can usually use a CSV file.
The CSV file would have to have all the names and addresses in it, and then we could go to our software program and use the ‘import’ function to upload all the names and addresses (values), with one click instead of spending hours entering each one by hand.
But, how do we get the names and addresses into the CSV file in the first place? It depends where they come from, if we are simply extracting the names and addresses (Values) from one program to another we can often choose to ‘export’ to a file in CSV format. If we have a list of ‘values’ that is, say, in Microsoft word, or some other kind of document, we would first need to copy and paste them into an XL document.
Once all the ‘values’ we want to use, are pasted into the XL document, WITH EACH VALUE IN A SEPARATE COLUMN. We can then save the XL document as a CSV file, and then upload it into our software. Easy!
Before we continue please note: It is often necessary to have these values in our CSV file in a particular order for example; some software, will require Column ‘A’ to have the ‘Name’ and column ‘B’ might have to be the ‘eMail’ or vise versa and etc…. So it’s a good idea to check first.
Some software allows us to choose where each ‘value’ will be loaded to, so in this case, the initial order in our CSV file won’t matter, because in the upload process we may be prompted to select which ‘fields to place which ‘values’ into.
Now, how to turn a XL document into a CSV file!
1. In your XL document with the info you wish to upload. Go to "file/save as" then select the option "as file type" and scroll down to "CSV (Comma Delimited)
2. Then name it "WHATEVERYOUWANT" and click save.
3. Now you will get a window asking a lot of questions.
4. Answer "OK" or "YES", then you'll get about two or three more windows one after the other. Answer each one "OK" or "YES", until it is done then close the workbook. You’ll get more windows again. just answer "OK" and "YES" until it closes
5. Go to your software and find the import function, browse for your file and upload it!
6. Then check your "mailing List" to see the results!
Your CSV file will look like this a, if you saved it correctly!
If it doesn't work for you, make sure it is in this format.
You may find that you need to play around with this a bit, but as long as you finish with an XL document in CSV format, you should be able to upload to just about any program. Of course this isn’t limited to email lists you can use this format for a range of different applications.
Article keywords: how to, csv, software, import, export, xl, csv file, xl file, xl document, eMail, mailing list, names, addresses, group mail, bulk mail, comma separated values, format, formatting, address, names and addresses, upload
Article Source: http://www.articles32.com
Bill Boyd; has a degree in business, he has run several successful email campaigns and found www.internetgoldenweb.com/groupmail/index.html”>this tool useful so he became an affiliate:
To visit his Internet marketing site go here: www.internetgoldenweb.com”>www.internetgoldenweb.com
.: New Email Articles
1). Hot Subscribers For Your Opt In Email Marketing
Opt in email marketing is one of the most powerful affiliates internet programs promotion strategy. Email is still the easiest way to communicate globally. It is extremely cost-effective, because it is 100 % free. This makes the starting point of the opt in email marketing very promising.
2). Are You Keeping Your Online Business Profitable?
With spamming, email marketing becomes a disgraceful activity in the Internet. But with opt in list, online businesses can continue to boost their businesses through email marketing without having to worry about being accused of spamming
3). Got A Website? Leran How To Build And Manage An Opt List
Building and managing an opt in list is the ideal and simplest option to increase website traffic
4). 5 Benefits Of Making a Hyper Responsive Opt Work
Any business big or small must maximize marketing to get the message across
5). Five Top Methods To Leverage Channels Without Overspending!
Before revealing the secrets of the trades, here are myths and fallacies that need to be cleared before one indulges into building an opt-in list
6). Looking For The Ideal Business Partnership?
Opt in lists are not just ordinary mailing lists. It is the very core of an online business existence and survival
7). Do You Want To Utilize Uhe Secrets Of Opt In Lists?
Acquire an opt-in list now or generate one. Either way, you are reaching to people that can be your one of your treasured customers for a long period time.
.: Top Email Articles
1). Email Miscommunication is Too Easy!
We misinterpret, filter, or change 70% to 90% of what we hear. Communicating messages clearly, and in a format that the receiver will understand, is difficult. It’s easy to miscommunicate. By watching which words you choose, your message will be more clearly communicated.
Cause
Why does all this confusion occur? One of the many reasons is that people suffer from information overload.
2). Selling Yourself with Your Article Promotion
Selling Yourself with Your Article Promotion
3). How to Make a CSV file for your mailing list.
First lets look at WHAT it is, and Why would we want to make one?
CSV means Comma Separated Value, so that means; a ‘value’ that is separated by commas. It is usually made in XL or a txt file.
A ‘value’ is explained, in context below.
CSV files are the most common kind of format used by most software programs for importing data. This means that if we want to put several hundred names and addresses (values) into a “bulk mailing program” we can usually use a CSV file.
4). Navigate More Website Activity Through Email Newsletters To Visitors
When you own a business website, you may find if helpful to have a weekly or monthly newsletter full of useful information about your products. Newsletters can be a great way to navigate more website activity your way. Emailing weekly or monthly newsletters can be the best way to update or remind past visitors of your services or products. Extending special offers in those newsletters can generate more website traffic, purchases of services or products and possible referrals from the visitor’s friends and family.
5). Name Squeeze Pages – What Are They and Why Do You Need Them?
There are many terms that are used in the Internet marketing world. Some are confusing, and some are simple. Some are simple but made to sound confusing. Name squeeze is a relatively new term, but it’s a technique that has been around for quite some time.
6). Email Marketing: Affordable Internet Marketing Technique
Email marketing is labeled as a killer method when it comes to effective low-cost Internet marketing endeavors. This is because it is the most widely-used and has the best reputation in bringing targeted traffic to websites. It is used to stay in touch with your customers or prospective customers, send out invitations, or make special offers.
It's as easy as writing an e-mail that may be in a form of a newsletter or a plain announcement, and sending that to as many targeted recipients as possible.
7). A Good Letter Can Make You a Fortune in Direct Mail
Copyright 2006 Peter Woodhead
This is the seventh article in a series of ten.
Now we go back to Maxwell Sackheim. Sackheim is also well known for originating the "Book-of-the Month" club. So what can you learn from Sackheim's Book-of-the-Month club? More than you think. People are lazy. Getting people to take any sort of action is not easy. That's why much of advertising uses deadlines and limited time offers.