How to export company notes to excel

[Evie]

Hi Forum, When I export companies to excel I want the most recent note to also export can anyone help me figure out a way to do this.

Thanks in advance

[GLComputing]

Notes wouldn't fit in an Excel cell ... Best option might be to use a report

[ch1p]

You cannot export notes using Excel but you could use the Company Comprehensive Report to get the information out of ACT if that would help. 

[Roy_Laudenslager]

Excel can't be used for that. You could use a report but it would be a complex template to create. I assume that you actually mean History rather than Note but the same applies to both. If you want a history or note specific to the company record you would need to use a third party report editor because the ACT! reports includes all the history  and notes for all the contact connected to the company as well as the ones specific the the company record. In either case isolating the most recent history or note requires significant script programming to make that work. I did create an ACT! contact report that included the most recent Call, Meeting, or Todo history along with the most recent note.