How to create an address book using open office calc

by pchan » Mon Mar 31, 2008 7:04 pm

Re: Creating a booklet

by foxcole » Mon Mar 31, 2008 10:26 pm

Does this help?
wordperfect subdivide page booklet print
(I used the Search box in the top right corner of the forum window and typed booklet.)

It would have been helpful for you to mention whether or not you know anything about setting up page styles, or anything about OOo at all—are you jumping in cold? Have you educated yourself about the software at all?

I think an addition to our Tutorials section may be in order, just to pull together the concepts of how to set up page styles along with printing in brochure mode. I think I will try to accomplish that soon, because there is not one currently and this question is asked with relative frequency in this and other forums.

OOo 3.2.0 Portable, Windows 7 Home Premium 64-bit

Re: Creating a booklet

by moondancer » Wed Apr 02, 2008 5:31 am

Re: Creating a booklet

by foxcole » Wed Apr 02, 2008 5:56 am

That can be helpful, but a booklet with page styles has different requirements than a standard brochure. The main thing they have in common is that the Brochure print setting is useful for arranging the pages in booklet order.

But, one problem with the Brochure setting that I failed to mention is that it’s only useful for pages that are printed two-up, duplex, folded and saddle-stitched (stapled) at the fold to create the booklet. “Use brochure printing for booklets” is an easy, quick response and one that I’ve casually tossed out with some frequency, but it doesn’t give much consideration to the intended product. After about ten leaves of paper, it’s not a very practical approach because the thickness at the fold will create a shelf effect at the edges, which must be trimmed. If you can account for gradually changing outside margins on a thicker book so the text appears equidistant from the edge throughout, and can pay for the trimming or find a way to accomplish it, I suppose that’s not such a problem. except that OOo isn’t designed to account for gradually changing margins on the outside edge.

For a thicker book, a different form of printing and binding is required. You do need to understand the final printed design and use the appropriate paper size and page order to create it.

OOo 3.2.0 Portable, Windows 7 Home Premium 64-bit

Re: Creating a booklet

by kensand » Sun Apr 17, 2011 1:48 am

Hi all.
I have used the method described by Solveig Haugland successfully for many years. I particularly liked the fact that I could produce both A5 and A6 size boolets. A5 is done like Solveig describes i.e. A PORTRAIT file is printed in LANDSCAPE. To print an A6 booklet all that needs be done is print the BROCHURE in PORTRAIT.The layout is just like that for A5 but on portrait it uses only the top haf if the paper. If the bunch of pages are re-inserted reversed ‘top to bottom’ the A4 paper has 2 copies of the booklet.

However, since OO0rg. 3.3 the format of the settings has changed and I get some very peculiar formats and certainly cannot get A6 although A5 is fine

Has anyone a solution?

Re: Creating a booklet

by TheGurkha » Sun Apr 17, 2011 1:02 pm

Re: Creating a booklet

by GuccizBud » Thu Mar 09, 2017 12:27 am

Old thread, but for anyone finding it via their Google search results, the procedure below is exactly what I use to print in booklet
format in OOo.

I have an hp® ENVY 4516, so the print menus for your particular printer model may differ a bit, in which case you need to find the
equivalent commands for your model; in particular, the biggest difference may be that this printer model features automatic 2-sided
printing (can automatically print both sides of a page) … BUT this feature isn’t used in the procedure below (it works fine in Adobe
Reader or Acrobat, but if I do use it to try to print a Booklet in OOo the page orientation doesn’t remain consistent throughout) :

① Go to “File” menu, choose “Print…”
② Under “General” tab click “Properties…”
③ Under “Printing Shortcut” tab set “Print on Both Sides” to “Flip on Long Edge” and clilck “OK”
④ Switch from “General” tab to “Page Layout” tab
⑤ Click “Brochure”
⑥ Set “Page sides/Include” to “Front sides / right pages” and click “Print” button

⑦ When print completes place printed pages back in paper tray without reorienting them in
any way ; simply pick them up, open paper tray, and set them in the tray to be fed next

⑧ Go to “File” menu again, choose “Print…” again … the default tab should still be “Page Layout”
⑨ Change “Page sides: Include” to “Back sides / left pages” and click “Print” button

