Wednesday, November 26, 2014

Technology How to: Mail Merge

Mail Merge - More than just letters

A mail merge can become a very handy tool to master. I will be showing you how to do it in Microsoft Word and Excel, but it could be completed with other software as well. The process can seem very overwhelming and daunting at first, but once you start practicing and using the process you will see the endless possibilities. I use mail merges for Christmas cards, recipe cards, and even at work, to create forms for staff to complete. These are just printed examples of a mail merge! You are also able to setup and create a merge to send email through your Outlook. This is great for party invites or announcements.

Setting up the List

The first set to the list of Names or recipes is the first step. I have included a video blow showing how to set up both styles of lists. The address list is very straight forward and would include the expected items such as Name, Address, City, State, Zip, but you can also include spouse and family members names. The recipes list will include ingredients, and directions. Depending on the size of the directions, it might take two cards and two directions.

Setting up the Document

Setting up the document can be the funnest part. You are able to write and setup up what you want each item to look like. This includes text, images to make your final product amazing. In the video below shows how to set up both a letter and recipe cards, as well as how to merge the data from your Lists.

Final Products

There are several outputs for your finished merge. There is a the PDF Letter attached, or as show above the email that is received. Each is customized and personalized with the needed information. I hope this helps you in your mail merge adventures!


If you can think it, there is usually a way to make it happen. Never give up, and always try to allow technology to make your life a little easier.


Wednesday, November 19, 2014

Self Help: Organizing you schedual

Organizing your schedule

Organizing your schedule can be a very difficult thing. Balancing working, housework, family activities, it can become overwhelming very fast. Then when you start to add other family members into attending and tracking these items the water will become muddy very fast. 

How to organize

As a a working professional, mother, and wife, the demand on my time stretched thin. My spouse tries to assist, as well as my father and father-in-law. This causes our largest hurdle to be keeping everyone on the same page.

To solve this issue, we created everyone a Gmail account, and set it up on their smart phones. With all of us using Gmail, we are able to "invite" the others to events, such as doctor appointments, or celebrations. Then it will show on your calendars on.
Above is a short video that shows how to create a calendar event and invite someone. When you invite them, you will need to send it (when you save, it will prompt you to send). The event will be shown on their calendars.

My household and family use Gmail and Google Calendar not only for doctor appointments, but for recurring bills, special events, shopping trips, pay days. Anything we want to make sure to remember, we put on our calendars, and invite those who we want to attend with us.

Electronic and Hard Copies

Being that everyone in the family has smartphones and/or tablets, we usually keep everything electronic, but on extremely busy weeks, we will print out the our Google Calendar and post it on the fridge or push-pin board.