Microsoft Dynamics CRM (Archived)

Exporting emails to Excel

(0) Share

Report

Posted on by katiel

Hi everyone,

I created an advanced find to include the Description field for Emails. When i export to excel, I get this message

2017_2D00_12_2D00_13-12_5F00_11_5F00_18_2D00_Inbox-_2D00_-katiel_4000_digiterre.com-_2D00_-Outlook.png

Then in Excel, the description field is unreadable.

2017_2D00_12_2D00_13-12_5F00_12_5F00_58_2D00_Email-Advanced-Find-View.xlsx--_5B00_Protected-View_5D00_-_5B00_Repaired_5D00_-_2D00_-Excel.png

Can anyone help?

Many thanks

Katie

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Hi,

As in CRM the EMail desacription field is saved in HTML Format and you don't have the WYSIWYG tool of CRM in your excel.

Excel will just show the html text.

If you want to read what is contained in this fields, you should copy paste in an html editore like notepad++ and format it to HTML.

Was this reply helpful? Yes No
katiel 67 on at

Like (0)

Report

Thanks! How would I get the WYSIWYG tool in excel?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi katiel,

if you want to see clear text in excel you could try as follows:

1) Create a plugin/workflow which will use this code:

https://www.codeproject.com/Articles/11902/Convert-HTML-to-Plain-Text

2) Run this plugin on demand, to populate a "plain text" new attribute

3) Retrieve this attribute on your excel

Hope it helps!

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

Independent Contractor

http://www.francescopicchi.com

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi katiel,

if you solved the problem thanks to an answer, please mark it as verified to encourage the community to provide more and more a better support. Thank you. Francesco

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

Independent Contractor

http://www.francescopicchi.com

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi katiel,

if you solved the problem thanks to an answer, please mark it as verified to encourage the community to provide more and more a better support. Thank you. Francesco

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

Independent Contractor

http://www.francescopicchi.com

Was this reply helpful? Yes No