On my printer the above procedure produces a result identical to using the “Booklet” print feature of Adobe Reader or Acrobat (with
2-sided printing handled automatically by the printer in this case) .

The key step is step ⑤, with “Brochure” in this case paralleling the meaning of “Booklet”. Note that the “Brochure” setting
(automatically) changes the page orientation to Landscape, which is why the steps above don’t include it as a step to be done. The only
setting not mentioned you may want to change is the print quality itself ( Draft , Normal , Best , or wtv) which in most cases would be
done in step ③, the same pop-up where “Flip on Long Edge” is set.

You can create your own templates in two ways: from a document, and using a wizard.

Creating a template from a document

To create a template from a document:

  1. Open a new or existing document of the type you want to make into a template (text document, spreadsheet, drawing, presentation).
  2. Add the content and styles that you want.
  3. From the main menu, choose File > Templates > Save. The Templates dialog opens.
  4. In the New template field, type a name for the new template.
  5. In the Categories list, click the category to which you want to assign the template. The category you choose has no effect on the template itself; it is simply the folder in which you save the template. Choosing an appropriate category makes it easier to find the template when you want to use it. For example, you might save Impress templates under the Presentations category. To learn more about template folders, see Organizing templates.
  6. Click OK to save the new template.

How to create an address book using open office calc

Any settings that can be added to or modified in a document can be saved in a template. For example, below are some of the settings (although not a full list) that can be included in a Writer document and then saved as a template for later use:

  • Printer settings: which printer, single sided / double sided, and paper size, and so on
  • Styles to be used, including character, page, frame, numbering and paragraph styles
  • Format and settings regarding indexes, tables, bibliographies, table of contents

Templates can also contain predefined text, saving you from having to type it every time you create a new document. For example, a letter template may contain your name, address and salutation.

You can also save menu and toolbar customizations in templates; see Chapter 14 (Customizing OpenOffice.org) for more information.

Creating a template using a wizard

You can use wizards to create templates for letters, faxes, agendas, presentations, and Web pages.

For example, the Fax Wizard steps you through the following choices:

  • Type of fax (business or personal)
  • Document elements like the date, subject line (business fax), salutation, and complementary close
  • Options for sender and recipient information (business fax)
  • Text to include in the footer (business fax)

To create a template using a wizard:

  1. From the main menu, choose File > Wizards > [type of template required].
  2. Follow the instructions on the pages of the wizard. This process is slightly different for each type of template, but the format is very similar.
  3. In the last section of the wizard, you can specify the name and location for saving the template. The default location is your user templates directory, but you can choose a different location if you prefer.
  4. Finally, you have the option of creating a new document from your template immediately, or manually changing the template. For future documents, you can re-use the template created by the wizard, just as you would use any other template.

When you type text (such as a website addresses or URL) that can be used as a hyperlink, and then press the spacebar or the Enter key, OOo automatically creates the hyperlink and applies formatting to the text (usually a color and underlining). If this does not happen, you can enable this feature using Tools > AutoCorrect Options > Options and selecting the URL Recognition option.

If you do not want OOo to convert a specific URL to a hyperlink, choose Edit > Undo Insert from the menu bar or press Control+Z immediately after the formatting has been applied.

This will change the color for all hyperlinks in all components of OpenOffice.org; this may not be what you want.

In Writer and Calc (but not Draw or Impress), you can also change the Internet link character style or define and apply new styles to selected links.

You can also insert hyperlinks using the Navigator and the Hyperlink dialog, and you can modify all hyperlinks using the Hyperlink dialog as described in this section.

Using the Hyperlink dialog

To display the dialog, click the Hyperlink icon on the Standard toolbar or choose Insert > Hyperlink from the menu bar. To turn existing text into a link, highlight it before opening the dialog. On the left side, select one of the four categories of hyperlink:

  • Internet: the hyperlink points to a web address, normally starting with http://
  • Mail & News: the hyperlink opens an email message that is pre-addressed to a particular recipient
  • Document: the hyperlink points to another document or to another place in the current document
  • New document: the hyperlink creates a new document

How to create an address book using open office calc

The top right part of the dialog changes according to the choice made for the hyperlink category in the left panel. A full description of all the choices and their interactions is beyond the scope of this chapter. Here is a summary of the most common choices.

