Subscribe in a reader

Enter your email address:

Delivered by FeedBurner



I'm a poor blogger.. Maybe you can donate some cent to me...

Add url

Mail merge using open office

Bookmark this post:
StumpleUpon Ma.gnolia DiggIt! Del.icio.us Yahoo Technorati Google

Do you know how to do mail merge in open office? Read this :-
1. Get your data. You've already got it, probably. This blog is for people with data in text files, and in spreadsheets.

2. Turn it into a data source.

3. Create your mail merge document and suck the data in through the data source.

4. Print, specifying how many of the data records you want to print for, and whether to print to a file or printer.

1. Get Your Data

You probably already have it. It's in a .txt file or .csv that's comma or tab separated, perhaps. Or it's just a spreadsheet.

2. Make the Data Source: Text File Instructions

If your data is in text files, follow these steps.

1. Choose File > New > Database.

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

3. Click Next.

4. Specify the DIRECTORY where the text files are. Each text file in that directory will be a table in your database. Then select the item separating fields, i.e. a tab or comma or something else.
5. When all the settings look correct, click Next.

6. Unmark the option to open the database for editing. You can open it; you just don't have to.
7. Click Next.

8. Save the data source (aka database) under a name that will help you remember what it is.
You're done

2. Make the Data Source: Spreadsheet Instructions

If your data is in a spreadsheet, follow these steps.

1. Choose File > New > Database.

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

3. Click Next.

4. Specify the spreadsheet file. Each SHEET in that spreadsheet will be a table in your database.

5. Click Next.

6. Unmark the option to open the database for editing. You can open it; you just don't have to.
7. Click Next.

8. Save the data source (aka database) under a name that will help you remember what it is

3. Create Your Mail Merge Document and Suck the Data In From the Datasource

You can also use the simple or complex mail merge.

Simple: http://openoffice.blogs.com/openoffice/2006/03/techtarget_arti_1.html

Complex: http://openoffice.blogs.com/openoffice/2006/02/techtarget_arti.html

But this is a nice way to do it too.

1. Create a new Writer document or open a document containing text that you want in the mail merge document.

2. Choose View > Data Sources. Everything you've created will be displayed. Click the + sign by the data source you want to use, then click + by Tables til you see the data you want to use.

3. Type any content you want and do any formatting. You can do this later too

4. Click on the NAME OF THE FIELD, not the piece of data, that you want in the mail merge.

5. Drag it into the document and release. The field name will appear.
6. Add any other content and fields you want.
Save the document. You're ready to print.

4. Print the Mail Merge Document.

1. Choose File > Print.

2. You'll see this message. Click Yes. DON'T MARK THE CHECKBOX SAYING YOU DON'T WANT TO SEE THE MESSAGE AGAIN.

3. In the print window, specify the range of records, if you don't want them all, and specify to print to a printer, or to files.

4. Click OK.

5. In the print window, specify the printer and click Print.

source :- Openoffice

I'll be active again and this blog will full of all result of my searching in the net. Sharing all I've get.

Comments

7 Responses to "Mail merge using open office"

Anonymous said... 2:20 PM

I am genuinely grateful to the owner of this web site
who has shared this fantastic post at at this time.

Also visit my web site - good carbs and bad carbs
my web site - high5software.com

Anonymous said... 11:48 PM

A fascinating discussion is worth comment. I think
that you should publish more about this subject matter, it may not be a taboo matter but generally people don't discuss these topics. To the next! Cheers!!

Feel free to surf to my page kunst-am-wege.de
My website: www.fadaf.de

Anonymous said... 7:42 PM

bookmarked!!, I like your website!

my homepage :: Steinzeitdiät Erfahrungen
Also see my website :: Steinzeitdiät

Anonymous said... 5:28 PM

Wow! Finally I got a webpage from where I be able to genuinely obtain valuable data
regarding my study and knowledge.

Also visit my web-site ... Glutenunverträglichkeit
my webpage > hundefutter ohne fleisch

Anonymous said... 4:37 PM

Hi there, I discovered your site by the use of Google
even as looking for a related subject, your website came up, it seems great.

I've bookmarked it in my google bookmarks.
Hello there, simply turned into alert to your blog thru Google, and located that it is really informative. I'm gonna
be careful for brussels. I will appreciate should you continue this in
future. Many other people will probably be benefited
from your writing. Cheers!

My website ... ernährung

Anonymous said... 8:37 AM

Nice post. I learn something new and challenging
on websites I stumbleupon everyday. It will always be interesting to read content from other
authors and practice a little something from their sites.


Stop by my site; Shiatsu

Anonymous said... 8:37 AM

Hi there, I enjoy reading through your article post. I
like to write a little comment to support you.


Here is my blog post: Traditionelle Thai Massage in Wiesbaden

Sponsor

Search Engine Optimization - AddMe
This blog is about my interest.. You can learn how to Origami, help your health and many tools in the net.
Links 24/7





Labels