Tag: creating

How to export Outlook Distribution List to #creating #a #distribution #list #in #outlook, #software

#

How to export Outlook Distribution List to .csv file format

42 thoughts on How to export Outlook Distribution List to .csv file format

i WOULD LIKE TO EXPORT MORE THAN ONE DISTRUBUTION CONTACT AT A TIME. IS THIS POSSIBLE, IS SO HOW i HAVE 600 TO DO

Does not work!
All I get in the final Excel file (CSV) is the name of the Distribution list rather than each contact/email separately

Dude that is a ugly solution.

Here is a better one that will require a little bit of work but neater. I m using Outlook 2003

Click Contacts.
On the Menu Bar, Go to File New, click on Folder.
In the Create New Folder window,
type in a name (I use Export but can be anything)
Select Contact Items in Folder Contains drop down list.
Under Select Where to Place Folder I just choose Personal Folders.

Unfortunately you can t export the distribution list directly. But what you can do is copy all the contacts from your main Contacts folder into the Export folder.

So in the top left of the outlook window you should see under My Contacts Contacts, Search Results and the newly created Export.

Click on contacts, under current view I would choose Phone List or by Category (I created categories for my distribution lists now, it makes the next part easier.)
Holding CTRL down click on each contact you want to export.
When you are done, Choose Copy from the Edit menu bar.
Click on the Export contact folder and Paste.

Then export as normal
File Import and Export
Select Export to a File, Next
Select Comma Separated Values (windows), Next
Select folder to export from Export, Next
name the file, map the fields and you re done.

thanks so much for sharing, yes, your method above works well too.

Monique replied on December 15th, 2009 :

How can this be done in 2007?

Bill replied on January 10th, 2011 :

Leah replied on June 24th, 2011 :

WebGuru-
I followed your instructions and worked perfectly. Just one question how do I keep the last name and first name in two separate columns. Right now I have 2 columns: 1 with firstname lastname. and 1 with email.

This worked well. It s not ugly.

Thank you! I use 2007 and it worked wonderfully.

I m using Outlook 2003. I am unable to find any way to list my various Distribution Lists of which I have 7. They are outdated, I want to delete the DLs. In the Outlook folder list, all I have is Contacts without any + no way to see the DL names. If I click to create a new email, I can then click in To: CC: BC: then click on the Contact box (upper right corner), see a DL name then select it then click in one of the choices in which to paste the list. I then copy the list past it into Word (as a table) or Excel. However, I see NO way to DELETE a DL that I want to Delete.

Any suggestions? I do NOT want to Delete my list of Contacts just the DLs (all of them).

Milton replied on March 3rd, 2011 :

Thank you. Super helpful!

You have no idea how many hours you have just saved me, or maybe you do. Thank You!

I found this worked perfectly first time THANK YOU!

I have many distribution lists with about 50 contacts in each. Since DL can not be used for mail merge, how can i take the contacts that are already in a distribution list and catagorize them by color to use in a mail merge to get around this problem without “doing them over?”

I have a group that I created in my distribution list along with all my contacts. I have about 35 in this group and I m trying to send it (export it?) to another person. Any ideas on how to do this?

Well, I have a weird problem here.

What I am trying to do, is to get the First Name and the Email IDs of all the people in a Distribution List. I am going to use Mail Merge to send emails to each of them in the distribution list, seperately. I would need (at least) their first names and email IDs to do so

Can anyone throw some light on this? How would I get a list of all the email IDs and their respective first names (preferably in an excel workbook), so that I can use Mail Merge to send them emails later?

Thanks in advance!

Note: I do not want to add each of them to my outlook address book, as I am going to send emails to many and the distribution list would change each time I do so





Tags : , , , , , , ,

Best Investment Options – Making money by creating a website #window #cleaning #business

#small scale business

#

Making money by creating a website/blog

Overview
Creating a website for selling products and services is one of the best ways of making money. However to create a website or blog, it may take lot of time and energy. On top of this, we need to spend lot of money.

There are various ways for which a website is created
Website for selling products and services
Website for sharing the hobbies and providing services
Website for company information / product information purpose

How to create a website
There are two parts here.
1) Registration of a domain name (the name of the website which people would type the address and browse) and
2) Hosting the website (running the website from a server).
3) Designing the website

Domain Name registration. There are lots of websites which offer domain name registrations which start from USD 2 / Rs.100 per year

Hosting. Website can be done with any of the hosting companies. The charges would be USD 100 / Rs.5,500 per annum. There are various players like Godaddy.com, Rock.in etc.

Designing the website: There are various design templates which available with low costs. There are free templates available which has certain limitations.
Content of the website: This is a major step where the success of the website depends. Selection of popular topics would enable users interest.

