• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

Export simple view to a MS Word Table

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?
0
AliciaVee
Asked:
AliciaVee
  • 2
1 Solution
 
doninjaCommented:
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

0
 
AliciaVeeAuthor Commented:
doninja,

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



You can create a toolbar icon with

@Command([CopySelectedAsTable]) for the first one

and

@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).
0
 
AliciaVeeAuthor Commented:
I winded up using the "copy as table" option in Notes, so thanks for letting me know this now exits in version 8.x
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now