« Undocking the Gallery | Main | OpenOffice.org PDF Import Feature »

December 18, 2007

Comments

Ag. I just spent hours figuring out how to do that yesterday.

Hello,

When I view the sample database on this page, it displays in non readable characters. I tried to view in several types of character encoding, including auto detect, without luck. Perhaps you know what the encoding should be so I can view and download this sample file.

Thanks,

Mike

Hi Mike,

Try rightclicking on the database link and saving it to your hard drive, then open it in openoffice.

Solveig

How do you query across databases that are linked to spreadsheets?
I have two different spreadsheets and I need to make a query that removes duplicates from the data in the two and displays only the unique data.

Hi Eric,

A query can include two sheets (tables) in the same spreadsheet, I think, but not in two different spreadsheets.

I followed all your instructions to do labels but when I cam to the table tab, it does not give me the option of table1 or sheet1..the window is blank. thanks for your help

Hi Katharina,

Is the data set up correctly? The first row in the spreadsheet needs to be the labels, like

Name Address

and then the second and subsequent lines need to be the data.

Instructions for the Next Step, Making Your Spreadsheet Into a Database

You need to make a database file that points to the spreadsheet.

1. Choose File > New > Database.

2. Make the selection shown, with Spreadsheet as the format.

I am stuck at step one--where do I find this? I am using open office 2.4--thanks--hope this is enough info--laura

How do you get rid of fields that have no information like Address 2, Positions, Company etc. I have blank spaces in my address labels.

When I view the sample database on this page, it displays in non readable characters. I tried to view in several types of character encoding, including auto detect, without luck. Perhaps you know what the encoding should be so I can view and download this sample file.

wow that's really great you make mailing really easy now.

Hello, i am glad to read the whole content of this blog and am very excited and happy to say that the webmaster has done a very good job here to put all the information content and information at one place, i will must refer this information with reference on my website i.e www.electrocomputerwarehouse.com

Here's what I needed to do (register db, align labels, feed labels one at a time):

http://panela.blog-city.com/openoffice_label_mail_merge_from_a_spreadsheet.htm

Steeped in history and blended in culture, historical sites in Pakistan reflect the

tradition and way of life of the era gone by. There are a number of historical sites in

Pakistan that make an excellent tour.

Social bookmarking submission has developed into a powerful tool for SEO experts. It involves linking sites within the various forums, blogs and message boards on social networking websites, blog sites and content centric sites like Digg. Considered a better alternative to submitting a website on blogs, manual social bookmarking is a simple, convenient and hassle-free way of making sure that your site is noticed and marketed in the right circle.

The comments to this entry are closed.

GetOpenOffice Consulting

Get Book Resources

Search This Blog