For an Internet hyperlink, choose the type of hyperlink (Web, FTP, or Telnet), and enter the required web address (URL).

For a Mail and News hyperlink, specify whether it is a mail or news link, the receiver’s address, and for email, also the subject.

For a Document hyperlink, specify the document path (the Open File button opens a file browser) or leave this blank if you want to link to a target in the same document. Optionally specify the target in the document (for example a specific slide). Click on the Target in Document icon to open the Navigator where you can select the target; or if you know the name of the target, you can type it into the box.

For a New Document hyperlink, specify whether to edit the newly created document immediately (Edit now) or just create it (Edit later), enter the file name, and select the type of document to create (text, spreadsheet, and so on). Click the Select Path button to open a file browser and choose where to store the file.

The Further settings section in the bottom right part of the dialog is common to all the hyperlink categories, although some choices are more relevant to some types of links.

  • Set the value of Frame to determine how the hyperlink will open. This applies to documents that open in a Web browser.
  • Form specifies if the link is to be presented as text or as a button. A hyperlink button is a type of form control. See Chapter 15 of the Writer Guide for more information.
  • Text specifies the text that will be visible to the user. If you do not enter anything here, OOo uses the full URL or path as the link text. Note that if the link is relative and you move the file, this text will not change, though the target will.
  • Name is applicable to HTML documents. It specifies text that will be added as a NAME attribute in the HTML code behind the hyperlink.
  • Events button : click this button to open the Assign Macro dialog and choose a macro to run when the link is clicked. See Chapter 13 (Getting Started with Macros) for more information.

Содержание

  • 1 ADDRESS
    • 1.1 Syntax:
    • 1.2 Example:
    • 1.3 Issues:

ADDRESS

Returns a cell reference as text, given row and column numbers.

Syntax:

ADDRESS(row; column; mode; type; sheet)

row is a number specifying the row. column is a number (not a letter) specifying the column. mode (an optional number) determines whether the cell address is absolute or relative. If omitted, it is assumed to be 1.

mode row column example
1 absolute absolute $A$1
2 absolute relative A$1
3 relative absolute $A1
4 relative relative A1

Example:

returns the text Sheet2.C$4. Note the omitted type parameter.

returns the text C4.

returns the text $C$4.

ADDRESS(4; 3; 2; 0; "Sheet2")

returns the text Sheet2!R4C[3].

The Directory feature in Word merges data in to a single document, such as a membership directory, catalog, or parts list. Since you can merge a number of types of data sources, you can create reports from databases like Access using all the formatting features of Word.

How to create an address book using open office calc

Start the document

Open a blank document.

Go to Mailings > Start Mail Merge > Directory.

Go to Mailings > Select Recipients.

Choose a data source. For more info, see Data sources you can use for a mail merge.

Choose File > Save.

If you need to edit your mailing list, see Mail merge: Edit recipients.

At this point, don’t include text that you want to print only once in the resulting directory document.

Type the text you want to repeat for each item in the directory, such as Name: or Address: labels for individual records.

Click or tap where in the document you want to put a merge field, and insert a merge field. For more info, see Mail merge fields

To create table with one label or heading row, create a document header. Put the label row of the table inside the header. Then put the merge fields in the body of the document.

This works well for long directories that span over multiple pages, as it creates a header for each page.

You can’t type merge field characters (« ») manually. You must use the Mail Merge task pane.

How to create an address book using open office calc

If the merge fields appear inside braces, such as < MERGEFIELD City >, then Word is displaying field codes instead of field results. This doesn’t affect the merge, but is difficult to format. Right-click the field code, and select Toggle Field Codes on the shortcut menu.

How to create an address book using open office calc

If any part of your address is missing, see Mail merge: Match Fields to fix.

Repeat step 2 as needed.

After you’ve completed the main document and inserted all of the merge fields, go to File > Save As.

Go to Mailing > Preview Results.

Use the Back and Forward buttons to scroll though your data, or use Find recipient to search for specific records

If you need to edit, select Preview Results to return to merge field view.

Select Mailings > Finish & Merge and choose Edit Individual Documents. You’ll see 2 other options, but you can’t use them with a directory.

Select one of the following:

To merge all the records, select All.

To merge only the record that you see in the document window, select Current record.

