Printing Envelopes in OpenOffice.org Writer

[pcampa65]

Thank you so much ! You saved me a bundle of time - It is easier to see it done than to read it. :)

[fretwear]

Thanks heaps, I have spent days trying to figure out databases to print envelopes. Worked first time.

[GoodOlPA]

Thanks for the handy video!

[munkpiad]

A couple of notes:

Save the envelope file as "ODF Text Document (.odt)". If you save as .DOC it will not save the address fields correctly.

To avoid empty lines for fields that don't exist, you can insert a hidden paragraph with a condition. There are lots of pages that explain how to do this. Google for "openoffice mail merge empty fields".

[NikolaiDelov]

Thanks a lot for the guide.

I have a problem though, maybe someone can help.

When I import the database, fields with only numbers (US Zip Codes) show up blank. I tried formatting the cells and it doesn't work.

Anybody have a solution?

[7soniclight7]

Thank you. A great help at a very frustrating moment.

[rex1903]

Thanks for the tutorial video. This was very helpful and I'll refer others to your video.

Thanks again

[StudyWithSubstanceP]

What do you have in the "Standup comedy" folder on the desktop?

Great tutorial btw. Many thanks.

[linuxguy2009]

Your the best man! Doing my taxes and needed this tutorial.

Thank You!

[RCSnook]

ENvelope!

[BillWohler]

Thanks, Robbie. Helpful video. I should be able to export addresses from my Google contacts and then import them into OpenOffice calc in order to create the database you described. Let's see...

[redrose678]

thank you for all your help :)

[redrose678]

wow this is  so helpful .....love

how you explain everything step by step great job . ty so much .

[nbgeneralsoft]

It is more easy to print address labels and envelopes online, using post[dot]aplicatiionline[dot]r­o and all the contacts will be saved in the database. There you can see the address formats for every country to format the address correctly.

[jevonscud]

Brilliant, i was just resigning myself to writing out 500 addresses and thought i'd have a quick look on you tube to see if there was an easier way, thank you so much

[humbie02]

have spent hours and have now got 701 files when i want only 351. what to do?

[sjlen]

Thank you, this was really helpful, I did have a good look around the help screens but couldn't find out how to print envelopes. Until finding your video my workaround was to copy the address, go into M$ Word and print the envelope from there (much to my distaste).

[stellasinger]

Thank you so so much for posting this video! I can't tell you how grateful I am!

[dapictures]

:) No problem. Glad you like it. We do tutorials like this regularly; you might enjoy my show, which is available online for free at our web site (see the ticker during the video).

[lucascollaresbarreto]

helped a lot!!! thank u so much!!!!

[PixelPi]

Thanks man, that saved me a ton of time.

[dapictures]

NP - glad it helped. Don't forget to check out my show; we do features like this every week. The URL is at the bottom of the video.