{"id":2335,"date":"2021-06-13T17:56:05","date_gmt":"2021-06-13T17:56:05","guid":{"rendered":"https:\/\/portfolio.accrualhub.com\/powergi2\/?p=585"},"modified":"2022-07-19T02:21:17","modified_gmt":"2022-07-19T02:21:17","slug":"export-emails-calendar-events-to-excel","status":"publish","type":"post","link":"https:\/\/powergi.net\/es\/blog\/export-emails-calendar-events-to-excel\/","title":{"rendered":"Export Emails & Calendar Events to MS Excel"},"content":{"rendered":"
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\n

You just sent over 500 marketing emails to your distribution list, and you are now getting lots of \u201cUndeliverable\u201d emails back, then you realize that you have several emails stuck in the outbox \u2013 for some reason they were not sent.<\/p>\n\n\n\n

Sounds like you need a list of what was sent, what wasn\u2019t, and which emails are no longer valid, right?<\/p>\n\n\n\n

No worries \u2013 Excel is here to help<\/strong>!<\/p>

\t\t
\n\t\t\t
\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

De la visi\u00f3n a la ejecuci\u00f3n<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t

Ya sea que est\u00e9s empezando o escalando la automatizaci\u00f3n, te ayudamos a convertir tus ideas en soluciones impactantes.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t<\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t<\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<\/div>\n\n\n\n

Step by Step<\/h3>\n\n\n\n

Open a new Excel workbook.<\/strong> Go to Data tab, then Get Data->From Online Services-> From Microsoft Exchange Online<\/em><\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

In the next window type the email address you need to list emails for.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Select \u201cMicrosoft account<\/strong><\/em>\u201d blade and then click on Sign in<\/em> <\/strong>\u2013 input your user and password. Then Click Connect<\/em><\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Once you are authorized to continue, you will see a screen with different options.<\/p>\n\n\n\n

If you want to get your emails listed<\/em><\/strong>, select Mail<\/em><\/strong>.<\/p>\n\n\n\n

If you want to see your calendar events<\/em><\/strong>, select Calendar<\/em><\/strong>.<\/p>\n\n\n\n

After selecting the data that you need, just click on Transform Data<\/strong><\/em>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Use the \u201cFolder Path<\/em><\/strong>\u201d column to select the items you need to list in Excel. In this case we care about Inbox, Outbox and Sent Items<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Additionally, you can use the Date columns to select only the dates you need.<\/p>

\t\t
\n\t\t\t
\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

\u00bfEst\u00e1 su negocio preparado para la automatizaci\u00f3n?<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t

Automatiza procesos con Microsoft Power Platform.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t<\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t<\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Once you are ready, just click on \u201cClose and Load<\/em><\/strong>\u201d. Wait for some seconds and you will have all the emails in Excel loaded to a Sheet.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Note that the above steps can also be done from Power BI.<\/p>\n\n\n\n

All set! \u2013 use the results of this Query to answers the questions: Which emails were undeliverable? What is still stuck in the outbox? What is in my sent items? And much more!<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"

You just sent over 500 marketing emails to your distribution list, and you are now getting lots of \u201cUndeliverable\u201d emails back, then you realize that you have several emails stuck in the outbox \u2013 for some reason they were not sent. Sounds like you need a list of what was sent, what wasn\u2019t, and which […]<\/p>\n","protected":false},"author":2,"featured_media":2617,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"glossary_letter":"","footnotes":""},"categories":[35,29,25],"tags":[],"class_list":["post-2335","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel","category-power-bi-cat","category-power-query-cat"],"glossary_letter":null,"rank_math_title":null,"rank_math_description":"Export your emails and calendar events to Excel automatically with Power Automate. Organize your data and schedule with this Power GI tutorial.","rank_math_focus_keyword":null,"_links":{"self":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/posts\/2335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/comments?post=2335"}],"version-history":[{"count":0,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/posts\/2335\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/media\/2617"}],"wp:attachment":[{"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/media?parent=2335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/categories?post=2335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/powergi.net\/es\/wp-json\/wp\/v2\/tags?post=2335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}