Steps on Migrating Emails from Gmail Account to M365 Account Using Apple Mail

Video Guide on Migrate Emails Using Apple Mail

Legend: 

Gmail account = Current @connet.hku.hk account on Google 

M365 account = New @connect.hku.hk account on Microsoft 

Step 1: Export emails from Gmail account to .mbox file  

Step 2 : Setup M365 account to connect to Apple Mail 

Step 3:  Import .mbox file to Apple Mail (local on your Mac) 

Step 4 (Optional):  Access the migrated emails from other networked PCs other than your Mac 

Toubleshooting: Wrong Date issue after imported Gmail file to Apple Mail

Export emails from Gmail account to .mbox file

Logout from all Google accounts or open an Incognito/InPrivate browser before doing the following steps. 
  1. Go to https://takeout.google.com/settings/takeout and login using uid@connect.hku.hk and your HKU Portal PIN

    **If you see the error: “Transfer Your Content is only available to authorised G Suite for Education Accounts. Please contact your administrator”, this may due to the reason that you are using the same browser to login to another Gmail account.  Please make sure you logout from all Google accounts and try to above step again.**

  2. Click the Deselect all button under Products.
  3. Click the Deselect all button under Products

    Click the Deselect all button under Products

  4. Select Mail and Next step button.
  5. Select Mail and Next step button

    Select Mail and Next step button

  6. Click Create export.
  7. Click Create export

    Click Create export

  8. You will receive the following email after export is completed.   Click the Download your files button (it is a .zip file and includes the exported email file (.mbox file)) and save it to a preferred location on your Mac.
  9. Click the Download your files button

Setup M365 account to connect to Apple Mail

  1. Open the Mail App.
  2. Select Mail > Add Account…

    Select Mail > Add Account...

     

  3. Click Microsoft Exchange.

    Click Microsoft Exchange

  4. Enter your Name and Email Address (UID@connect.hku.hk), click Sign In.

    Enter your Name and Email Address (UID@connect.hku.hk), click Sign In

  5. Click Sign In.

    Click Sign In

  6. Enter your email address (UID@connect.hku.hk) and HKU Portal PIN, click Sign in.

    6.	Enter your email address (UID@connect.hku.hk) and HKU Portal PIN, click Sign in

  7. Click Accept

    Click Accept

Import .mbox file to Apple Mail (local)

  1. Select File > Import Mailboxes….

    Select File > Import Mailboxes….

  2. Select Files in mbox Format and click Continue.

    Select Files in mbox Format and click Continue

  3. Select the file downloaded from Google (.mbox file) (Step 1-5 above refers) and click Choose.

    Select the file downloaded from Google (.mbox file) (Step 1-5 above refers) and click Choose

  4. The emails on your Gmail account will be imported under the Import folder under On My Mac.

    The emails on your Gmail account will be imported under the Import folder under On My Mac

 

(Optional): Access the migrated emails from other networked PCs other than your Mac

After imported the emails to Apple Mail, drag the folder under the Import folder under On My Mac to your M365 account (i.e. Exchange).
  1. Create new folder on M365 called Import from Gmail

    1. Create new folder on M365 called “Import from Gmail”

  2. Browse to the local folder with the email just imported. Select all emails (Press CMD+A)
  3. Browse to the local folder with the email just imported. Select all emails (Press CMD+A)
  4. Right click the selected emails -> Move to -> Exchange -> “Import from Gmail” folder on M365 account
  5. Right click the selected emails -> Move to -> Exchange -> “Import from Gmail” folder on M365 account
  6. Wait and monitor the copy progress on the status bar
  7. Wait and monitor the copy progress on the status bar
  8. As the task will take a long time, please connect your Mac to the power source. You may sleep when idle, it would prevent the Mail app keep moving the email when you are not using the Mac. The following power setting can prevent your Mac sleeping.
  9. As the task will take a long time, please connect your Mac to the power source. You may sleep when idle, it would prevent the Mail app keep moving the email when you are not using the Mac. The following power setting can prevent your Mac sleeping.

    energy saver  OR battery

    As the task will take a long time, please connect your Mac to the power source. You may sleep when idle, it would prevent the Mail app keep moving the email when you are not using the Mac. The following power setting can prevent your Mac sleeping.

  10. After all old emails have been moved from Gmail to M365 mailbox. You may close the Mail app.
  11. You may find the old emails in the “Import from Gmail” folder. You can also use the search function to find email with keywords.
  12. Advise to keep the original zip file downloaded from Google Takeout on your computer or OneDrive.

Troubleshooting:

In case the moving progress stopped. You may Quit and restart the Mail app, “Moving Messages” progress will resume again.

In case you look for any missing item, you can re-import again.

Toubleshooting: Wrong Date issue after imported Gmail file to Apple Mail

After moving old emails to M365 “Import from Gmail” folder, you may find some emails which Sent by you have wrong date. They may change to the date of your migration instead of the original Sent date of the emails.

Please follow these steps moving those emails to Sent folder to make them display the original Sent dates.

  1. In this example, the account owner name is Departmental Account, the mail dates are incorrect.

    In this example, the account owner name is Departmental Account, the mail dates are incorrect.

  2. In Mail app menu > View > Use Column Layout

    In Mail app menu > View > Use Column Layout

  3. Sort mails by From

    Sort mails by From

  4. Find the mails sent by your name (in this case Departmental Account) and select the mails

    Find the mails sent by your name (in this case Departmental Account) and select the mails

  5. Right click and move to Sent folder of your M365 account

    Right click and move to Sent folder of your M365 account

  6. Browser to Sent folder, the mail date should change back to original Sent dates.

    Browser to Sent folder, the mail date should change back to original Sent dates.

  7. (Optional) You may change back to default, View > Use Column Layout.

    (Optional) You may change back to default, View > Use Column Layout

11
28