Creating traffic for the website
Another key step in this process is to create traffic for the website. Unless there is enough traffic generated, there is no way we can earn money. There are various ways on how you can generate traffic for your website.
1) Build your website SOE based (Search engine optimization based). The major traffic generated through search engines like Google, yahoo are the true traffic which comes to your website. Hence SOE optimized website would generate more traffic
2) Creating traffic by advertising on various websites which is termed as Paid traffic
3) Ask someone to work as affiliate marketing for your website. They would generate the traffic for your website

7 ways to make money out of your website
1) Pay per click (PPC) You can sign-up for Google ad sense to earn the revenue. Once you sign-up, Google will provide necessary code which you need to put in on your website and the Google Ads appear in your site. Any of your user / subscribe who visits your website, clicks on the Google Ads, then you would get paid.
2) Cost per impression (CPI) The Ad banner can be charged based on 1000 impressions. Based on the CPI the ad banner charges would apply starting from USD 0.25 to USD 50.
3) Direct banner advertisement: One can directly go to the customers and do the banner advertisement. However, this method takes time and manpower effort.
4) One can make money through website by e-books selling. Good e-books selection is the key to be success.
5) Affiliate marketing. One can work as affiliate marketing and make money. Recommend the third party products and make the money
6) Text links. One can money by adding text links to the website content and when one clicks on these text links, these would direct to the customer website
7) Writing articles/review. Articles can be written for a specific product / customer and in turn customer pays the money

Conclusion:
1) To create website, you need to have domain name+Hosting to be done. The costing would be approx USD 100 / Rs.5,500 per year.
2) Create your website with necessary steps so that traffic is generated. You can try paid methods to generate initial traffic
3) Consider various ways to see how you can earn money through your website. There are many people who generate extra income of USD 1000 / Rs.55,000 on an average per month. This is not the least, it is a minimum amount which people are earning.

Have you enjoyed this post? Please provide your valuable suggestions to improve future posts. If you are excited, share the link in Twitter/Face book (copy URL from your current browser and publish in your Facebook/twitter)

Share this:

Search your favorite article

Subscribe and get in your mail box

Person Behind this blog

Suresh KP i.e. me, have written 1000+ articles on this website. I love doing analysis on various Best Investment Plans like mutual funds, Stocks, IPO’s, Bonds, Insurance products. You can share on FB or Twitter, if you love this blog. This is the BIGGEST gift which you would be giving to me and to this blog.

Top Posts Pages

Categories of Articles

Recent Comments





Tags : , , , , , , , , ,

Best Investment Options – Making money by creating a website #business #finance

#small scale business

#

Making money by creating a website/blog

Overview
Creating a website for selling products and services is one of the best ways of making money. However to create a website or blog, it may take lot of time and energy. On top of this, we need to spend lot of money.

There are various ways for which a website is created
Website for selling products and services
Website for sharing the hobbies and providing services
Website for company information / product information purpose

How to create a website
There are two parts here.
1) Registration of a domain name (the name of the website which people would type the address and browse) and
2) Hosting the website (running the website from a server).
3) Designing the website

Domain Name registration. There are lots of websites which offer domain name registrations which start from USD 2 / Rs.100 per year

Hosting. Website can be done with any of the hosting companies. The charges would be USD 100 / Rs.5,500 per annum. There are various players like Godaddy.com, Rock.in etc.

Designing the website: There are various design templates which available with low costs. There are free templates available which has certain limitations.
Content of the website: This is a major step where the success of the website depends. Selection of popular topics would enable users interest.

Creating traffic for the website
Another key step in this process is to create traffic for the website. Unless there is enough traffic generated, there is no way we can earn money. There are various ways on how you can generate traffic for your website.
1) Build your website SOE based (Search engine optimization based). The major traffic generated through search engines like Google, yahoo are the true traffic which comes to your website. Hence SOE optimized website would generate more traffic
2) Creating traffic by advertising on various websites which is termed as Paid traffic
3) Ask someone to work as affiliate marketing for your website. They would generate the traffic for your website

7 ways to make money out of your website
1) Pay per click (PPC) You can sign-up for Google ad sense to earn the revenue. Once you sign-up, Google will provide necessary code which you need to put in on your website and the Google Ads appear in your site. Any of your user / subscribe who visits your website, clicks on the Google Ads, then you would get paid.
2) Cost per impression (CPI) The Ad banner can be charged based on 1000 impressions. Based on the CPI the ad banner charges would apply starting from USD 0.25 to USD 50.
3) Direct banner advertisement: One can directly go to the customers and do the banner advertisement. However, this method takes time and manpower effort.
4) One can make money through website by e-books selling. Good e-books selection is the key to be success.
5) Affiliate marketing. One can work as affiliate marketing and make money. Recommend the third party products and make the money
6) Text links. One can money by adding text links to the website content and when one clicks on these text links, these would direct to the customer website
7) Writing articles/review. Articles can be written for a specific product / customer and in turn customer pays the money