To merge a range of records, type the record numbers in the From and To boxes.

In the new document, add text you only want printed once, such as headers, footers, column headings or any other text.

Save or print the directory just as you would any regular document.

Start the document

Open a blank document.

Go to Mailings > Start Mail Merge > Directory.

Go to Mailings > Select Recipients.

Choose a data source. For more info, see Data sources you can use for a mail merge.

Choose File > Save.

If you need to edit your mailing list, see Mail merge: Edit recipients.

At this point, don’t include text that you want to print only once in the resulting directory document.

Type the text you want to repeat for each item in the directory, such as Name: or Address: labels for individual records.

Click or tap where in the document you want to put a merge field, and insert a merge field. For more info, see Mail merge fields

You can’t type merge field characters (« ») manually. You must use the Mail Merge task pane.

If the merge fields appear inside braces, such as < MERGEFIELD City >, then Word is displaying field codes instead of field results. This doesn’t affect the merge, but is difficult to format. Ctrl – Click the field code, and select Toggle Field Codes on the shortcut menu.

How to create an address book using open office calc

If any part of your address is missing, see Mail merge: Match Fields to fix.

Repeat step 2 as needed.

After you’ve completed the main document and inserted all of the merge fields, go to File > Save As.

Go to Mailing > Preview Results.

Use the Back and Forward buttons to scroll though your data, or use Find recipient to search for specific records

If you need to edit, select Preview Results to return to merge field view.

Select Mailings > Finish & Merge and choose Edit Individual Documents.

In the new document, add text you only want printed once, such as headers, footers, column headings or any other text.

Save or print the directory just as you would any regular document.

OpenOffice is a free open-source software suite. Word processing software is part of the suite, which small businesses can use to make invoices. The word processor is called OpenOffice Writer and can create many types of documents.

To make an invoice in OpenOffice, you’ll need to download and customize one of their invoice templates, according to the Houston Chronicle.

Looking for a better way to invoice? FreshBooks’ online invoicing software gets you paid 2x faster.

In this article, we’ll cover:

1. Download OpenOffice

Visit OpenOffice.org and download their free open-source software suite if you don’t have it already. Follow the instructions on your computer to install it properly.

2. Open OpenOffice Writer

Once OpenOffice is installed, open the program. A menu will pop up asking you which application you want to open. Select “Text Document” or “OpenOffice Writer”—whatever appears on your particular version. Now you’re ready to start creating your invoice.

3. Select an Invoice Template

  1. Go to OpenOffice.org to find invoice templates or click the button on the program’s home screen that says “Get more templates for OpenOffice.”
  2. Or from within OpenOffice Writer, click on “File” then “New” and then “Templates and Documents.” A window will pop up. Click on “Get more templates on-line” in this pop-up.
  3. Once in the templates page, enter “invoice” in the search bar within the page. In the navigation page in the left hand search bar, filter by application by clicking “Writer.”
  4. Choose the format that appeals to you. Click on the template you want and then click the button that says “Download template.” The file should automatically download to your computer.
  5. Check that the file’s in your downloads folder. Open Writer and then click “File” and “Open.” Find the file and open it. Or open the file directly from your downloads folder by double clicking it.

4. Customize the Invoice Template

Now’s the time to personalize your basic invoice. To insert your logo, click on the field you want it in. Then select “Insert” and “Picture” and click “From File.” A window will open so you can find and insert a downloaded image from your computer. Or drag the image from your desktop or other location directly into the document.

Next, customize all the fields. Add an invoice number and date, add your contact information and the client’s, add products or services plus descriptions and their respective costs, add up the total and add extra details like payment terms or a personalized message to your client.

This article lists all the details you should include in your invoice.

5. Save and Send the Invoice

When you’ve completed your invoice, select “File” and then “Save” to save the invoice on your hard drive. Email the file to your client or print it off and mail it.

People also ask:

How To Make an Invoice in PayPal

Follow these easy steps to make an invoice in PayPal:

First attempts

Today is Mother’s Day (at the time I started writing this), and I decided to create and print up a custom Mother’s Day card. Normally, I create cards, whatever the occasion, in a program called Micrografx Windows Draw. I have it installed on a older XP computer, and print my finished documents through my network.

My Acer computer has the direct connection to my Canon iP2700 series printer. My XP computer prints through my network.

