OOo Off the Wall: Fielding Questions, Part 4 - Mail Merges

 in
It takes a while to get the hang of mail merges, but OOo 2.0's new Mail Merge Wizard helps make them easier to use.
Conclusion

The basic Mail Merge tool is easy to use once you understand its pre-prerequisites. Once you are comfortable with it, you may feel no need to use the Mail Merge Wizard. In fact, you might want to follow the steps given in this article to remove the Wizard from the Tool menu.

However, you also might decide that the Wizard is more convenient. The Wizard's main advantage is that it centralizes the creation of form letters, setting up the placeholder fields for addresses and salutations and formatting the source document from a centralized window.

But no matter what interface you prefer, Writer's mail merge tool is worth knowing. It's especially useful in office settings, although job hunters and Christmas card writers might find it equally useful for home use. In the past, the fact that mail merges were documented poorly in the on-line help and differed from MS Word's arrangements seem to have prevented many people from using them in Writer. However, between improvements in the on-line help and the addition of the Wizard, Writer's mail merge now has a chance to become a part of users' everyday tool kit.

______________________

-- Bruce Byfield (nanday)

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

And mail merge to Thunderbird Please!!!!

Anonymous's picture

This feature would help so many people. It's been driving me crazy for months trying to do this.

Thunderbird Addressbook Connection

Darren V. Hart's picture

I have seen in mentioned on several places on the web that you can can use a Thunderbird addressbook in OO. I haven't been able to get that to work. In OpenOffice2 (1.9.129 - Ubuntu Breezy):

File->Wizards->Address Data Source

There is no option for a mozilla/netscape/thunderbird addressbook.

File->New->Database

Under connect to an existing databse there is no mozilla/netscape/thunderbird type.

Under OpenOffice 1.1 (1.1.5 - Ubuntu Breezy)
File->Template->Address Book Souce - just real database and textfile types
Tools->Datasources - Same as above

Tools->Mail Merge
From this document
OK
Address Data Source AutoPilot

There is actually a Mozilla/Netscape option here! I select it, click next and get this error:

The connection could not be established, Please check the settings made for the data source.

Clicking more has several fields:

Information - The connection could not be established.
Details - Please check the settings made for the data source.
Error - The connection to the external data source could not be established. No SDBC driver was found for the given URL.
SQL Status - "
Information -
Details - sdbc:address:mozilla

Is there an external sdbc driver I need to find and install or something? I haven' seen it mentioned in these tutorials anywhere.

Now if the OO developers coul

Anonymous's picture

Now if the OO developers could just create a mail merge function that didn't crash when doing large merges !!!!

Re: Now if the OO developers coul

Anonymous's picture

How large is large?

I've done mail merges that produced 500 copies.

Possibly, the number of merges you can do depends on system memory.

- Bruce Byfield

email output from mail merge

DebbyK's picture

Any chance there is a way to create an email output from this instead of sending to printer or a file? That's what I really need to do!

Debby Kilburn
Cerro Coso Community College

OOo's mail merge

Satish's picture

the article is very informative and use full
thanks a lot
from
N.Satish
NIIT Computers
Kadapa
9985016558

White Paper
Linux Management with Red Hat Satellite: Measuring Business Impact and ROI

Linux has become a key foundation for supporting today's rapidly growing IT environments. Linux is being used to deploy business applications and databases, trading on its reputation as a low-cost operating environment. For many IT organizations, Linux is a mainstay for deploying Web servers and has evolved from handling basic file, print, and utility workloads to running mission-critical applications and databases, physically, virtually, and in the cloud. As Linux grows in importance in terms of value to the business, managing Linux environments to high standards of service quality — availability, security, and performance — becomes an essential requirement for business success.

Learn More

Sponsored by Red Hat

White Paper
Private PaaS for the Agile Enterprise

If you already use virtualized infrastructure, you are well on your way to leveraging the power of the cloud. Virtualization offers the promise of limitless resources, but how do you manage that scalability when your DevOps team doesn’t scale? In today’s hypercompetitive markets, fast results can make a difference between leading the pack vs. obsolescence. Organizations need more benefits from cloud computing than just raw resources. They need agility, flexibility, convenience, ROI, and control.

Stackato private Platform-as-a-Service technology from ActiveState extends your private cloud infrastructure by creating a private PaaS to provide on-demand availability, flexibility, control, and ultimately, faster time-to-market for your enterprise.

Learn More

Sponsored by ActiveState