Software

Ask something
Discussion Locked

Mail Meerge

0 helpful
4 replies

by jimmy

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am lecturing and want to send a group of 100 students their own personal results on a regular basis. I believe this can be done with a so-called mail merge. Their results will be created in an excel spreadsheet and be similar to the following:
Question 1 below this will be the mark for Question 1 then Question 2 and below that the mark for Question 2 etc. There would be a column with the student unique ID
I weant to do a mail merge to send to all my students in order that each student would receive only his individual mark is this possible and if so how?

4 replies

by dklippert

Word does a great job along this line.

You don't mention which version of Office you are using, but the process is pretty much the same.

In Word 2000, for instance search for Mail Merge in the Help file and select Overview.
There is a Mail Merge Wizard that will walk you through the process. Go to Tools>Mail Merge (in 2002 it's Tools>Letters and Mailings)

Here's a good tutorial for 2002

http://tinyurl.com/3f0x

Another tutorial for Word and Excel 2000 from California State University is at:

http://tinyurl.com/3f10

This discussion is closed to new replies.