Coronavirus Response

  • Home
  • A-Z List
  • About
    • About the NCC
    • Connectional Table
    • Staff
  • Calendar
    • Events
    • Google Calendar
    • Past Events
  • Churches
  • Contact
    • Find Us
  • Districts
    • District Office
    • Beacon
    • Capital
    • Corridor
    • Fairway
    • Gateway
    • Harbor
    • Heritage
    • Sound
  • Employment
  • Search

NC Conference

Healthy Congregations and Effective Leaders in Every Place Making Disciples of Jesus Christ for the Transformation of the World

  • Discipleship
    Developing Disciples
    • Christian Formation
      • Children
      • Church & Society
      • College
      • Differently Abled Persons
      • Educational Ministries
      • Older Adults
      • Status & Role of Women
      • Young Adults
      • Youth
    • Church Revitalization
      • Coaching
      • Disciple Making Way
      • Evangelism
      • Grants
      • MissionInsite
      • Real Discipleship Survey
      • Shift
      • Spiritual Life
    • From the Bishop
      • Bishop’s Bookshelf
      • Bishop’s Sermons
      • Church Transformation
      • Conflict Transformation
      • Connections
      • Discipleship & Learning Plan
    • Multicultural
      • Asian
      • Hispanic/Latino
      • Native American
      • Strengthening the Black Church
    • Stewardship
      • Apportionments
      • District Remittances
      • Financial Discipleship
      • Grants
      • Insurance
      • Mission & Service
      • Pension
      • Treasurer Training
  • Leadership
    Strengthening Leaders
    • Bishop’s Office
      • Appointment Book
      • Bishop’s Sermons
      • Church Transformation
      • Conflict Transformation
      • Connections
      • Discipleship & Learning Plan
    • Ministerial Relations
      • Board of Ordained Ministry
      • Called to Ministry?
      • Extension Ministries
    • Board of Laity
      • Certified Lay Minister
      • Lay Servant Ministries
      • United Methodist Men
      • United Methodist Women
      • United Methodist Youth
    • New Faith Comm.
      • Called to Plant?
      • New Room Society
      • Our Communities
    • Conference Offices
      • Center for Leadership Excellence
      • Christian Formation
      • Communications
      • Conference Secretary
      • Connectional Ministries
      • Information Technology
      • Multicultural Ministries
      • Outreach Ministry
      • Treasurer’s Office
  • Service
    Ministering To The World
    • Local Outreach
      • Church Construction
      • Church Loans
      • Restorative Justice and Mercy
      • Disciple Bible Outreach
      • NCC UMVIM
      • Seed Funds
      • Mission Projects
        • Health Ministry
    • Global Outreach
      • Imagine No Malaria
      • Love for Liberia
      • Missionaries
      • Project AGAPE
      • Sierra Leone: Mission of Hope
      • ZOE
    • Disaster Ministries
      • Donate to Storm Response
      • Hurricane Florence
      • MERCI
      • Response Plan
      • Response Team
      • UMCOR Kits
    • Giving
      • Advance/Rainbow Covenant
      • Apportionments
      • Give to Storm Response
      • Mission & Service
      • The Gary Wayne Locklear Mission Endowment
      • New Room Society
      • Special Sundays
    • Ministry Partners
      • Camps & Retreats
      • Partners In Ministry
      • Robeson Co. Church & CC
      • UMF
  • Resources
    Supporting Ministry
    • Conferences
      • Annual Conference 2019
      • Annual Conference 2020
      • Charge Conference 2020
      • General Conference
      • Pilgrimage
      • SEJ Conference 2016
    • Media Center
      • Catalog
      • Labyrinth
      • Ministry Tools
      • Online Resources
      • Weekly Newsletter
    • Online Resources
      • Archives & History
      • Church Lookup
      • Online Data Collection
      • Online Learning
      • Pastor Lookup
      • Podcasts (NCCUMC.FM)
      • Ramus: Web Hosting
      • Video (Vimeo)
    • Publications
      • Advent 2020
      • Appointment Book
      • Bible Study
      • Conference Directory
      • Conference Journal
      • Every Day Grace
      • Lenten Reflections
      • Mission & Service
    • From UMC.org
      • Agencies
      • Communications
      • Discipleship
      • Finance & Administration
      • Global Ministries
      • Graphics Library
      • Relief
      • Status & Role of Women
  • Information Technology
  • Report Issues
  • FAQ
  • Webinars
  • Heartbleed

How Do I Migrate an Outlook 2003 Distribution List to Google Contacts

Outlook contacts can be exported into .csv (comma separated variable) files and then imported into Google Contacts, but distribution lists are just groups of contacts. Unfortunately as of April 2011, there isn’t a way to export distribution lists as a group from Outlook, then import them into Google Contacts. Distribution lists have to exported and then imported individually.

It is easier to recreate distribution lists in Google Contacts from your existing contacts than to move each list. This assumes that all the necessary contacts are already in Google Contacts. Duplicates will be created if the procedure below is used to import distribution lists that contain contacts that are already in Google Contacts. This may still be useful if the distribution list has contacts that are not already in Google Contacts as the duplicates can easily be removed.

Export the distribution list as a text file

  1. Open Outlook, click on the distribution dist you want to export.
  2. Click on File/Save As. On the Save As window, select Text Only (*.txt) in the Save As Type drop down on the bottom.
  3. Name your file, for example list01.txt, and then save it to your desktop.

Open the saved Text file in Microsoft Excel

  1. Launch Excel, and Open the previously saved file. When opening the file, make sure the Files of Type should be All Files, or Text Files.
  2. When you select the list01.txt, you will be automatically redirected to the Text Import Wizard as seen below.
  3. image

  4. Please make sure you select the right Start import at row:. Since the default value of 1 is apparently not what you want with something like “Distribution List Name:” occupies at least 4 rows. So you can find the first row with an email address and put the row number in the Start import at row: number field.
  5. When you continue with “Next” clicking, you just review the screen and make sure everything is what you want, and click “Finish” in the last step.
  6. Your file will be opened in Excel.

Save the Excel file as .csv file

In Excel, click File/Save As and on the Save As window, make sure you change the Save as Type as .csv as seen in the window below.

image

Name your file, for example list01.csv and you are done with the exporting.

Import the Excel .csv file into Google Contacts

  1. After logging into your Google Apps account, click on the “more” link, and select “Contacts” from the drop down menu.
  2. Under “Please Select a CSV or vcard file to upload”, browse to your desktop and select the file you named previously.

     

     

     

     

     

     

     

     

     

  3. Check the “Also add these contacts to a new group” box and verify that “New group” is selected.
  4. After Clicking the “Import” button, fill in the dialog box with the name of your distribution list.
  5.  

     

     

     

     

  6. Click the “OK” button.
  7. Google Contacts will create a group with the name you entered and import the contacts.
  8. Under “My Contacts”, click on the group name you created. The imported contacts will be displayed.

IT documentation

  • DownDetector
  • Google Apps Help
  • Microsoft Office 2010 E-books
  • Microsoft Office 2013 & 2010 Training

NC Conference of The United Methodist Church · 700 Waterfield Ridge Place · Garner, NC 27529
Phone: 919.779.6115 · Toll-free: 800.849.4433 · Fax: 919.773.2308

Copyright © 2021 · Privacy Policy · Powered by WordPress · Site Admin

  • Español
  • 한국어