Everything2
Near Matches
Ignore Exact
Full Text
Everything2

mail merge

created by JoeBaldwin

(thing) by JoeBaldwin (1.2 y) (print)   ?   (I like it!) Wed Sep 10 2003 at 19:40:42

Suppose you have to send out lots of invitations to a party. LOTS of invitations-we're talking in the region of 40 or so here. Now, you want to use your spiffy new computer to do all this, but you can't be assed to retype all the names forty times, all the addresses forty times...nightmare.

So instead of tediously reentering things, you do a mail merge.

A mail merge is where you take mailing information and merge it into a letter, making a personalised set of letters. For example, a typical, barebones, unmerged mail merge letter would look something like this:

<<Address1>>
<<Town>>
<<County>>
<<Postcode>>

Dear <<FirstName>>
We would be delighted if you and your wife <<SpousesName>> would attend our get together at our house on Saturday 15th June. BYOB!

Yours sincerely,
Joe J. Baldwin


Now, that doesn't look like much, does it? So you would enter all the FirstName, Address1 etc data into a database (actually your word processor pretending to be a database) then do the merge. Hey presto, you get 40 letters, ready to be printed, with all of the addresses and names put in place. When this is done, instead of the mangled mess of quasi-HTML above, you would have:

1 Spiffy Way
Niceton
Bucks
FU6 2NY

Dear Jeff
We would be delighted if you and your wife Carolina would attend our get together at our house on Saturday 15th June. BYOB!

Yours sincerely,
Joe J. Baldwin


And much more in that vein. Mail merge is in most popular word processors, such as Microsoft Word (and also Publisher. I also found (after a poke in the right direction by wertperch that it is indeed possible to use Outlook as a mail merge source-see http://www.ibiztips.com/email25JUN01.htm), OpenOffice.org and KWord (in KWords case, you have to use an actual database, instead of a WP internal one). Good thing too, as a mail merge is a semi-required project in GCSE IT.

printable version
chaos

BYOB GCSE IT I signed up for the carpool for all the wrong reasons and now I'm bitter as Hell Rigged joint
Microsoft Sidewinder European Computer Driving Licence April 12, 2005 Children's games
Microsoft Word KWord OpenOffice.org MySQL
spouse sexism ASP wife
Y'know, if you log in, you can write something here, or contact authors directly on the site. Create a New User if you don't already have an account.
  Epicenter
Login
Password

password reminder
register

Everything2 Help

Cool Staff Picks
The best nodes of all time:
power structure
A Letter To My Grandfather
New Musical Express
Mr. Mxyzptlk
Medea
Vegas stories: My first girlfriend's wedding
The Werther Effect
Jane's Fighting Nodes
Garry Owen
Why do joints crack?
Aristotle's Lost Library, Medieval Andalusia & Chinese Paper, or How Europe Learned to Learn Again and Why the Renaissance Happened When & Where It Did
How to meet the most girls
Diego Rivera
New Writeups
SwimmingMonkey
Conversations with Fo Fo- the Loneliest dog in Purgatory(fiction)
locke baron
lynx(thing)
Simulacron3
Reality, Dimensions and the Natural Ontology(essay)
SubSane
Making Love to a 9-Foot Woman(person)
Ouzo
Thoughts(idea)
antigravpussy
I fall silent, listening. The breadcrumbs are talking about us(person)
calgon
Buffalo Bill by the pool(poetry)
gate
Anarchy is Order(idea)
ushdfgakjasgh
Scribeling(thing)
XWiz
Trism(review)
artman2003
Briefcase Full of Souls - Part I(fiction)
Dreamvirus
Alan Ladd(person)
waverider37
Harold Holt(person)
The Debutante
Until death do us part(fiction)
Ysardo
a brother to a sister(personal)
Everything 2 is brought to you by the letter C and The Everything Development Company