Mail Merging with Excel and Word

Mail merging is a convenient way to create professional and personalized cover letters when looking for a job.  I think back to when I was first applying to be a teacher.  This was before the Pennsylvania Department of Education had a detailed website so I had to create a database by hand.  Now, you can just go to http://www.edna.ed.state.pa.us/ and download the information for specific counties or intermediate units and select which school administrators you want included.  You can even select which types of schools (private or public) you want information for and download it.  How easy is that?!

The hard part is mail merging.  I did some quick searching on YouTube and found two tutorials that might be helpful.  If you’re on a PC and using Office 2007, be sure to check out:  http://www.youtube.com/watch?v=_9ExKwXQ3KQ If you’re on a Mac and using Office, check out:  http://www.youtube.com/watch?v=SGh5zHhUPFo Both tutorials do a great job of walking you through the process of merging a document with an existing Excel database.

Follow

Get every new post delivered to your Inbox.

Join 660 other followers

%d bloggers like this: