Categories
Interior

How to import gmail contacts into outlook 2007

Due to spamming concerns, bulk importing from Outlook is currently available only upon request. Please contact our support team to unlock this feature.

Direct Mail can import the following data from your Microsoft Outlook email (to import Outlook contacts, click here): from address, to addresses, cc addresses, bcc addresses, and addresses found in the message body. Here’s how:

  1. Choose Addresses > Import From > Microsoft Outlook Email from the menu bar at the top of your screen. If Outlook is not already open, it will be opened in the background.
  2. Direct Mail will display a list of your Outlook mail folders. Select the mail folders you want to import from
  3. At the bottom of the window, check the addresses you want to import
  4. Click Import

Outlook may be unresponsive while the import is taking place.

Contact Us

You can chat live with Direct Mail Customer Service, Monday through Friday, 7 AM to 3 PM Pacific Time or send us an email.

Twitter Updates

Why Wait? Direct Mail is free to try!

See why Direct Mail is the #1 rated email marketing app for the Mac

  • Features
  • Support
  • Blog
  • Pricing
  • API
  • Terms
  • Privacy
  • Security
  • Press Kit
  • Report Abuse

Subscribe to our Newsletter

Sign up for our newsletter to receive training and tips on mastering Direct Mail.

e3 Software is not affiliated with Apple Inc., which is the sole owner of the “Mac” trademark.

As your email accounts and email applications change, it seems there is always a different way to get your contacts organized. Previously we covered how to Import Contacts Into Thunderbird, but today we will look at how to import important contacts from Gmail into Outlook 2007.

Importing Gmail Contacts

Exporting your Gmail contact information is basically handled the same for you to use the file to import into any email application. Just log into your account, select Contacts and then individual or All contact then Export to a location on your hard drive.

Next choose Outlook’s CSV format to allow the file to easily transfer into the application.

How to import gmail contacts into outlook 2007

The next thing we need to do is import that contacts file into Outlook 2007. Open Outlook and click File Import and Export.

How to import gmail contacts into outlook 2007

When the Import and Export Wizard opens select “Import from another program or file” then hit Next.

How to import gmail contacts into outlook 2007

Next select “Comma Separated Values (DOS)” and click Next.

How to import gmail contacts into outlook 2007

Browse for the Excel CSV file and choose options about duplicate entries and continue by clicking Next.

How to import gmail contacts into outlook 2007

Here you will want to select the appropriate folder or location you want to keep the information hit Next.

How to import gmail contacts into outlook 2007

The next screen basically verifies what we just did an also offers the option to change the destination or Map Custom Fields (which is a whole other topic we can get into at another time) hit Finish and your done.

How to import gmail contacts into outlook 2007

Related

  • How to Edit Groups You’ve Joined on Facebook
  • How to Make Groups on AOL Webmail
  • How to Create an Enterprise Distribution List in Google Apps
  • How to Make a Facebook Group Searchable
  • How to Create a Folder in a Comcast Webmail Address Book

Gmail’s contact manager cannot import distribution groups from Outlook contacts, but you can set up the groups within Gmail to function the same way they do in Outlook. Or you could set up a different email distribution list that you can use from any email client or software and still make sure everyone stays in the communication loop.

Export Contacts

In Outlook, you can use the Advanced section of the Options menu found under the File tab to export your contacts into a format that will work for Gmail. Choose to export your contacts to a file — which will be a comma separated value or CSV file — and select the information to export. When you’re done, you will have a file containing all of your Outlook contacts which you can import into Gmail — except for the group lists.

Import Contacts

Log in to Gmail and click the “Gmail” link under the Google logo. Choose “Contacts” to see your Gmail contacts. From there you can select “More” and then “Import” to import your Outlook contacts. You’ll need to manually add the group lists, however. But you’ll want all of the contacts that the group lists refer to in your Gmail contacts before you create your new group lists.

Gmail Groups

Within Gmail’s contact manager you can create groups easily. Click the “New Contact” button and then click on the icon with three people in it to see the groups you have. Click “Create New” at the bottom of the list and type in a name for the group email list. Copy or type the email addresses over from Outlook to your new Gmail group.

