Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-16-2012, 02:45 AM
bluphoto bluphoto is offline Cut/Paste or Export to include headings and multiline notes. Windows XP Cut/Paste or Export to include headings and multiline notes. Office 2003
Novice
Cut/Paste or Export to include headings and multiline notes.
 
Join Date: Mar 2012
Posts: 9
bluphoto is on a distinguished road
Default Cut/Paste or Export to include headings and multiline notes.


I have a project plan for a testing program, in which I've been storing details of each test in the "notes" field.

Obviously, I can only see the first line of the notes from my gantt chart view (though it would be nice to have another view which would sho all my tasks with full notes, but I believe that is not possible.

My question is... Now that I have each task populated with full notes (multiple lines, bullet points, indents etc), how can I get this information into either excel or word, so I can see a list of tests with associated information displayed in full alongside?

Copying and pasting from the gantt view conly seems to copy the first line of the notes.

I'm hoping I don't need to open the notes property of each task and laboriously copy the notes out of the text box and into excel/word.

thanks
Guy
Reply With Quote
  #2  
Old 04-17-2012, 06:36 AM
JulieS JulieS is offline Cut/Paste or Export to include headings and multiline notes. Windows 7 64bit Cut/Paste or Export to include headings and multiline notes. Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Hi Bluphoto,

the notes cannot be directly exported to Excel, you'll need to use SQL or VBA. The notes are stored as a binary large object and will not export correctly.

Julie
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cut/Paste or Export to include headings and multiline notes. Include pictures in .docx bagaksel Word 4 03-14-2012 04:14 AM
Cut/Paste or Export to include headings and multiline notes. Include URL in StyleRef? profliz Word 3 11-07-2011 09:20 AM
Cut/Paste or Export to include headings and multiline notes. what is the professional way to include an equation in a paragraph? Jamal NUMAN Word 1 07-07-2011 11:53 PM
How do I Include a .doc file MagicByDesign Word 0 05-07-2009 02:59 PM
Include headers in table of contents bwhight Word 1 10-10-2006 08:59 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft