create a contact list in outlook 2016 for Mac that will be saved in 365 using excel list of names and email addresses

how to create a contact list in outlook 2016 for Mac that will be saved in 365 using excel list of names and email addresses

I use outlook on my Macs, my iPhone and windows 10 pc's, so I want to save a list of 70 people that I have in an excel spreadsheet.

I can create a contact list on Mac individually, but it is saved in my computer on Mac.

I can create using excel list in Outlook 2016 windows 10, but  it does not show on Mac or iPhone.

Thanks Terry
terrybuck9Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Karen FalandaysTraining SpecialistCommented:
Hi Terry, not sure I understand. Perhaps you just need to save the Excel spreadsheet up to OneDrive so you can access it from any device. Tell us more
kfalandays
terrybuck9Author Commented:
Hi
I have a list of names and email addresses in excel.
Currently I open up the sheet and copy and paste email addresses into an email.
I used Outlook on my windows 10 pc to create a contact group and copied and pasted them in after selecting add members from outlook contacts.
That works fine on that pc and web mail in office 365.

I then open up my Mac with Outlook and the contact is not there.
The create contact list on Mac Outlook does not have the add members from outlook contacts.

There must be another way to get my list into 365 so it comes up everywhere?

Thanks Terry
Karen FalandaysTraining SpecialistCommented:
Tell me more about your Mac with Outlook. Are you able to view your emails and calendar items the same as on your PC? Is it an exchange account or a POP or IMAP?
Additionally, instead of copy/paste you can use the import Wizard to import a excel/CSV file into contacts, but you may need to "map" the fields. Choose File>Open and Export on your PC and follow the wizard. Let me know that does the trick
kfalandays
Maximize Customer Retention with Superior Service

The IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more to help build customer satisfaction and retention.

terrybuck9Author Commented:
Hi

As I said its office 365.

I do not want to load all the contacts individually, I just want them as a single contacts list as I have done on PC.

thanks Terry
Karen FalandaysTraining SpecialistCommented:
If you follow those steps to import, the contacts will be loaded in bulk. Are you saying you just want them in on Contact Group/Distribution list?

Try it and let me know if you have questions.
terrybuck9Author Commented:
Yes I am. I don’t want them loaded in bulk.

Thanks Terry
Karen FalandaysTraining SpecialistCommented:
You will not be able to copy or view a contact group whose members are not in your GAL or contact list. Somehow, you will have to allow Outlook to add them to your contacts as well
terrybuck9Author Commented:
Hi.
The thing is I have done exactly that as I said above:
I used Outlook on my windows 10 pc to create a contact group and copied and pasted them in to bottom box after selecting add members from outlook contacts.
That works fine on that pc and web mail in office 365.

My problem is that I want to do the same on my Mac's and iPhone.

Thanks for trying
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.