Exporting Notes Text in Project 2000

[David McTavish]

I have attached task notes that are too long to be displayed in a sheet
column (the limit appears to be 256 characters). If the Task 'notes' check
box is selected when defining a report then the full text appears. However,
I want to export this data - ultimately to a Word document - but I can't get
the full text to appear. I have tried the straightforward cut and paste,
various paste special options and also an entire project export to Access
but always get the text truncated with an ellipsis. This is all the more
baffling because when I opened the exported Access database in Project all
the text was there but I couldn't find it in any of the tables within
Access! Can anyone assist?

 

[John]

David,
Indeed there is a 256 character limit when attempting to display the
Notes field in a view column and the text from the Notes field normally
truncates with an ellipsis when it encounters a line feed in the text
stream. I have not exported the Notes field to Word or Access but I have
to Excel (using VBA). In order to export the complete Notes text, the
VBA code includes special processing to address line feeds and in the
case of Excel, which has a 1024 character limit in any given cell, a
special algorithm to allow longer text streams. However, a simple cut
and paste from the Project Notes field to Word works fine probably
because the Project database holds Notes text in RTF format and Word is
very "comfortable" with that format. If you did not have success with a
simple cut and paste to Word I don't have a ready answer why it didn't
work. Just make sure you cut the Notes text from the Notes in the Task
Information window and not from the Notes field in a view column. And of
course, make sure you select all the Notes text.

Just from reference, I used Project 2000 and Word from Office
Professional 2000 under Windows XP home for my cut and paste test. I
doubt the app versions or OS make any difference but who knows.

Hope this helps.
John

 

[DavidC]

I know this is a little late but it may still be of use. The notes are saved
in binary data format and need to be converted using VBA. I have done it
ages ago using access with some success.