Distribution Lists

You can use a service like Google Groups to create a distribution list that will send out group emails regardless of what email client people are using. From the Google Groups website (see link in Resources) you can create a new group and custom email address. Add members to the group and then, using that one email address, everyone can communicate with each other without having the same group lists. It also allows for automatic replies to everyone in the group, so no one gets left out of the conversation.

Step 1: Export Gmail contacts

From your Gmail account, choose Gmail > Contacts

Select More > Export.

Choose the contact group you want to export.

Choose the export format Outlook CSV (for importing into Outlook or another application).

When prompted, choose Save As, and browse to a location to save the file.

Note: Google does not export the photos of your contacts.

How to import gmail contacts into outlook 2007

Step 2: Import Gmail contacts to Outlook 2013 or 2016

Choose File > Open & Export > Import/Export.

Choose Import from another program or file > Next.

Choose Comma Separated Values > Next.

In the Import a File box, browse to choose the .csv file you saved your Gmail contacts to.

Choose how you want Outlook to handle duplicate contacts > Next .

In the Select a destination folder box, scroll to the top if needed and select the Contacts folder > Next.

Outlook imports your contacts to Outlook.

How to import gmail contacts into outlook 2007

How to import gmail contacts into outlook 2007

Step 3: View your contacts in Outlook

In Outlook, select Address Book, choose the name of your mailbox, and choose Contacts.

How to import gmail contacts into outlook 2007

You’ll see your list of contacts in the Address Book.

How to import gmail contacts into outlook 2007

Fixing issues with importing Gmail contacts

You get an error message: If you try to import more than 2000 contacts at a time, you’ll see an error message. Use a program such as Excel to open the CSV file, separate your list of contacts into smaller .csv files, and then import each newly created CSV file.

No contacts appear in Outlook: If you complete the import process but no contacts appear in Outlook, do the following:

Locate the csv file you exported from Google. The default file name is contacts.csv.

Use Excel to open the CSV file you exported from Google.

Check whether there is any information in the CSV file. If there isn’t any information in the CSV file, the export from Google didn’t work. In that case:

Delete the contacts.csv file.

Export your contacts from Google again. Be sure to choose to export All contacts, or the right group of contacts.

How to import gmail contacts into outlook 2007

After you export your contacts, use Excel to open the CSV file and check that there’s data. When you close the file, Excel will prompt you a few times with “are you sure you want to save it in CSV format?” Always choose Yes. If you choose No, the file will get messed up and you’ll need to start over with a new contacts.csv file.

Repeat the steps to import your contacts.csv file to Outlook.

Contacts are missing info: After you import your contacts, if you open Outlook and see that not all the info was imported, open the CSV file with Excel to see if the information was there.

You can edit the CSV file using Excel to add names and other missing information.

Outlook requires the column headings in the first row so don’t replace them with something else.

When you save the CSV file, Excel will prompt you a few times with “are you sure you want to save it in CSV format?” Always choose Yes. If you choose No, the file will get messed up and you’ll need to start over again by exporting the list from Gmail.

  • Created July 7, 2016
  • Author Vodien
  • Category Email Hosting

When transferring to a different hosting provider/server or switching from IMAP to POP and vice versa, you need to manually back up all your email files to make sure you don’t lose anything important.

Learn how you can Export and Import your email files in Outlook 2007 with this guide.

Export Emails

Back up all your email files with the Outlook Export feature using these steps:

  1. Open Outlook and click File from the top menu.
  2. Select Import and Export from the drop-down menu.
  3. In the Import and Export Wizard , s elect Export to a file and click Next.
  4. Click Outlook Data File (.pst), then click Next.
  5. Select the name of the email account to Export and ensure that Include subfolders option is ticked, then click Next.
  6. Click Browse to select where the Outlook Data File (.pst) will be saved, then click OK to proceed.
  7. Under Options, specify what to do when exporting items that already exist in the destination folder, then click Finish.

Import Emails

