Export Project 2010 notes data to Excel

Question

I am trying to export my notes field data from MS Project 2010 to Excel in order to populate other applications.

The problem I have is that the text of the notes has been pasted in from Word and contains carriage returns.

As a result when I export to Excel only the first line of the notes text - up to the first carriage return - will be exported and available in the Excel dump.

I can use a soft return (SHIFT ENTER) to replace the carriage return and can then get  all of the text but formatting is lost and it looks like a garbled mess - not withstanding the effort to manually replace all carriage returns with soft returns throughout ALL (ugh!) of the Project task notes.

Is there a solution to do this without the extreme manual effort and the substandard appearance that results?

If so, please tell, if not, then what do you recommend under the circumstances?

Many thanks in advance...

Answer 1

MickT_61,

Using an export map or simple copy and paste you will only be able to export Notes field text up to the first 255 characters or first line feed, whichever occurs first. I have a macro that will export the full notes text but unfortunately it will not preserve formatting. If you are interested, contact me at the address below. I will ask some questions.

John

jensenljatatfastmaildotdotfm

(remove obvious redundancies)

Answer 2

Eddy,

This is a rather popular thread. Your e-mail address was removed, (to protect you), but you can contact me at:

jensenljatatfastmaildotdotfm

(remove obvious redundancies and the 7th character is a letter

I will ask some questions.

John

Answer 3

Users,

NunyaBiznas contacted me separately and I provided the macro.

John

Answer 4

Just wanted to close this issue.

John's macro provided me with the solution I needed to extract extensive tranches of text from the notes field to Excel.  It's brilliant and really helped.

For anyone else with the same problem I can highly recommend John for his assistance and responsiveness and of course his solution.

Thanks again, mate!

Answer 5

Thanks John,

I would be very keen to have a play with your macro.

It's a bit disappointing that you have had to build a solution as a consequence of Project's shortfall - hopefully in future iterations/updates, there will be provision to export notes (all of them) with formatting.

I'll contact you via your email address shortly.

Thanks for your prompt response.

Cheers,

Mick