Export simple view to a MS Word Table

Posted on 2011-10-04
Last Modified: 2013-12-18
I have a simple vew with colums of data -- nothing special.  Would like to export the view into a Microsoft Word Table -- headings should be the same as my view column names. Also would need the paper in landscape mode.  Is this possible?
Question by:AliciaVee
    LVL 10

    Accepted Solution

    What version of Lotus notes are you using.
    In R8.5.x you can select Edit -> Copy as table.
    I would suggest copying into Excel first to make reformatting easy and then embed the excel into your word document.
    Copying directly can sometimes make the layout go strange during conversion from richtext to what Word wants.

    Or you can select file -> Export Select a Comma Seperated Value (csv) type and file
    You can select to include view titles, all the documents or just selected etc.
    Open this using Excel, format fonts etc and copy into word


    Author Comment


    I have R8.5x and didn't know of that feature.  Just tried pretty good.  Would like to have a button with code -- for other users, but if no one else responds, this will have to do.
    LVL 4

    Expert Comment

    Hi AliciaVee,

    You can create a toolbar icon with

    @Command([CopySelectedAsTable]) for the first one


    @Command([FileExport];"Comma Separated Value";"C:\\testing.txt") for the second one - just change the path to wherever you would like the file to end up. To create toolbar buttons go to File -> Preferences -> Toolbar -> Customize, make sure the Universal toolbar is selected an click on New. (Universal means that the button is always visible to the user).

    Author Closing Comment

    I winded up using the "copy as table" option in Notes, so thanks for letting me know this now exits in version 8.x

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
    For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    This video discusses moving either the default database or any database to a new volume.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now