D
Drew
I want to run a report on Business Notes for a Business Contact with a
nicely-formatted Comments field.
For example, when I make a call to a sales lead (Business Contact), I create
a Business Note for that Business Contact, explaining what went on during the
call in the Business Note's Comments field.
Regularly, I have to give a report on all those Business Notes to my boss,
but when I export the report to Excel, the Comments field is all screwed up.
1. I lose any line-breaks in the Comments field, leaving that column as an
ugly wall-of-text. It makes my comments hard on the eyes and sometimes
indecipherable.
2. I have to manually format that column every single time I run a report!
Are there any solutions to these two problems?
nicely-formatted Comments field.
For example, when I make a call to a sales lead (Business Contact), I create
a Business Note for that Business Contact, explaining what went on during the
call in the Business Note's Comments field.
Regularly, I have to give a report on all those Business Notes to my boss,
but when I export the report to Excel, the Comments field is all screwed up.
1. I lose any line-breaks in the Comments field, leaving that column as an
ugly wall-of-text. It makes my comments hard on the eyes and sometimes
indecipherable.
2. I have to manually format that column every single time I run a report!
Are there any solutions to these two problems?