Sunday, November 05, 2006

How to use MS Word Mail Merge

By browsing the Internet, I learn that the top 5 business schools are Harvard, Stanford, Warton (Penn), Kellogg (Northwestern), and Sloan (MIT). The top 7 include Chicago and Columbia. Duke and NYU are ranked in top 10 or top 15. Europe's top 3 are Insead, LBS, IMD, perhaps ranked in top 20 in the US. Since some development economists are in business schools, I plan to apply to business schools as well.

Buy 90 C4 manilla envelopes (A4 size) at Ryman, 10 minute walk from LSE. Costs 12.48 pounds. Sounds expensive, but don't have time to check other stores. LSE Student Union shop does not sell envelopes in bunches.

Finish writing cover letters. Here's how to efficiently write cover letters by using MS Word mail merge.
1. Create address lists in Excel. The top row should be "First Name", "Company", "Address 1", "Address 2", "City", "State", "Post Code", and "Country". This will facilitates the matching of fields.
2. Save it and close it.
3. Open MS Word and select "Tools -> Letters and Mailings -> Mail Merge..."
4. (Step 1 of 6) Choose "Letters" and click Next.
5. (Step 2 of 6) Click Next unless you already have a template letter.
6. (Step 3 of 6) Click "Browse" and choose the Excel file created in steps 1-2. Then click Next.
7. (Step 4 of 6) Write a template cover letter. Click a location where you want to put the address. Click "More items..." Choose a field you want to put. Click "Insert". Repeat this until all the fields show up. Then click Next.
8. (Step 5 of 6) By clicking ">>" or "<<", choose the address of the school. Click Next.
9. (Step 6 of 6) Click "Edit individual letters..." and edit the template. Save it.
10. Click "Previous" to go back to step 5 of 6. And repeat 8 to 10 until all the letters are completed and saved.

I also need to make address labels which I stick to envelopes.

How to use MS Word's mail merge to create address labels:
1. Create address lists in Excel. The top row should be "Last Name", "Company", "Address 1", "Address 2", "Address 3", "City", "State", and "Country". This will facilitates the matching of fields.
2. Save it and close it.
3. Open MS Word and select "Tools -> Letters and Mailings -> Mail Merge..."
4. (Step 1 of 6) Choose "Labels" and click Next.
5. (Step 2 of 6) Click "Label options..." and choose "8253 - Label" for product number (this works best for me). Click OK and click Next.
6. (Step 3 of 6) Click "Browse" and choose the Excel file created in steps 1-2. Then click Next.
7. (Step 4 of 6) Click "More items..." Choose a field you want to put. Click "Insert". Repeat this until all the fields show up on the address label. Then click "Update all labels". Then click Next.
8. (Step 5 of 6) Make sure that addresses appear in the way you prefer. If not, click "Previous" to go back to Step 4 of 6. If you're happy, click Next.
9. (Step 6 of 6) Click "Print" to print out address labels.

Realize I also need to make address labels for MY address as the sender.

Some schools require teaching evaluations. I create a short note on my teaching evaluation to clarify it.

Revise the CV. Revise the Introduction and Conclusions of the JMP. Go home by the last train.

No comments: