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
Answer accepted by question author
John Project 49,720 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
Answer accepted by question author
John Project 49,720 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
Answer accepted by question author
John Project 49,720 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

70 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2013-10-02T13:51:01+00:00

    Richard,

    My what a popular thread this has been. You can contact me at the address I provided earlier in this thread.

    John

    I sent an email at 7:50 MST.  Let me know if you don't receive it.

    Rich

    Was this answer helpful?

    0 comments
  2. John Project 49,720 Reputation points Volunteer Moderator
    2013-10-02T15:40:48+00:00

    Rich,

    You didn't say whether that was AM or PM but either way, as I write this it is 8:40 AM MST on Oct 2, 2013 and I have nothing in my e-mail inbox. When I attempt to send an e-mail and use a bad address, my mail server will alert me that the message could not be sent. Did you get any such message?

    John

    Was this answer helpful?

    0 comments