how do you 'mail merge' on excel and word?

Question

help im an It idiot and need to know this for an interview next week, i know its not hard but id like to know that basic way on how to do this xxx

Answer 1

Piece of cake. You need a main document (letter) and a datafile (Excel).

First, compose your letter. Where you want name, address, etc., type some sort of marker like an X.

click Tools
cl Mailmerge
You should get the Mailmerge Helper window

cl Create
cl form letter
active window

cl Get Data
cl Open Data Source
browse to your Excel datafile, indicate in file type that it is an Excel Datafile, click Open
cl o.k. to select the whole datafile
You will be told there are no merge fields in your main document
click Edit Main Document (you are returned to your letter)
select the first line with the x to highlight, click Insert Merge Field
select the field(s) name or firstname space lastname
select the second line with the x
cl Insert Merge Field, cl the address
select the third line, cl Insert Merge Field
cl the city, state, zip

File, Save As - give your letter a name
click the Merge button
cl New Document
Voila!

Answer 2

There are lots of useful tutorials on the web, Google "Word Excel mail merge" and you will find lots of them. Good luck.