The following articles were included in our Exchange Messaging Outlook (EMO) newsletter published on September 7, 2017.
EMO is a weekly publication. To receive your own copy of EMO by email, subscribe here.
Support Exchange Messaging Outlook Sponsors
Increase Your Productivity!
ReliefJet Essentials for Outlook is a set of more than 160 tools for performing a wide range of tasks in Outlook: processing email messages, contacts, appointments, meetings, tasks and other Outlook items.
Today's Highlights:
Sharing a Contact Group
A user contacted me with a problem:
A coworker has a Contact group that I want to import into my Outlook. He shared his Contacts with me but the group doesn’t work.
Your coworker can send the group to you are as an Outlook item, using Forward as Outlook Contact, and it should work, but you may not be able to update it because the contacts don’t exist in your Contacts folder; members may be deleted from the group if you try to update it.
When you receive it, drag it from the message to the contact folder icon in the folder pane and drop or open it, then use File, Move to Folder command to copy it to your contacts folder.
If you aren't using Exchange server, it needs to be sent in an RTF formatted message, to prevent the Contact group from being converted to an HTML message.
Copy tables using a macro
A user gets reports sent in email and want the table data copied to Excel. While it’s not hard to select the table, copy and paste, he was looking to automate the process.
What I'm looking for is to grab the table data and dump it in the same work book and sheet as new emails come in.
Yes, you can do this using a macro to select and copy the table (or specific rows in the table) and paste them into Excel. The only issue is when the table contains merged or blank cells as this can throw the values into the wrong cells.
Get the macro to run on selected items or to use in a run a script rule from Copy data from Outlook email tables to Excel
Appointment from mail using Outlook on the web
Another user had a question about Outlook on the web:
In Outlook on my desktop, I can drag the message to the Calendar to create a new appointment that contains the text of the email. After I create a new appointment, I can select "Insert Item" to insert the contents of a mail message. I haven't found a way to do the same thing using Outlook on the web. Is there a way to do it?
No, unfortunately, there isn’t a way to do this in Outlook on the web. You’ll need to select the message body, copy and paste.
If you're sending a meeting request, you can do that from the message in Outlook on the web . Expand the Reply button, choose Reply by meeting to create a meeting to all recipients. If you need to add (or remove) recipients, choose Edit, rather than Send, to make the changes before sending.
New & Updated Exchange KB Articles
Cumulative Update 23 for Microsoft Dynamics NAV 2016 ...
https://support.microsoft.com/kb/4040571
Modern Authentication configuration requirements for ...
https://support.microsoft.com/kb/4041439
Outlook users cannot access public folders in Exchange Server 2013 or Exchange Server 2016
https://support.microsoft.com/kb/2788136
Rename your personal account
https://support.microsoft.com/kb/11545
Resources in Exchange don't respond to meeting requests
https://support.microsoft.com/kb/2005631
New & Updated Office 365 KB Articles
August 22, 2017, update for Office 2016 (KB4011093)
https://support.microsoft.com/kb/4011093
Delegate can't send "on behalf of" after migration to Office 365 dedicated/ITAR (vNext)
https://support.microsoft.com/kb/4039613
Modern Authentication configuration requirements for transition from Office 365 dedicated/ITAR to vNext
https://support.microsoft.com/kb/4041439
Outlook continually prompts for your password when you try to connect to Office 365
https://support.microsoft.com/kb/2984912
New & Updated Outlook KB Articles
Outlook continually prompts for your password when you try to connect to Office 365
https://support.microsoft.com/kb/2984912
September 5, 2017, update for Office 2016 (KB3191923)
https://support.microsoft.com/kb/3191923
September 5, 2017, update for Word 2016 (KB4011039)
https://support.microsoft.com/kb/4011039/
Other Resources
Copy data from Outlook email tables to Excel
User request: I want to grab the table data and dump it in the same work book and sheet as new emails come in. Solution: Using the macros on this page, when table data is received in an email, the table can be copied to an Excel worksheet.
Create a No-Mail account in Outlook 2016
Create a "no mail" in Outlook 2016 to use it as a PIM (personal information manager) for your calendar and contacts.