Once you’ve set up your email account using your new server settings, you can easily restore all your emails with the Outlook Import feature using these steps:

  1. Open Outlook and click File from the top menu.
  2. Select Import and Export from the drop-down menu.
  3. In the Import and Export Wizard , select Import from another program or file and click Next .
  4. Click Outlook Data File (.pst), then click Next.
  5. Click Browse to select the Outlook Data File (.pst) that you want to Import, then click OK to proceed.
  6. Under Options, specify what to do when importing duplicate files, then click Next.
  7. On the next window, select the folders that you want to Import.
    Note: To import everything in the .pst file, select the top of the hierarchy. Make sure to choose Personal Folders , Outlook Data File or your email address; which are usually pre-selected. Include subfolders is also ticked by default.
  8. On the same window, select Import items into the current folder, or select Import items into the same folder in to specify a different destination folder/mailbox, e.g. your Office 365 mailbox.
  9. Click Finish to begin the importing process.

Please do not hesitate to contact our 24/7 Singapore or Australia Support Team if you have further questions.

This guide will show you how to export your contacts from Gmail and import them into Microsoft Outlook – and help troubleshoot any issues that may arise during the process.

    Start by opening https://contacts.google.com in your browser. Select Export from the column on the left side of the page.

How to import gmail contacts into outlook 2007

Select your Contacts, then select Outlook CSV as the Export as format, and finally click the Export button.

How to import gmail contacts into outlook 2007

Now open up Outlook and select File

How to import gmail contacts into outlook 2007

Choose Open & Export from the column on the left side of the window and then Import/Export in the main panel.

How to import gmail contacts into outlook 2007

From the Choose an action to perform menu select Import from another program or file and then click the Next button.

How to import gmail contacts into outlook 2007

This time select Comma Separated Values and then click the Next button.

How to import gmail contacts into outlook 2007

Click the Browse… button next to the File to import: field.

How to import gmail contacts into outlook 2007

Navigate to the .csv file that you saved way back in step #2, select it and then click the Open button.

How to import gmail contacts into outlook 2007

Click the Next button.

How to import gmail contacts into outlook 2007

Choose Contacts (This computer) from the list of destinations, and then click the Next button.

How to import gmail contacts into outlook 2007

If you didn’t get an error, that’s great – jump down to step #15 below. If you did get a Translation Error stating that A file error has occurred in the Comma Separated Values translator while initializing a translator to build a field map – have no fear. Click OK to close the error message.

How to import gmail contacts into outlook 2007

Open up the .csv file you created/saved back in step #2 in Microsoft Excel (or Google Sheets if you don’t have Excel handy). As soon as it’s open, save it again but this time name the file as contacts2.csv or something other than whatever it was called when you downloaded it. When you save it with a new name and Excel asks if you want to keep using that format, make sure to click the Yes button.

Back in Outlook, click the Browse… button again and this time select the newly saved version of the .csv file.

How to import gmail contacts into outlook 2007

Once again choose Contacts (This computer only) and then Next

How to import gmail contacts into outlook 2007

This time you should continue without any errors. Make sure there’s a check in the Import box and then click the Finish button.

How to import gmail contacts into outlook 2007

Outlook will now import all of the Gmail contacts. This can take anywhere from a couple of seconds to a few minutes – it depends mostly on how many contacts you’re importing. Once the process has completed open up your Address Book and make sure they’ve all been imported.