Conclusion:
1) To create website, you need to have domain name+Hosting to be done. The costing would be approx USD 100 / Rs.5,500 per year.
2) Create your website with necessary steps so that traffic is generated. You can try paid methods to generate initial traffic
3) Consider various ways to see how you can earn money through your website. There are many people who generate extra income of USD 1000 / Rs.55,000 on an average per month. This is not the least, it is a minimum amount which people are earning.

Have you enjoyed this post? Please provide your valuable suggestions to improve future posts. If you are excited, share the link in Twitter/Face book (copy URL from your current browser and publish in your Facebook/twitter)

Share this:

Search your favorite article

Subscribe and get in your mail box

Person Behind this blog

Suresh KP i.e. me, have written 1000+ articles on this website. I love doing analysis on various Best Investment Plans like mutual funds, Stocks, IPO’s, Bonds, Insurance products. You can share on FB or Twitter, if you love this blog. This is the BIGGEST gift which you would be giving to me and to this blog.

Top Posts Pages

Categories of Articles

Recent Comments





Tags : , , , , , , , , ,

Best Investment Options – Making money by creating a website #government #small #business #loans

#small scale business

#

Making money by creating a website/blog

Overview
Creating a website for selling products and services is one of the best ways of making money. However to create a website or blog, it may take lot of time and energy. On top of this, we need to spend lot of money.

There are various ways for which a website is created
Website for selling products and services
Website for sharing the hobbies and providing services
Website for company information / product information purpose

How to create a website
There are two parts here.
1) Registration of a domain name (the name of the website which people would type the address and browse) and
2) Hosting the website (running the website from a server).
3) Designing the website

Domain Name registration. There are lots of websites which offer domain name registrations which start from USD 2 / Rs.100 per year

Hosting. Website can be done with any of the hosting companies. The charges would be USD 100 / Rs.5,500 per annum. There are various players like Godaddy.com, Rock.in etc.

Designing the website: There are various design templates which available with low costs. There are free templates available which has certain limitations.
Content of the website: This is a major step where the success of the website depends. Selection of popular topics would enable users interest.

Creating traffic for the website
Another key step in this process is to create traffic for the website. Unless there is enough traffic generated, there is no way we can earn money. There are various ways on how you can generate traffic for your website.
1) Build your website SOE based (Search engine optimization based). The major traffic generated through search engines like Google, yahoo are the true traffic which comes to your website. Hence SOE optimized website would generate more traffic
2) Creating traffic by advertising on various websites which is termed as Paid traffic
3) Ask someone to work as affiliate marketing for your website. They would generate the traffic for your website

7 ways to make money out of your website
1) Pay per click (PPC) You can sign-up for Google ad sense to earn the revenue. Once you sign-up, Google will provide necessary code which you need to put in on your website and the Google Ads appear in your site. Any of your user / subscribe who visits your website, clicks on the Google Ads, then you would get paid.
2) Cost per impression (CPI) The Ad banner can be charged based on 1000 impressions. Based on the CPI the ad banner charges would apply starting from USD 0.25 to USD 50.
3) Direct banner advertisement: One can directly go to the customers and do the banner advertisement. However, this method takes time and manpower effort.
4) One can make money through website by e-books selling. Good e-books selection is the key to be success.
5) Affiliate marketing. One can work as affiliate marketing and make money. Recommend the third party products and make the money
6) Text links. One can money by adding text links to the website content and when one clicks on these text links, these would direct to the customer website
7) Writing articles/review. Articles can be written for a specific product / customer and in turn customer pays the money

Conclusion:
1) To create website, you need to have domain name+Hosting to be done. The costing would be approx USD 100 / Rs.5,500 per year.
2) Create your website with necessary steps so that traffic is generated. You can try paid methods to generate initial traffic
3) Consider various ways to see how you can earn money through your website. There are many people who generate extra income of USD 1000 / Rs.55,000 on an average per month. This is not the least, it is a minimum amount which people are earning.

Have you enjoyed this post? Please provide your valuable suggestions to improve future posts. If you are excited, share the link in Twitter/Face book (copy URL from your current browser and publish in your Facebook/twitter)

Share this:

Search your favorite article

Subscribe and get in your mail box

Person Behind this blog

Suresh KP i.e. me, have written 1000+ articles on this website. I love doing analysis on various Best Investment Plans like mutual funds, Stocks, IPO’s, Bonds, Insurance products. You can share on FB or Twitter, if you love this blog. This is the BIGGEST gift which you would be giving to me and to this blog.

Top Posts Pages

Categories of Articles

Recent Comments





Tags : , , , , , , , , ,