lobiengine.blogg.se - Extract emails from gmail account

#Extract emails from gmail account for mac
#Extract emails from gmail account mac

In Mac Mail in the Messages window, which should now display all your emails for you Gmail Label), select all the emails in the list.

This will show you a list of folders and should show the Label you created in Gmail as a folder.

In Mac Mail, click the dropdown arrow next to your mailbox.

You should see the Name of your Gmail account you set up earlier with a dropdown arrow on the left. The IMAP folder will be toward the bottom of the column below "Reminders", "RSS", "On My Mac" etc. If not go to the top toolbar, select View>Show Mailboxes or press Command+Shift+M. There should be a column on the left side of the window with all your Mailboxes. You should be able to do this by selecting one contact, pressing Command+a and pressing the delete key.

In Address Book, delete all your contacts.

Delete Address Book contacts at your own risk. I don't use Address Book other than for exporting Gmail emails so I can't give good advice on this. I believe you can do this with File>Export>Address Book Archive. If you use Address Book for your contacts you'll need to back up your contacts because you need to delete all contacts in Address Book.

Restart Mac Mail so the new Gmail Label syncs.

In Gmail, go to Settings>Labels and tick off the box for the new Label you created that says "Show in IMAP.".

In Gmail, label all the emails you want per Label above.

In Gmail, create a Label for the emails for which you want to extract email addresses.

Make sure the incoming mail server is "" You can find this under the toolbar>Mail>Preferences>Accounts.

Set up your Gmail account in Mac Mail.

This may work similarly for other IMAP Email programs like Thunderbird, but I can't vouch for that. Not sure if it works for other vers or not. This works with Mac Mail 4.6 and Address Book 5.0.3.

#Extract emails from gmail account for mac

I figured out a way to do this for Mac users using Mac Mail and address book without needing to download extra software. Position your cursor on within the word "getEmails" in the first lineĬlick the play triangle button above in the menu barĬlick the play button again if it didn't already runĬheck your original spreadsheet and it will have the emails. SpreadsheetApp.getActiveSheet().getRange(1, 1, aUnique.length, 1) After that, the e-mail addresses will be added.

If you paste the following script in a new Google Spreadsheet (Tools, Script editor, press the bug icon to authenticate the script), then new sheets will be automatically created based on the number of labels present. This is where the power of Google Apps Script kicks in.