Songbook Creation In Hoster

[trelynda]

I have been cleaning up my database and ready to print new songbooks. I am trying to use the Hoster songbook but have a question. I would like to print in 2 columns but when I select 2 columns in Hoster and then view the book it is only one column. Am I doing something wrong? Also, if I were to inport it into excel or word, how do you guys format them? Do you create a table or anything. Just wondering. Thanks

[Lonman]

I think the 2 column only works in Word.

[Roy Dennis]

Are you using Microsoft Word or Wordpad to open the songbook.rtf file ?
Wordpad can't format in multiple columns.

If you have Word installed on your computer use that. If you have Word but don't know it's location type winword.exe in the search box, if it finds it right click on it and select "Open file location" then you should be able to follow the path to enter it in the songbook select viewer dialog.
I have a video showing how to find winword.exe you can view it here: https://www.youtube.com/watch?v=wYOjPxBa-Eo

In the video I have only shown it with a single column but can assure you 2 columns does display if using Word.

You can also use Microsoft Works Word processor, for that you need to find "WksWP.exe" file.
One way to use it in Excell is to open it in word first then save it as .txt format.

[trelynda]

I have selected 2 columns and saved the file as rtf. Then when I open word it still comes in as one column.

[trelynda]

I have word starter which i think may be the issue. And finding the path to it is not easy. If I open word starter then open the file it is still one column is it because I do not have full version word? Other options?

[Roy Dennis]

When you say you saved it as .rtf file, you don't choose to save it as anything, you just press the create button and it saves it automatically.
Then if you open it by choosing view songbook and you selected 2 column mode and chose Word as the viewer you should see it as 2 columns.

If you don't have the select viewer set for word and it opens with wordpad then you choose to save it as in that then it will only save it as 1 column.

It saves it as Songbook.rtf and is in the folder displayed in the folder path shown in the location window next to the column select box.

[trelynda]

ok last question on this, I have imported all of my songlist into excel. I have two columns, one with artist and one with song title. I have cleaned up the naming and duplicates. My problem is now putting in back into word so that I can create my actual book, with 2 columns. Can anyone give me some suggestions. Do you import back into word or print from excel? I am sure there is a simple solution but I am stuck lol. How do I save it to import into word and format word with 2 columns?

Thanks

[Lonman]

Originally Posted by trelynda

ok last question on this, I have imported all of my songlist into excel. I have two columns, one with artist and one with song title. I have cleaned up the naming and duplicates. My problem is now putting in back into word so that I can create my actual book, with 2 columns. Can anyone give me some suggestions. Do you import back into word or print from excel? I am sure there is a simple solution but I am stuck lol. How do I save it to import into word and format word with 2 columns?

Thanks

Create it with Word as the viewer. Then it will automatically come up when you view the song book as a 2 column formatted book if you have 2 columns selected in the create song books. I didn't even know you could export to Excel anymore. You don't need to drop to Excel or reimport to word.