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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s