Hi ,
It looks like you're using an ad blocker.



The revenue generated from the adverts on the site is a critical part of our funding - and it's because of these ads that I can offer the site for free. But using the site for free AND blocking the ads doesn't feel like a great thing to do, which is why this box is so large and inconvenient. Some sites will completely block your access, but I'm not doing that - I'm appealing to your good nature instead. Did you know that you can allow ads for specific sites, whilst still blocking them on others?

Thanks,
Ian Williams aka Fetch
or for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers
um
um
May 2020
11:37am, 20 May 2020
2,435 posts
  • Quote
  • Pin
um
Larkim - quick fix, can you just paste the email addresses into 'to' or 'bcc' (if you don't want recipients to see all the others).
I often format in excel or a dummy mail before copying into the bcc field.

In the meantime, will have a play with outlook (2016 not 365)
um
um
May 2020
11:42am, 20 May 2020
2,436 posts
  • Quote
  • Pin
um
Or ... (once the csv file is clean)
support.office.com

outlooktransfer.com
larkim
larkim
May 2020
11:54am, 20 May 2020
11,103 posts
  • Quote
  • Pin
larkim
Thanks um - the CSV import route via the client or via OWA only adds them in bulk, and doesn't seem to allow them to be added to a specific contact list in Outlook which is where we're getting stuck. The workaround for a single mail as you describe is do-able though, and that's going to be plan A.

It seems though that adding to contact lists can only be done "manually". In the outlook client I can see the Gmail labels as "categories", but selecting all from a specific category still doesn't have an option to "add to contact list" or something along those lines. Unless I'm missing something!!
um
um
May 2020
12:27pm, 20 May 2020
2,437 posts
  • Quote
  • Pin
um
Once it's in a mail to/cc or bcc field, can you then save it as a dist list / contact group?
larkim
larkim
May 2020
1:28pm, 20 May 2020
11,105 posts
  • Quote
  • Pin
larkim
Not obviously that I can see. But that might just be me!
GlennR
GlennR
May 2020
1:51pm, 20 May 2020
50,038 posts
  • Quote
  • Pin
GlennR
Have a look at this:

support.office.com

The instructions for creating a group from an email list are down the page a bit.

Hope it works - can't test because I'm running Outlook on a Mac.
um
um
May 2020
1:54pm, 20 May 2020
2,438 posts
  • Quote
  • Pin
um
from Glenners link

Create a contact group from an Excel list

If you have a lot of business or personal contacts that you keep in an Excel spreadsheet, you can import them straight into Outlook.

Then you can create a contact group (formerly called a “distribution list”) using the imported contact information.

Unfortunately, you can't import a list of contacts from Excel directly into a distribution list, but you can import the contacts into your Contacts folder, then use the instructions above to create a distribution list from those contacts.

For information about importing contacts from Excel, see support.office.com
larkim
larkim
May 2020
2:25pm, 20 May 2020
11,108 posts
  • Quote
  • Pin
larkim
But doesn't that effectively say what I've been saying - you can import into Outlook fine, but selecting a sub-set of your contacts by a "label" from Google isn't possible on a bulk basis.

At the point of "add members" you can select one by one, sort by name, sort by email address, but if those newly imported contacts aren't filterable on that basis there is no obvious way to find all 500 out of the 3500 existing contacts.

I might have to cludge a work around by adding naming prefixes or similar to the csv file.
Badger
Badger
May 2020
3:13pm, 20 May 2020
12,269 posts
  • Quote
  • Pin
Badger
It does, but it also (in the link, not the copied bit in um’s post) you might be able to generate the list from an email where you’ve copied and pasted the addresses into the to: field if you’ve also added them as contacts.
larkim
larkim
May 2020
3:23pm, 20 May 2020
11,109 posts
  • Quote
  • Pin
larkim
How do you create a group from a list in a to: field? I keep trying but getting nowhere?

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...
  • Show full description...

Related Threads

  • excel
  • support
  • tech
  • work








Back To Top

Tag A User

To tag a user, start typing their name here:
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 114,038 Fetchies!
Already a Fetchie? Sign in here