Share via

Export Project 2010 notes data to Excel

Anonymous
2011-05-24T01:39:01+00:00

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...

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

John Project 49,710 Reputation points Volunteer Moderator
2011-05-24T03:00:11+00:00

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)

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

Answer accepted by question author

John Project 49,710 Reputation points Volunteer Moderator
2014-02-13T19:44:12+00:00

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

Was this answer helpful?

0 comments No comments

Answer accepted by question author

John Project 49,710 Reputation points Volunteer Moderator
2013-03-08T16:54:06+00:00

Users,

NunyaBiznas contacted me separately and I provided the macro.

John

Was this answer helpful?

0 comments No comments

70 additional answers

Sort by: Most helpful
  1. Anonymous
    2011-06-15T01:01:22+00:00

    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!

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2011-05-31T00:04:47+00:00

    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

    Was this answer helpful?

    0 comments No comments