Posts

Showing posts from January, 2019

How to Do Email Mail Merges using Excel and Outlook

Image
This is probably a bit of an "oldie" but I have been asked about it a lot recently, so I figured it was worth documenting. 
Why would you use this? There's a few reasons why you might need to do an email mail merge.


You've got an email that you've got to send to a few people, perhaps it's an invoice or just a seasonal greeting. Whatever it is, you don't have a group to send it to and you don't feel like just pasting everyone's email address into the BCC field.
You need to reference specific pieces of data in your email -- data attached to an individual. For example, on an invoice reminder run, you might have a due date, an invoice number, an amount and a project code.  The Procedure
1. Create an Excel Spreadsheet with your people's details in it.  You should use the first line to have column headings like Name, Email and FirstName. 
You only really need name and email but if you want to refer to other things (eg: like the project number/job numbe…

Getting Teams and SharePoint Sites to Appear in the Outlook Lookup

Image
Office 365 Groups are No Longer Automatic Mail Groups Until recently, if you created an office 365 group (usually by creating a Teams or a SharePoint site), you would also be able to send that group mail directly via outlook. Unfortunately, with everyone having the ability to create teams and sites on demand -- and very few people following good naming standards, it's very easy to get your corporate address books cluttered.



Microsoft received a lot of feedback about this clutter and as a result, they disabled the functionality. Existing Office 365 groups are unaffected but if you create a new one, you'll find that you can't locate them in the typeahead when you want to send mail.

You can however, still have your cake and eat it too. You just have to use PowerShell.



Procedure Since this is an admin feature and I'm presuming that all admins should be on Multi-Factor authentication now, the instructions are for MFA.  If you're not using MFA, you might want to use dif…