Unfortunately, bad things happen. I did up a card and tried to print it only to have the page come out completely blank. So I decided to go into the print preview and sure enough it was also displaying as blank. I started over and did it again only to have the same results. I didn’t even bother trying to fix it.

OpenOffice

I’ve been on-line before trying to find a decent program for doing up greeting cards but haven’t yet found one to suit my needs. There are all kinds of on-line services for making greeting cards but these usually come with limited options. On my main computer, the closest thing that I have to a desktop program is OpenOffice Draw. There is the possibility of downloading templates for OpenOffice, but the only ones I’ve come across were for the small sized cards where you take a page and fold it in half and then fold it in half again.

I was looking for an 8 x 11 half-fold thing. So this is what I did.

I run OpenOffice Draw. It automatically opens to a blank page in Portrait mode and I want it in Landscape mode. So just right-click anywhere on the blank page, then click on Page and then Page setup…

Change the Orientation option to Landscape and click on Ok. Now the page is in landscape mode.

Beforehand, you should go on-line and search for the pictures you want on the card or use your own personal pictures. Usually, I search for pictures on-line by using Google’s image search and save the pictures I like on my hard drive. You can search on-line for verses to put in the card as well.

Photofiltre

I found two pictures and combined them. I found a blue one with the words Big Love and huge Hugs. There were a couple of cartoon people on it which I cropped. I also found the panda bears and had to crop something there, too. OpenOffice has a cropping option by right-clicking on the picture and click on Crop Picture, but I don’t like it. I prefer a program like Photofiltre – http://photofiltre.free.fr/download_en.htm where you just drag the cursor around the part you want to crop, then right-click on it and click on Crop. Simple.

Card Stock

I don’t have any official card stock paper so I decided to use an ordinary page of Glossy Photo Paper. One of the problems with using ordinary photo paper is that a lot of it comes with the company’s logos watermarked all over the backside. Luckily, I have some where the backs are clear. I buy it for about a dollar a pack at the Dollar Store. I can still remember when around here Photo Paper cost over $20 for only about 5 sheets and sometimes you could buy separate sheets for $1 each.

Formatting

Anyway, the tricky part has always been trying to get everything to line up properly when printing. Usually, I print up a copy on ordinary paper using the draft or quick printing mode on my printer until I’m sure it’s going to come out right.

I found a simple way to create a card without templates just using a single page. All I did was to add the pictures, and anything else you want to add, to the right half of the page. A little bit of trial and error and I was able to get it lined up properly to print on a folded 8 x 11 page, glossy side out. With my printer, I just had to flip the page over making sure the page orientation was the same and do the same thing for the inside of the card.

My printer is a Canon model where the paper goes in from the top towards the back. The end result turned out to be a pretty decent card without any special software and/or templates, except for OpenOffice.

Excel Spreadsheet Templates, Open Office Spreadsheet Templates, and templates for other software can be downloaded and saved, either in the default template location, or to a separate folder, and opened in the Spreadsheet program.

Spreadsheet Templates are very useful for often used documents such as invoices, receipts, or standard reports.

Using Excel Spreadsheet Templates

Templates can either be created and saved (see Creating Templates) or obtained from elsewhere such as downloaded from the internet. There are a lot of free Excel spreadsheet templates available with a simple search, and they may be ideal for the task, or require some editing and saving again before use.

In Excel, go to the File menu and select New from Template.

How to create an address book using open office calc

A new window will open containing all the Templates that are stored in the default location. Select the one to use and click Create in the bottom right to open a document based on that template. Once opened it can be used as a workbook and saved to a suitable folder.

How to create an address book using open office calc

If the Template needs to be edited, this can be done and then saved as a new Template to the Excel Templates default folder. Or an existing sheet that has been formatted with formulas and layout can be saved as a template.

Using Open Office Spreadsheet Templates

In Open Office new templates can be downloaded and saved in the default location. This location can be set to another. easier to use folder, by going to the Open Office preferences and selecting the Paths. Templates. option.

Once saved the spreadsheet Template for Open Office will appear in the File. Templates.. menu option, and also under the File. New. Template and Documents option.

Simply find and select the required Open Office Template to create a new sheet. This can then be used and saved to a suitable folder.