Creating A Group Email

[ukanonymous]

I need to create a group email with a .CSV file. I am currently using office 365 but to create an email group in there is terrible as you have to add manually each user. I have 1000 or so. I could create a bot to do this for me but is there another simple option at all? such as any free email service? The mail recipients must not be able to see others email addresses also for privacy.

[Buenchico]

>>>The mail recipients must not be able to see others email addresses also for privacy

That's easy enough. Just send the emails to yourself with the group entered into the BCC field.

Try googling this line for information about your main query:
"office 365" "distribution group" "csv"
(I've tried it myself, and found several likely-looking pages, but I'm not sure which one best meets your needs).

[VHG]

If you have the 1000 names in a computer file you should be able to import the names into the CSV somehow (via a spreadsheet for example).

How are the names and email addresses currently stored?

[ukanonymous]

I imported using the CSV but to create a group within 365 you have to search for the people and add them individually which is a major pain! 100% pain pain pain. So I was just thinking about alternatives

[Buenchico]

Lots of the Google search results (from the search string I've suggested above) say that it can be done directly by using Powershell but (because I know nothing about Powershell or running scripts within it) I've left it to you to find the set of instructions that you're most at ease with.