Anyone have any creative ideas on exporting certain fields in a column of notes documents into a excel spread sheet?
Subject: Re: Exports notes items to a spread sheet
Hello Victor!
Try to create a view with the fields that you need, so “Edit > Copy as table” and paste it on Excel spreadsheet.
Best Regards!
Rodrigo San Vicente
Subject: Some suggestions
First of all, do you read PlanetLotus.org? That is a great way to find information, even if the focus of most of the blogs these days are less classic Notes code.
Here are a couple of blog entries I posted in the past about exactly what you ask about:
http://blog.texasswede.com/export-from-notes-to-excel-3-different-ways/
http://blog.texasswede.com/export-notes-view-to-excel-with-multi-value-fields/
http://blog.texasswede.com/generate-excel-spreadsheets-using-lotusscript/
You can also try this: http://bit.ly/1LE4cx2