How to import gmail contacts into outlook 2007

  • That’s it! You’re all done.
  • It just hangs forever.

    Comments

    I’m sorry this is happening Jeff. Let’s definitely see how we can resolve this for you. 🙂

    Are you seeing a processing page? Can you share a screenshot of what you are seeing? Unfortunately, I’m not seeing an error message on our end. Is it possible to try a different browser?

    I am having the same issue. Here is a screen shot from chrome. I have tried in Firefox and IE and get the same issue of it hanging indefinitely.

    Thanks for the screenshot Dante! It was super helpful.

    I have submitted the issue to our developers so they can investigate. I’ll keep the Community updated with any feedback they provide.

    Thank you to both of you for bringing this to our attention!

    How to import gmail contacts into outlook 2007

    Hi there, I have had the same problem every time I have tried to import my contacts, it just stays on the same screen shot shown by Dante. Looking forward to a solution

    Thank you all for letting us know the issue. Seems like it is working fine now, can you please try again and let us know if import contact from gmail works for you.

    Thank you for using Insightly,

    This is still not working.

    How to import gmail contacts into outlook 2007

    I am having the same issue. I can’t get the contacts to load.

    How to import gmail contacts into outlook 2007

    I just tried again and this time it said there are no contacts found in my google contact list

    I’m sorry this is happening.

    @Alex- I show you haven’t set up your Google Account, see the attached screenshot:

    How to import gmail contacts into outlook 2007

    @Kevin- We’re not able to see an error for your account; but I see you’re working with Jessica on our Support team to resolve this. 🙂

    I just ended up extracting my contact from gmail via csv and then uploading to insightly.

    Gmail contact import is not working.

    When I tried Insightly first time (over a year ago) – I got stuck in the same place.

    Decided to give it a try again this week.

    Gmail contacts import doesn’t work. It shows the message (like Dante’s screenshot). Even after waiting for 1 hour, no contacts are imported and the screen still shows the same “please wait. ” message.

    How to import gmail contacts into outlook 2007

    Hello Artur – Thank you for letting us know!

    This is a bug that we’re currently experiencing and working to resolve.

    I’ve let our engineers know that you’re experiencing this and we’ll send out updates as soon as we know more!

    Thank you for your patience!

    Has the problem been fixed yet?

    How to import gmail contacts into outlook 2007

    @Chris – We’re still investigating, we will update once we have any updates or resolution.

    Would it be fair to say that a fix for this problem isn’t likely to occur quickly – issue raised in this thread on Sept 10.

    I’ve just subscribed and for various reasons don’t want to import via csv – mainly issues with syncing back to google.

    If your not anticipating to have the problem fixed over the next week or so I will need to cancel subscription.

    How to import gmail contacts into outlook 2007

    @Chris – Thank you for checking in.

    We are still looking into this, and I don’t have any specific time frame as to when we can expect a resolution.

    In the meantime, as a work-around, we suggest you manually export your Google contacts, then manually import them into Insightly. It’s very easy and this way you have the most control over your data.

    To export your Google Contacts, select all your contacts (or a sub-group), then select the Export option from the MORE menu dropdown. Confirm the contact population and the file format type (Google CSV).

    Using that same file, you can import those records into Insightly.
    We have a number of helpful articles and a video about the import process. Our article Importing data into Insightly covers the basics, as does the Importing Data video at Insightly University.

    These sections for Import and Export have even more articles you can explore.

    Your patience is appreciated and as soon as we know anything further, the thread will be updated!

    You can use the same contacts in both Google Gmail and Outlook, without adding them manually to both locations.

    Import your contacts from Google Gmail to Outlook

    In the left column, click More.

    At the top left, click More.

    Under Which contacts do you want to export, click a contact group or All Contacts).

    Under Which export format, click Outlook CSV (for importing into Outlook or another application).

    When prompted to download the export file, click Save.

    Choose a location on your computer to temporarily save the file. The default file name is contacts.csv.

    Note: You can delete this file after your contacts are imported into Outlook.

    Click the File tab.

    Click Import from another program or file, and then click Next.

    Click Comma Separated Values (DOS), and then click Next.

    In the Import a File box, browse to find the file you downloaded in step 9, and then double-click the file.

    Click one of the following:

    Replace duplicates with items imported

    Allow duplicates to be created

    Do not import duplicate items

    In the folder list, click the contacts folder where you want the imported contact information to go, and then click Next.

    To add or remove fields to determine the way the contact information is saved in the new imported file, click Map Custom Fields.

    Note: The Map Custom Fields button in the Import a File dialog box might not be available when you try to import data from another program or file. In the The following actions will be performed box, select the Import check box, and then the Map Custom Fields button is available.

    Additional help on mapping custom fields

    In the From box, drag the field that you want to convert onto the Outlook field that is listed in the To box.

    Note: The Name field doesn’t appear in the To box because Outlook reserves the first row of a named range for field names. If the range that you import does not contain field names, the first row of data will be interpreted as field names and will not be imported as data. To make sure that all of the data in the named range is imported, use the first row for field names.

    To see additional records in the From box, click Previous or Next.

    To remove all mapping, click Clear Map.

    To reset the original mapping, click Default Map.

    To display additional fields in the To box, click the plus sign (+) next to the field. For example, to display the Business Street and Business City fields, click the plus sign ( +) next to Business Address.

    Export your contacts from Outlook to Google Gmail

    Before you export contacts from Outlook, it is helpful to understand the difference between the Outlook Address Book and Outlook Contacts. Both are part of Outlook. However, the Address Book is a compilation of the different address lists that you might store in Outlook, such as LDAP Internet directories, the global address list (GAL), or other third-party address books. Contacts is only one of the address lists included in an Address Book. Only contacts can be exported directly from Outlook to Google Gmail.

    Click the File tab.

    How to import gmail contacts into outlook 2007

    Under Export, click Export.

    In the Import and Export Wizard, click Export to a file, and then click Next.

    Click Comma Separated Value (DOS), and then click Next.

    In the folder list, click the contacts folder you want to export, and then click Next.

    Choose a location on your computer to temporarily save the file.

    Note: You can delete this file after your contacts are imported into Google Gmail.

    Type a name for the exported file, and then click Next.

    To add or remove fields to determine the way the contact information is saved in the new imported file, click Map Custom Fields.

    Note: The Map Custom Fields button in the Export to a File dialog box might not be available when you try to import data from another program or file. In the The following actions will be performed box, select the Export check box, and then the Map Custom Fields button is available.

    Additional help on mapping custom fields

    In the From box, drag the field that you want to convert onto the Outlook field that is listed in the To box.

    To see additional records in the From box, click Previous or Next.

    To remove all mapping, click Clear Map.

    To reset the original mapping, click Default Map.

    To display additional fields in the To box, click the plus sign (+) next to the field. For example, to display the Business Street and Business City fields, click the plus sign ( +) next to Business Address.

    At the top left, click More.

    Under Import Contacts, click Browse.

    Select the file you exported in step 9, and then click Open.

    Everybody loves Gmail, but some people use a desktop client, especially in corporate environments where Outlook is king. Adding your Gmail account to Outlook 2007 couldn’t be easier.

    First we need to make sure your gmail account is set up to enable POP (Post Office Protocol). In Gmail just go to mail settings and choose the Forwarding and POP tab. Click on one of the options to enable POP.

    How to import gmail contacts into outlook 2007

    Update: Note the drop-down that says what to do when mail is accessed with POP3. Please do NOT change this to “Delete”.

    Now open up Outlook 2007 and go to Tools \ Account Settings…

    How to import gmail contacts into outlook 2007

    Under Account Settings choose the E-mail tab and click on New…

    How to import gmail contacts into outlook 2007

    Enter in all of your gmail account information **make sure there is no check next to Manually configure server…** You do not have to go through these extra steps. Just click on Next.

    How to import gmail contacts into outlook 2007

    After Outlook has successfully configured the e-mail server settings you can go ahead and click Finish.

    How to import gmail contacts into outlook 2007

    Go back to your inbox and hit send/receive and you are done!

    How to import gmail contacts into outlook 2007

    If this doesn’t work

    If you are having problems with the automatic setup, you’ll need to choose the “Manually Configure Server” option, and then fill in your details as follows:

    How to import gmail contacts into outlook 2007

    Here are the important settings:

    • Email Address: Your full gmail address
    • Incoming Mail Server: pop.gmail.com
    • Outgoing Mail Server: smtp.gmail.com (Note: If you have problems with sending email you may have to check with your internet provider, as they often require you to send email through their system.
    • User Name: Your full gmail email address

    Now you’ll need to click on the More Settings… button, and check the box on the Outgoing Server tab for “My outgoing server requires authentication”

    How to import gmail contacts into outlook 2007

    Now switch to the Advanced tab, and check the box that says “This server requires an encrypted connection”, then change the fields to match these values:

    • Incoming Server: 995
    • Check the box for “This server requires an encrypted connection”
    • Outgoing Server (SMTP): 587
    • Change the type of encrypted connection to Auto, or use TLS if you have problems.

    How to import gmail contacts into outlook 2007

    Close the dialogs and go through the rest of the wizard and everything should be working.