{"id":342,"date":"2015-11-12T12:58:29","date_gmt":"2015-11-12T12:58:29","guid":{"rendered":"https:\/\/www.sharepoint13.org\/?p=342"},"modified":"2015-11-12T13:15:57","modified_gmt":"2015-11-12T13:15:57","slug":"office365-contacts-send-selected-email","status":"publish","type":"post","link":"https:\/\/www.sharepoint13.org\/?p=342","title":{"rendered":"Office365 Contacts, send selected Email"},"content":{"rendered":"

Today I got a request from a Marketing department to solve a problem in Office365 contact list. They have this one list with 2-3 thousand contacts from multiple companies, and contacts are for marketing activities like Seminars, Conferences, MeetUps, and even Projects. The list is connected to MS Outlook. <\/p>\n

How can they send Emails to a smaller selection? with Info like: \u201cWelcome to\u2026\u201d
the Marketing employees have full control in the contact list, but no Offce365 admins and\/or Exchange admins access <\/p>\n

My \u201cNo-Code\u201d sollution is to use Categories in Outlook, combined with nice views in Outlook Client and SP list versioning. 
-> Pls forgive my totally blurish and low res pics, the combination of Screen Resolution and SnipEditor did the hickup. Just click the pics for full and understandable view.<\/em><\/p>\n

\"snip_20151112130649\"<\/a><\/p>\n

Mark your selection, click E-mail \u2013 voila\u2019 \"Smilefjes\"<\/p>\n

\"snip_20151112131033\"<\/a> 
Note in the picture that I have a grouped view for Company and Projects. For Company I group by the standard column \u201cCompany\u201d, but for Projects I use \u201cCountry\/Region\u201d, more on that later.<\/p>\n

Here is the step by step guide to set this up:<\/p>\n

1: Configure same view<\/strong> in Office365 Contact list for Company and Project, \u2013same columns and ordering as intended to use in Outlook.
\"image\"<\/a>
2: Enable Version History<\/strong>
\"image\"<\/a>
Project participation history is now available. All the \u201cnon informational\u201d versions are Categories, so they are reflected to O365, but sadly we cannot use them in Views and filters in O365. And also if a contact is participating in more than one project at a time consider either to just use categories (no versioning there) or use another column available.
\"image\"<\/a>
This Contact participated in 3 projects<\/p>\n

3. Connect to Outlook<\/strong>
\"image\"<\/a><\/p>\n

Optional: In MS Outlook, enable the synced list for e-mail address book (pls forgive my Norwegian Oulook pics \u2013but you get the picture, right \"Smilefjes\" )<\/p>\n

\"image\"<\/a><\/p>\n

3: Create similar grouped views in Outlook<\/strong>
\"snip_20151112134401\"<\/a><\/p>\n

Same columns in all three views, grouped different
\"image\"<\/a>
Here Seminars with Categories
\"image\"<\/a><\/p>\n

No problem quick editing in Outlook<\/strong> \u2013 and imediate synced back to O365.
\"image\"<\/a><\/p>\n

\"image\"<\/a><\/p>\n

You can also Quick edit in SP\u2019s all elements (not grouped)<\/p>\n

Happy Emailing!<\/strong> \"Smilefjes<\/p>\n","protected":false},"excerpt":{"rendered":"

Today I got a request from a Marketing department to solve a problem in Office365 contact list. They have this one list with 2-3 thousand contacts from multiple companies, and contacts are for marketing activities<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[17,37],"class_list":["post-342","post","type-post","status-publish","format-standard","hentry","category-tip","tag-office-365","tag-outlook"],"_links":{"self":[{"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/posts\/342","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=342"}],"version-history":[{"count":3,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/posts\/342\/revisions"}],"predecessor-version":[{"id":345,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=\/wp\/v2\/posts\/342\/revisions\/345"}],"wp:attachment":[{"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sharepoint13.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}