Category: Church Resources

  • Family History in Every Season: Building Relationships Across Generations

    Family History in Every Season: Building Relationships Across Generations

    I was asked to help the Temple and Family History committee in our ward give a fifth Sunday presentation about family history. If you’ve been given a similar assignment I hope that you might be able to use some of what I’ve done (or go ahead and use all of it, the work’s been done so it might as well get more mileage) to help you prepare a meaningful lesson for your ward as well. Or if you just want some inspiration and to learn a little bit more about how you can be more involved in Family History in some way, or why it might be important to you, this is your chance to pretend like you were at my presentation that day 🙂

    Specifically the committee wanted me to talk about how people can upload memories to Family Search as a way to help with their family history work. I was given WAY more time than I needed for that particular part of the demonstration so I decided I would start with some of the “why” behind family history and then work my way up to showing the “how”. I figured the memories section would take me 5 minutes at most and I had the whole meeting, and I really wanted to recreate a role play that I’d seen done in a previous ward that had deeply impacted my view of family history.

    Well…. of course sacrament meeting that day went over by a good bit and it took awhile to empty out the chapel after the combined missionary farewell & homecoming that day. So my time was cut short. In the end I never made it past the “why” to get to the “how” that I’d actually been asked to talk on – oops! The ward members still seemed to really appreciate what we did get to and I think it was still a successful and meaningful lesson. My husband afterwards rolled his eyes at me. It was so typical “Brittny” to find a way to do a completely different assignment than I was asked to do, and have people like it anyways. I really did have every intention of sharing what I was asked to do though!

    I figured since I’d put this all together I would share it here too, and actually put in the part that I promised I would get to in my original presentation. If you jump to the end I have all of the files that you are welcome to use and modify if you like any part of it for your own ward. I’ll go through basically what I presented in the blog post too so that you understand the context, rather than just having slides that don’t mean anything to you.

    I actually presented with my mom, which was fortunate that she happened to be in town for that 5th Sunday because she is the family genealogist and knows MUCH more about all of this than I do. I’ll include my slide deck and print outs at the bottom and if someone else wants to do something similar in their ward I hope that this gives you some good ideas to put together an easy and compelling lesson 🙂

    So I’m going to admit up front that most of my graphics are AI generated.  I’m not artistic and I had specific ideas for how I wanted to portray some of the ideas so AI was my best bet… but if you look too closely there are definitely cursed faces and some real jankiness in some of the graphics…. So try not to look too closely.  When I was asked to teach a fifth Sunday temple and family history lesson I thought it was kind of funny because I don’t actually do genealogy.  I know how to open up Family Search and poke around a little bit, I know how to look people up in census records and I know I have the right skill sets to really be good at genealogy.  But I don’t do genealogy.  Why?

    Because right now I feel like my part of doing genealogy work is in the branches rather than the roots.  Rather than feeling guilty that I’m not spending my time finding my ancestors I’ve embraced the fact that I’m devoting my time to their descendants – and that’s ok!  When I was growing up my grandma was the family genealogist and my mom didn’t have the time to order microfiches and fill out pedigree charts.  Today my mom has moved into her genealogy era and I’m the one running to soccer games.  But I know that one day I won’t have soccer games to run to and I’ll be the one ordering copies of death certificates to fill in the charts.  I know that sometimes we have family history lessons and if you’re not in your genealogy era you might be tempted to pull up candy crush and tune out – but I hope today that we can help you find ways that you feel you can be a part of family history in whatever era you’re in today.  I’m not going to tell you that you have to do all the research if research isn’t your thing, or attend the temple every single day.  But there is *something* each of us can contribute to this work and I hope to help you find something that you can do in your present era.

    As we started to put this lesson together my mom told me about this video clip that she saw at Roots Tech a couple years ago.  The original presenter wasn’t able to make it to the convention so at the last minute they pulled in an engineer to give this breakout session.  Now, I’m a computer programmer and I know that the last thing you want at your big convention is to pull out the engineers and make them talk.  Engineers are rarely people people. They are happy to hide in a closet and build cool things but please don’t make them talk to someone about it.  But what this engineer had to say completely changed the way my mom looks at family.  The video was too long to watch in our lesson and there wasn’t just one little clip that showed the point, so I’ll summarize.

    At the beginning of his presentation he told the audience that what they’re doing is all about building relationships and uniting families.  He went on to talk about all of their different updates and each time showed how each tool and feature was created with the object of building relationships.  If you’ve used the “find my relatives” feature before it might seem kind of silly – unless you understand that the idea isn’t necessarily to help fill out a chart but to connect you to other people. 

    So that’s what I want to focus on – it’s all about relationships.  It’s not about charts, or records, or checking boxes at the temple – it’s about relationships.  If you take nothing else away from what I’m sharing THAT is what I want you to take away.  Temple & Family History work is about building relationships.  I told you that I don’t do genealogy, but one of the ways I contribute to our family history work is by trying to still build relationships on both sides of the veil.  Obviously the ones with my own living family feel the most important, but I try to treat my ancestors as real people because… they are.  I can’t be the one digging through records right now but I try to do my part to listen to my mom when she’s discovered a new line or wants to show off the pictures she got from her dad.  I may not be finding the people myself, but I try to always cherish the memories or tidbits of information that I can learn about those that have gone on before so that I can build a little bit of a relationship with them. 

    I would like to hear from you in the comments about how we build those relationships with those who have come before us.  I thought I would start by telling you some of my own experiences. This picture shows some women who are an important part of my personal family legacy.  I am on the far left and my daughter is on the far right.  If you think my daughter looks like she might have just been crying that’s because we’d just done a gender reveal for our 5th baby and she’d just discovered that he was going to be a 4th brother… and NOT the sister that she was hoping for. Next to my daughter is my mom – we get told that we look identical pretty much all the time.  Next to me is my grandma, and there in the middle is her mom – my great grandma.  Pretty cool to get a picture with 5 generations of women all together! 

    Almost 2 years ago we went as a family down to Australia to celebrate my great grandma Kitty’s 100th birthday.  We were a little bit late because of COVID restrictions and she was actually closer to 101 but it was such a treat to get to introduce my kids to their great great grandma.  Grandma Kitty is pretty feisty. One of my favorite stories of her is that in the middle of COVID in Australia they had restrictions that made it so that you were only allowed to go to the grocery store on particular days based on where your name fell in the alphabet or something like that.  One day she told my grandma that she was pop down to the shops and my grandma said, “Mom, you can’t do that, it’s not your day to be allowed to go!”  My great grandma replied, “I’m 99 years old, what are they going to do to me?  I’ll just act confused and tell them ‘Oh sorry love, I don’t understand all these new protocols.’ and they’ll let me shop.”  Don’t stand between an old lady and the grocery store when she wants to go!  She was still living on her own when we went to visit her at 101 and I think she’s amazing. I hope to grow up to be every bit as independent as she is – and to live as long!

    I don’t know how many people have personally known their great grandparents personally but when I was born I had 5 of my 8 great grandparents still living – I’m the oldest child of an oldest and 2nd oldest child so the gaps are a little more condensed.  On the other hand my husband is the youngest of 9 kids – his great grandparents were long since gone by the time he came around.  Only our oldest two children were able to meet his last living Grandma, but they were too little to remember even that meeting. 

    A great grandparent might seem fairly removed from you personally if you haven’t had them in your life, but my great grandparents are people I feel very connected to.  I can remember my Grandma Bonnie playing sports with her grandkids.  I remember my Grandpa Tom whistling for the lorikeets in his backyard.  I remember my Great Grandpa Anderson visiting our home in California and insisting on working in the yard – despite being well into his 90s and my mom being convinced it would be the thing that killed him and that the family would hate her forever.  I remember the raspberries in my Grandma Arlene’s backyard that we would pick while my parents would visit with them inside. 

    These are very real people.  Despite Grandma Kitty being the only one of those great grandparents still alive – she’s kicking around now at 102 – I know that all of them were invested in me while they were here on earth – and I can’t imagine that investment disappeared just because they passed through the veil.  I think of my relationships with my own kids.  I may not know a lot about what happens in the next life but I do know that it would take a lot more than death to erase the love I have for them.  We may not remember these people but I know that they remember us and I am certain that they play a very active role in our lives, even though we don’t necessarily always see their hands in our lives.

    For the next part of my presentation we did a little role playing activity that got people really involved. We had handed out little slips of paper with short stories of some of my actual ancestors. Everyone that had been assigned a role came up to the podium (we were in the chapel) and we assigned one side of the podium to be spirit prison and the other to be spirit paradise.

    If I had a little more time I would have tried to have the people who came up be from real families that matched the roles of the families – i.e. one of the families in my script was a mother, father and two daughters. I would have liked for it to have been an actual couple in our ward with two daughters and have them stand up as a family – but my casting time was limited. It worked out beautifully even without doing that though and the experience was awesome all together.

    I had the individuals come up to the microphone in order (the slips of paper are numbered) and they would read their little story. Just a few lines about their name, where they lived, something cool about them. At the end of the story they would ask – “Does anyone have my name?” Before the meeting had started we handed out slips of paper with a picture of the temple and a name of one of the ancestors to youth in the audience. If the name was in the audience the youth could come up to the podium and bring the ancestor from spirit prison to spirit paradise.

    I intentionally structured the script so that the first whole family was all easily accounted for and they all made it to spirit paradise. You could tell that people were starting to get a little kind of giggly from the hokey representation. Not irreverent or anything just it was kind of fun to take people from spirit prison to spirit paradise and it was a little silly. Then as one particular brother got up he got to where he asked, “does anyone have my name?” and you could tell that it hit him. If no one out there had his name, he couldn’t go on. It changed the mood just a bit as the weight of it was felt a little more.

    The second family that I had selected was a couple with two daughters. As we went through there was someone who had the name of the father. Someone who had the name of the mother. Someone who had the name of the first daughter… but no one had the name of the second daughter. She had to go back to spirit prison. Suddenly you could tell things got a little more real for the class. Oh… wait. You mean without someone to take her she doesn’t get to go to spirit paradise? Oh…

    The next family wasn’t found at all, and the feeling was sadder still as a whole family didn’t get to go on to the other side. The last family was that of my Grandpa Tom. He had done his own work during this life so he got to go on to spirit paradise but he was trying to connect with his biological father that he hadn’t known and his son that he was estranged from in this life. The father and son weren’t able to get up and go to the other side.

    While we were all sitting there I got up and told everyone how I was feeling. Of course it was happy to see so many people making it to spirit paradise. But no matter how many people made it, I was still infinitely sad about those who were left behind! Sure that second family had gotten 3 out of 4 members to the other side. Hey in school 75% is a passing grade! But oh, if that one left behind had been my child… it would count as a zero to me. I can’t imagine a happiness in the next life that involves leaving any one of my children behind. Seeing the people left in spirit prison was heart breaking.

    After we sat with this for a minute I had my mom get up after this and explain why these people weren’t found at first and how we did eventually find them through family history work.

    The first family I shared was the family of my 4th great grandfather Ira Allen. Ira joined the church in 1845. The family that we had stand up were representing his parents and siblings. All of their work had been done back in the 1800’s. They were easy to find because they were people that Ira would have known personally and he made sure their work was done himself.

    The next family was that of my 3rd Great Grandfather Joseph Cabella. He was a ship’s captain that was lost at sea in 1847. His wife was pregnant at the time but the baby only lived for a few months after birth. The mother lived for 4 years longer before leaving their first child – who was only 8 years old at the time – an orphan. The father, mother and oldest daughter were easy enough to find – their oldest daughter was my 3rd great grandmother and her parents show up in the records plenty. Their work had all been completed in the late 1960s and 1970s. The baby though wasn’t obvious to find. She doesn’t show up on census records, she had no children of her own – there was no one to carry on her legacy. My parents found her through good old fashioned detective work. They felt like they ought to take another look at this family and really comb the records to make sure there was no one that was missed. Luckily Cabella isn’t a very common last name so searching records in their area for that last name inevitably pulled up relatives, the trick was just finding how they fit. As they did this they came across a birth and death record for Rose. She never appeared on any census but she still appeared in those records. Her work was finally completed in 2010. At this point in the presentation I was going to have “Rose” stand back up and ask “does anyone have my name?” I had a friend in the audience who was handing out the names of these lost people who could then have them come forward and take them to spirit paradise. Unfortunately, we ended up being strapped for time and that kind of got skipped but that was the intention.

    Cyril Challoner’s family was more recent. He is the cousin of my great grandfather – one of the few great grandparents that I did not get a chance to meet in this life. While the other people that I highlighted were direct ancestors of mine, Cyril was a little more lateral. He, his wife and daughter were all killed during the bombings on England during WW2. They have no living descendants today. The only way they could be found was for us to explore more of our family tree than just our direct line.

    The final family that we highlighted was my great grandfather Tom Smith. I talked about him earlier as the grandpa that I remember whistling for lorikeets in his backyard in Queensland Australia. You would think his genealogy would be super straightforward – he was a genealogist up until his death in 2014! We had the Smith line covered way way back and thought we were just working on branches that were going to be really hard to fill in because the records from so long ago would be difficult to find.

    Then, after my grandfather’s death my mom did an Ancestry.com DNA analysis. Her report came back that she had Russian Jewish ancestry. Huh? How could that be? Slowly she was able to piece together that her biological great granddad was not the man that her great grandma was married to. Through a series of digging through records, comparing pictures, and talking with DNA matched relatives she determined that Tom Smith’s dad was actually Leopold Hirschberg – a sailor who was living in Liverpool, England at the time. Tom’s middle name of “Lusitania” suddenly made sense as his father survived the sinking of the Lusitania the year before his birth.

    We actually found mention of Leopold in a book called Wilful Murder: The sinking of the Lusitania, however at the time he was using the name Leonard Thompson as a means of avoiding prejudice against his Jewish heritage. He was tricky to find with different names and no records that would confirm his identity but it was fascinating as we put some of these puzzle pieces together. We had joked for years that Grandpa Tom looked a lot like Tevya from Fiddler on the Roof and it was interesting to discover that we weren’t far off – his ancestors came from a town very similar to Anatevka. This has opened up a completely different line of research for putting together our family history.

    This finding of Jewish ancestry was especially interesting to me. As I had named my children I’d felt very strongly drawn to specifically Hebrew names for them. It wasn’t anything intentional, but when I looked back I could see that I’d decided to give them names like Samuel, Daniel, Esther, & David. You know what names we found in this lost branch of our family? Yup, all the same ones. My older boys have had the opportunity now to go to the temple and do the baptisms for ancestors that share their names – ancestors that I didn’t even know about when I gave them those names.

    The DNA analysis also started connecting my mom with cousins that she didn’t recognize. A little bit of sleuthing uncovered that during his military service in WW2 my grandfather had fathered a son in Ireland. The boy had spent his whole life searching for his dad but never connected to him. He had passed away before his father. We believe that this whole crew of estranged fathers and sons has been connecting on the other side and making up for the lost time they never got to have on earth. It has been an honor to reconnect them and restore these lost ties.

    I hope that watching these examples has helped you see how you can start to connect to your deceased loved ones.  These are real people, even if we don’t remember them anymore.  If you’re familiar with the movie Coco you understand the sentiment that you die twice – once when your heart stops beating and once when there is no one on the earth who still remembers you.  Through reconnecting our families and taking those family members to the temple we help make it so that these people are not forgotten.  I would like to discuss some of the ways that we can make deceased loved ones feel real. 

    One of the ways that I have found has been a simple change of semantics.  I no longer take names to the temple – I always take friends.  Now I know this sounds kind of hokey, and I will admit that when I started doing this, I felt really dumb about it.  But I have forced myself to always talk about these people as friends rather than names.  Whenever I’m ready to go to the temple I call up my mom and ask her if she has any of her friends that she wants me to take to the temple.  I will tell you that even if I felt dumb calling them friends, after doing the work to find these people, learn their stories and put them back together – my mom feels zero irony when I ask her for a friend. 

    Whenever I can I try to have my mom tell me a little bit about the person whose work I am doing.  At the very least I try to look at the card and see where they were from and how long they have been waiting for me to take them to the temple.  While I’m waiting I try to at least take a second to close my eyes and say hi to them and let them know that I’m excited to be with them that day.  My 13 year old son recently went to the temple after having my mom give him a little bit of information about the people he was doing work for.  He came back telling me how much better it made the experience when he’d done the work to find someone himself.

    If you think you can’t take a family name to the temple because you haven’t been doing the research yourself – you’re probably wrong! It has never been easier to find a friend from your own family to take to the temple. I was going to record a video to show you how to do it but I found this one that someone else had already taken the time to make. So I’ll let them do the explaining, but it’s less than a 2 minute video – and it literally doesn’t take any more time than this to get family ordinances on your phone. I have done it on the way to the temple and they have printed it for me when I arrived. I don’t think they could make it much easier!

    Ok, now that you have a name you need a time to go to the temple. I feel like we’re all busy and finding the time is one of the hardest parts of getting to the temple.  I’m going to put in a quick plug for Ward Temple Night, if you have it in your ward.  I was able to attend ward temple night just before giving this presentation and as I sat there I kept thinking “I really hope this is what heaven is like!”  I love attending the temple, I love the peace that is there and the chance to serve, and just being somewhere with no one climbing on me for a little while.  But attending with our ward was even better. 

    As I walked into the chapel I saw sisters from our ward who scooted over and made sure there was a place for me.  I was able to watch as a few other sisters walked in. Literally with each person who walked in that I knew my heart swelled with happiness to see them there in the temple.  It’s always great to go – but it’s even better when you can go and feel that love and connection with each other too.  As I felt the happiness of seeing members of our ward family in the temple it made me think of how it must feel to see friends and family reunited on the other side of the veil and how much more excited we will be to see each other there. 

    So, if you’re looking for a good time to go to the temple – it’s much more fun going with your ward.  If your ward doesn’t have a ward temple night, or the night they have doesn’t work for you – find a friend! My oldest boys are homeschooled and so are home during the days. They made a goal to go to the temple weekly and we scheduled it in our calendar. Then we decided to invite some other homeschooled kids in our neighborhood. We now take our whole van full of boys to the temple once a week! It’s wonderful for my boys to not only serve in the temple, but to get to do so with friends.

    If you haven’t gone to the temple recently it might feel intimidating to navigate the new scheduling process. I promise it’s not hard! Here’s another video that shows you the process. It’s only 71 seconds long, so there’s no excuse to skip over watching this if scheduling an appointment has been keeping you from getting to the temple!

    Ok, now we get to what I was *actually* asked to share, which is how to share memories on Family Search… which I never got to. The Temple & Family History committee wants me to give the other “half” of my presentation, but I’m going to have to put together a lot more to really make this into a full presentation like they’re looking for (so… stay tuned, that’s probably coming 😂) My mom has used the memories feature to upload pictures that she inherited from her parents of her ancestors. Using those pictures she’s been able to find people she didn’t know she needed to look for. There will be people in pictures from a wedding or other event and she will look and say “ok, I know who this is, and who that is… but this person looks like they are probably family – see they have the same nose and smile…. hmmm.” Then she knows to go piece together clues until she can find out who it is. If you find a family picture with 5 kids, but you only have 4 kids in the records, it looks like it’s time to do some research!

    Being able to read the memories about those who have come before is a powerful way to bring them to life and appreciate all that has gone into putting you where you are today. In Family Search you can now upload your memories, photos, records etc. in a place where they will be preserved and shared with others who connect with your family. Below is a quick video that explains how to do this.

    I hope you’ve caught a little bit of the vision of why family history is important to you. Maybe you’ve found some way that you can be a part of it.  I hope that you will go out feeling like these are real people and not just names on the page.  I bear my testimony that I know that that is true.  I know that the work that we do in temples is so important. We need our ancestors and they need us.  Life and salvation are a group project.  In D&C 128:15 we read “And now, my dearly beloved brethren and sisters, let me assure you that these are principles in relation to the dead and the living that cannot be lightly passed over, as pertaining to our salvation. For their salvation is necessary and essential to our salvation, as Paul says concerning the fathers—that they without us cannot be made perfect—neither can we without our dead be made perfect.”  I know our Heavenly Parents love us. They love those who have come before us and those who will come after us.  The Plan of Salvation is such a gift. It will not be complete until we have connected the whole human family.  What a privilege it is to be a part of this great work.  I leave these things with you in the name of Jesus Christ, amen.

    Resources

    If you would like to use the materials I put together for our 5th Sunday lesson you are welcome to do so. If you can I would recommend talking to people in your own ward who have their own experiences with tracking down lost family members. It’s much more powerful to share personal experiences and I promise you that you have similar experiences in your ward too. I aimed to have 4 different types of families represented –

    • A family that was super easy to find – clear records, everyone accounted for right off, no problems at all
    • A family where *most* of the family was easy to find, but someone was left out and discovered later
    • A family that was very difficult to find because they have no one left on earth that is their posterity
    • A family with some tricky connections that we could only find through DNA matching and comparing memories & photos

    You obviously don’t have to follow my family sets but I was aiming for people who could be found through totally different methodologies to highlight that there isn’t just one way to do genealogy. It would be really cool if you could get these examples from different people in the ward and highlight how the ancestors are connected to your own ward members. I was working on this presentation on my own but if you have a committee it could be fun to see different people’s research.

    However, you are of course welcome to just use the ones that I’ve already put together. Included below are the Power Point presentation that I used, the script that I put together for the “does anyone have my name” section, “temple names” to go with the participation section, and a blank set of “temple names” if you choose to put together your own script.

    Role Play Instructions

    If you want to do the “Does anyone have my name” section here are the steps that I would take to keep everything organized –

    1. If you are using your own family history experiences, I would recommend writing out your script and putting numbers in front of each person’s part and the gender of that person. This makes it easiest for keeping everyone in order and making it easy for casting to not have to read through the whole part to determine whether to give the part to a man or a woman.
    2. Once you’ve made your own script use the fillable PDF to create “temple names”. I’ve made the name cards with a spot for the name, birth date/place, and death date/place. At the bottom I have a spot where you can put the gender (again, this makes it a lot easier for casting when you get to teaching the lesson), and stage. The stage lets you know when to hand out the cards. I’ll explain my stages in a second.
    3. Whether you’re making your own script or using mine – print both the script and the temple names file that you are using. I would recommend having 2 scripts so that you have one on hand to follow along during the presentation
    4. Cut 1 copy of the script and the temple names into strips so that you can hand them out
    5. Before your lesson starts hand out the script strips and the temple names that either say “SELF” or “Stage: 1” – DO NOT HAND OUT STAGE 2 YET!
      • SELF: These temple names are for people who would have completed their own temple work in their lifetime. These should be handed to the same person who gets that part of the script (in my script this would be Thomas Smith & Ira Allen). They completed their work in this life so they don’t have to wait for someone else to come forward with their name
      • STAGE 1: These temple names are the people who are easy to find and their work is completed right away
      • STAGE 2: These temple names are the people who were difficult to find and won’t have their work completed until after you explain the work that went into finding them
    6. Choose someone who can be in the audience who can hand out the Stage 2 names during the presentation AFTER you’ve completed the script. It really helps to have someone who understands the whole presentation so they know when to hand these out

    Files to download

  • FREE General Conference Lesson Planner Tool

    FREE General Conference Lesson Planner Tool

    I love General Conference, they are two of my favorite weekends of the entire year. I’ve posted in the past some FHE lessons to help prepare kids for conference and posted my thoughts on conference many times. For awhile I tried running a General Conference book club, but it never took off like I’d hoped. I love that we now have the opportunity to basically have a book club type discussion in Relief Society every other week for these wonderful words from our prophet and leaders!

    For the past four years, I’ve had the privilege of serving as the Relief Society Secretary in our ward. Part of my responsibilities has included helping to coordinate lesson schedules for both the Relief Society and Elder’s Quorum. Our process started with a very basic spreadsheet, but through the years, it’s grown into something much more organized and collaborative. After spending so much time perfecting our system I’m excited to share it with you! Hopefully this General Conference lesson schedule spreadsheet can help you simplify the process of creating a lesson schedule for your ward too! (The spreadsheet is currently pre-populated with the talks from October 2024 conference)

    The Why Behind the Spreadsheet

    Our goal with creating this schedule is simple: we want to foster meaningful discussions in both the Relief Society and Elder’s Quorum by focusing on talks from General Conference. By coordinating our lessons, we give families the chance to talk about the same messages during the week—making it a shared experience between spouses, family members, and even friends. We also aim to ensure that our lesson topics reflect the needs of the ward while balancing seasonal themes (like gratitude near Thanksgiving or talks on the Resurrection around Easter).

    The Spreadsheet in Action

    The process actually begins before General Conference even happens. About a week before, we prepare a version of the spreadsheet that has no talks listed—just the basic structure. Both the Relief Society and Elder’s Quorum presidencies share this sheet to ensure collaboration. It would be easy to include the bishopric as well, but in our ward, that hasn’t been part of the process historically.

    During Conference weekend, one member of the presidency keeps the spreadsheet open and fills in the talks as they happen. We usually rely on KSL’s news blog to get the titles quickly—usually within 30 minutes of the talks being given. Once all the talks are in, the real magic begins.

    Each presidency member marks the talks they feel would be most valuable for discussion by simply placing an “X” in their assigned column. It’s a straightforward way for everyone to voice their opinions on which talks resonate most with the needs of the ward. We also start a discussion on our Relief Society’s GroupMe about the conference so that we can get feedback from the sisters in our ward in real time about what is resonating with them.

    Creating the Lesson Schedule

    After everyone has had time to vote, the presidencies meet together to plan the schedule. We start by listing out all the Sundays that need to be scheduled on the right-hand column of the spreadsheet. This usually starts with the fourth Sunday of the month following General Conference and going through to the second Sunday of the month after the next General Conference, and includes every second and fourth Sunday in between. We are sure to take note of any Sundays where lessons won’t be held due to Stake Conference, holidays like Christmas, or other special events.

    From there, we typically look at how the talks ranked based on the votes. The spreadsheet includes a formula that automatically takes all of the talks that received any votes and puts them on the schedule page in ranked order. This makes it SO much easier to sort through and find which talks that we all liked. The highest-ranked talks often go straight onto the schedule, though we leave room for discussion if someone feels strongly about a particular talk that didn’t get as many votes. Sometimes a talk might have been a favorite of everyone’s but it might not really be a good discussion talk, so we try to take those things into consideration.

    Another thing we consider is seasonal themes. For example, if there’s a talk on gratitude, we might aim to schedule it near Thanksgiving. We also try to link talks that share similar themes. If we find talks that complement each other well then we might assign two talks to a particular week to maximize conference coverage and create cohesive lessons.

    Sometimes there are talks that feel more appropriate for Relief Society or Elder’s Quorum individually. In those cases, we’ll schedule separate lessons, but we still try to coordinate so that most lessons are aligned.

    Once we’re happy with the schedule, we send it off to the bishop for approval. After he gives the green light, we input the schedule into Tools so that everyone in the ward has access. (If you don’t know how to input your schedule into Tools I’d recommend checking out this YouTube video that has a great walkthrough)

    Ready to Try It?

    If this process sounds like something that could help your ward or organization, you can copy our template Google sheet and customize it for your own use. It’s been such a helpful tool for us, and I hope it will make your lesson planning just a little bit easier and helps your presidency organize lessons in a way that fosters unity and meaningful discussion in your ward. If you have any questions or thoughts, I’d love to hear them in the comments! 😊

  • Family Home Evening Resources

    Family Home Evening Resources

    fhe_header

    I was asked to give a presentation at a Relief Society meeting about Family Home Evening to give some tips and tricks for making it meaningful and easy with young kids.  I thought I would share with you here what I shared with the sisters in my ward in case anyone from my ward didn’t get a chance to come to our activity, or if it would be helpful for other friends.  I know that I shared the experience in the first paragraph in this post too, but it was applicable here so I hope you’ll forgive the repeat.  The rest of the content should be new 🙂

    Before this most recent General Conference I was struggling with feelings of inadequacy as a mother and I wrote down a few questions that I was hoping to have answered during the conference.  This is one of the questions I wrote – “How can I best use my time with the many demands placed thereon? Freelance work, housekeeping, motherhood, callings, education, blogging, reading, socializing children etc. How can I keep from being completely overwhelmed and truly accomplish things? Or do I need to simply embrace the chaos?” In the second talk of the conference Sister Linda S. Reeves shared this experience –

    Some of you have heard me tell how overwhelmed my husband, Mel, and I felt as the parents of four young children. As we faced the challenges of parenting and keeping up with the demands of life, we were desperate for help. We prayed and pleaded to know what to do. The answer that came was clear: “It is OK if the house is a mess and the children are still in their pajamas and some responsibilities are left undone. The only things that really need to be accomplished in the home are daily scripture study and prayer and weekly family home evening.”

    A friend recently cautioned, “When you ask the sisters to read the scriptures and pray more, it stresses them out. They already feel like they have too much to do.”

    Brothers and sisters, because I know from my own experiences, and those of my husband, I must testify of the blessings of daily scripture study and prayer and weekly family home evening. These are the very practices that help take away stress, give direction to our lives, and add protection to our homes. Then, if pornography or other challenges do strike our families, we can petition the Lord for help and expect great guidance from the Spirit, knowing that we have done what our Father has asked us to do.

    Nothing could have been more applicable to my situation than that was.  I felt so much comfort that I only needed to really worry about those three simple things in order to be doing what is most important as a mother.  Family prayer, family scripture study and family home evening.  Of course, family home evening can sometimes be a bigger struggle than it might sound so I was asked to share some resources with you on how to make it easier.  So, first of all –

    K.I.S.S.: Keep It Simple Smarty!

    Family Home Evening was not instituted to stress you out. The point is to gather your family together and spend time together learning and loving one another.  Don’t make it harder than it needs to be!  Watch a Mormon Message together on YouTube, play a game, even just sit in the same room and let your kids do homework together.  Find what works for your family!

    I want to walk you through really quickly a “typical” FHE in the Hansen household –

    We gather the kids together.  Pull up a hymn on hymns.lds.org and sing along with it.  Pray.  Quick lesson picked from A Year of FHE. Another song. Prayer.  Oreos.  Bedtime.

    Oreos are the most important part of our family home evening, the boys don’t recognize it’s FHE without Oreos.  That’s it.  Sometimes I’ll put together my own lesson or we might do something else, but we have short attention spans.  The only part of that whole equation that requires much effort (beyond wrangling the kids of course) is picking a lesson from A Year of FHE, but then I usually just print it out and read it.

    I think the most important part of doing a lesson is picking something that really applies to your family’s current situation.  If you have a child struggling with obedience or tattling or something like that, then FHE is a great time to teach those principles.  But my mom warned me, don’t always pick just the things your kids are struggling with, or else they’ll just feel picked on and not want to come.  Lessons about the season (i.e. Christmas, Easter, St. Patrick’s Day) are great, or if you can include something that goes along with the month’s theme for primary it’s a good reinforcement.

    So here are some of the resources that I really like for putting together a family home evening:

    Church Website – The church has put together an awesome page that has links to the gospel art book, the Family Home Evening Resource book, videos, music and teaching helps.  It’s a great place to go to get started

    Mormon Messages– When you want a super easy lesson I definitely recommend just picking a Mormon Message and playing that for your kids and calling it good.  They’ll hold their attention well and have fantastic messages.  Easy, peasy. Done.

    A Year of FHE – This is my *favorite* FHE resource.  This lady put together FHE lessons and posted them to her blog every week for 3 years.  They are fantastic.  She has lessons on a lot of different topics.  Most weeks I will open up her blog and then scroll through the topics on the right side of the screen, pick one, print it and teach that.  She also has hymns selected to go with her lessons as well as a scripture.  The lessons are so well written out that you can generally just read what she’s written, show some pictures (if you want) and then bear your testimony where she indicates.  I can’t say enough about how much I love her website.

    Chocolate on My Cranium – If your kids really do well with visuals I highly recommend this website for her flannel board stories.  She took all of the flannel board stories from the Friend and colored them in so that you can just print them out, cut out the pieces and tell an interactive story.  If you live nearby, my sweet sister-in-law put together a binder with all of these lessons printed out and ironed all of the characters onto felt so that we had easy FHE lessons for a year.  It was one of the best Christmas presents anyone has ever given me.  We’ve gone through all of those lessons now though so if anyone would like to borrow any of the lessons feel free to come by and borrow them!

    Sugardoodle – We all love Sugardoodle.  They have so many cute ideas!  They’re getting ready to re-do their website in the next month, so I don’t know if this will remain how to get to their FHE lessons, but for now if you go to their home page, click on the “Other” tab there’s an option for “Family Home Evening Index”, and there are a ton of great FHE ideas there.

    My FHEs – Of course I have to throw in my shameless plug for my own website. I’ve put together a few different FHEs when I had something that I really wanted to teach my kids but couldn’t find *quite* the right lesson out on the web.  I’ve been trying to post them to my website so that other people can use them too.  I have lessons about being a missionary, a general conference preparation lesson (we do this one twice a year just before conference), saying sorry, and even an Angry Birds lesson about teaching kids how to control their emotions (that one gets requested often).  I’ve tried to follow the “A Year of FHE” format and include an opening and closing hymn that goes with the lesson, an easy to follow lesson outline and a predefined spot to bear your testimony.  There aren’t a lot of them, but I love to see people use them!

    My one piece of advice if you use the lessons that people post on their blogs is to just leave them a comment to say thank you for their time.  I know, at least that the lessons I put together, it usually takes me the better part of a day to complete them and it means a lot to me when someone will comment even a simple, “great lesson, thanks!”

    I promise that if you make Family Home Evening a part of your family’s weekly routine you will see the blessings in your family.  It will help draw you closer together and strengthen you and your kids against the difficult trials that might come against you.

  • Primary Secretary Resources: Part 4: Reminder Wristbands and Conducting Sheets

    Primary Secretary Resources: Part 4: Reminder Wristbands and Conducting Sheets

    Ok guys, not to toot my own horn or anything, but the resources that I’m handing off to you in this post are sheer and utter brilliance.  There.  I said it.  TOOT!

    But seriously, as I was preparing these files to share them I was actually sad that I won’t ever get to really use the finished product for myself.  I put a TON of work last year into making this whole process easy and seamless for this year and I’d forgotten just how easy I had made it.  So I hope this saves someone some work!

    So here it is.  I  put together reminder wristbands for opening exercises assignments and conducting sheets which you can pre-populate for the entire year by simply filling out one simple Excel sheet.  Easy peasy, lemon squeezy.  You don’t have to use both the wristbands and the conducting sheets, you can use just one or the other but since they both feed from the same spreadsheet I thought it would be easier to put them both together in one post.

    I went with wristbands for our reminder papers because it’s the easiest way to make sure that the reminders actually get home, especially for Jr. Primary kids.  I take our wristbands, cut them out and tape them to the kids wrists (although I don’t always make the Sr. Primary kids have them on their wrists, I think they probably feel too cool for that).  It has all the information their parents need, but I still send the follow-up email just in case.  The conducting sheets are pretty basic, I went with a half-sheet format because (as I’ve said before) I hate paper and don’t like to waste it.  I didn’t think we really needed a full sheet of paper every week that said most of the same things so I went pretty minimalistic.

    So here’s how to put these together.  Download the files below

    Start with the excel spreadsheet and assign out all of your talks, scriptures etc.  for the year.  I left all the weeks in but you will want to delete the rows that correspond to General Conference, your stake conference weeks and any other week that you wouldn’t have opening exercises (maybe your Primary program Sunday?)  Then start making your assignments.  You can fill this in manually, but there is an easier way.  If you have the MLS data from doing the birthday cards you can use that data to help populate this document.  My personal philosophy is that every child should be given the chance to have all of the different assignments.  I was a very shy child (ok, I’m still relatively shy actually) and I would have *never* volunteered to give a  talk or a scripture, or been likely to be picked out as someone who’d do a great job.  But because I was given the assignment to do these things at different points in my Primary career I got better at them.  I think that’s one of the great blessings of church membership is being given assignments we are not qualified for so that we can learn. Anyways, you can go through and manually select which kids you think should have each assignment each week, but I felt like Excel could have as much inspiration as I could, and do a better job making sure each kid got an assignment.  So here’s how I sorted out the assignments –

    1. Take your list of Jr. Primary kids (first name and last name) and paste into a blank excel document
    2. In the column after last name enter this into the next cell
      =RAND()
    3. Fill that formula down through all of the cells in that column (Hint: If you didn’t know this, you can copy a formula like that by clicking on the little black square at the bottom right corner of the cell and dragging it down through all of the cells you want the formula to be in – nifty huh?)
    4. Then click on the “Sort and Filter” option, select the option that says “Custom Sort”
    5. When the next dialog box pops up and gives you the option of which column to sort by select Column C

    That’s it!  You now have a randomly sorted list of your Jr. Primary kids.  What I did is take that list and divided it into three parts and pasted one part into the talk column, one into scripture and one into prayer.  Then at the points where I ran out I just took the kids who had a prayer in the first part of the year and put them in the talk column for the next part of the year, scriptures to prayers and talks to scriptures.  You can do that as many times as you need.  Then do the same for your Sr. Primary kids.  I tried to go through and make sure that I didn’t end up with siblings all having assignments during the same week, or giving all of the talks in a month or anything like that.  Also, make sure you look through your Sr. Primary assignments and take out the kids who are graduating after they’ve gone on to Young Men’s or Young Women’s, but this should give you a really good start.

    For the conducting and sharing time columns I’m going to assume that your ward does like my ward and has a rotation that doesn’t change too much from one month to the next.  To avoid having to type everyone’s names in 52 times just enter the first three or four weeks’ assignments (or whatever gets you through a full rotation), select the filled in boxes and then use that nifty black box again to fill that pattern in through the rest of the year!  Oh, and remember my hatred of paper?  I’ve formatted this file so that if you delete at least 5 rows (2 General Conference weeks, 2 Stake Conference weeks and 1 Primary Program practice), it will print one page for Jr Primary and one page for Sr. Primary – not bad for a full year’s schedule!

    Ok, so once you have all that filled out, save the file and you’re ready to move on to the wristbands. Note: even if you don’t want to use my wristbands and just want the conducting sheets read over this part, it has information you’ll probably want later.  Open up the wristbands file and connect to the excel file, just like we did with the birthday cards.  Be sure that you select the worksheet labeled “Assignments” and not the one labeled “Themes” – it should be the one selected by default anyways, but just in case.  At this point you’re pretty much set, except for one thing – when I made these wristbands I had my contact information for the parents printed on each wristband.  Since I don’t really want all of the parents from every ward that uses these to be calling me if Suzie won’t be there to give her talk, I replaced my information with dummy text that says “YOUR NAME AND INFO HERE”, so I should probably show you how to change that.  It’s actually really easy –

    1. Open the “Mailings” tab and de-select the option that says “Preview Results”
    2. You are now looking at the wristbands in template form.  Delete everything that says “YOUR NAME AND INFO HERE” and replace it with your information.  You can also change anything else on the wristbands that you’d like.  So long as you don’t delete any of the things that have the dashed line under them then you’ll still have the child’s name, the date of the assignment and the scripture/theme for that particular month.

    That was it, not so bad right?  So, on to the conducting sheets!  These should be so stinking easy at this point it’s ridiculous.  Open the Publisher file, connect to your excel file (again, make sure you select the sheet that is labeled “Assignments”) and you could be done!  The one thing that you’ll probably want to change though is that I put the start/end times for our singing/sharing times that you’ll want to change.  Use the same steps to get to the template as you did for the wristbands and you can change anything you would like 🙂

    I could have made everything a little more full featured by adding in a column where you could add graduations and baptisms, or pre-fill the musical numbers but I wanted to make things super easy and generic.  I figure you’re usually pretty aware of baptisms and graduations so they’re easy to pencil in when you’re getting ready to conduct.  We also just would pick our reverence child when we’d get to opening  exercises and just pick someone who was sitting nicely (or perhaps who might need some motivation to be sitting nicely 😉 ).  The musical numbers also weren’t assigned out at the beginning of the year, we always intended to just have people sign up, which is why the wristbands are just blank as well as that slot on the conducting sheets.  I’m sure everyone’s ward has a slightly different way of doing things but having a prayer/scripture/talk seemed to be pretty standard format so I stuck with those and I’ll let you figure out the rest.

    You should now be ready to put together everything you need on a weekly basis for a full year’s worth of primary!  What I did this last year was take the wristbands (for the following week) and paper clip them along with the birthday cards to the conducting sheets.  Then it was all put together on Sunday to just grab out of our basket and go.  It was a huge project to print and cut and paper clip all of these weekly packets, but it was SO worth it to have a stress-free Sunday each week!

    I have a few more resources that I need to finish putting together, but I’ll have to redesign them as they used some artwork that I was told I did NOT have permission to re-post, even with attribution.  So, it might take me a little while to get those up since I lack artistic talents.  I’m also thinking that if anyone is interested I could post PDF versions of all of these mail merge resources for people who are more comfortable just filling things in with a pen.  Until then, I hope you enjoy what I’ve posted so far!

  • Primary Secretary Resources: Part 3: Lesson Schedules

    Primary Secretary Resources: Part 3: Lesson Schedules

    This will be a pretty short post, but I wanted to share this.  I’m pretty picky about formatting and paper.  Mostly, I don’t believe in paper and like to avoid using it whenever possible.  But when I do actually print things out I like them to fit nicely on a single piece of paper.  So, last year I found these lesson schedules on Sugardoodle that were AWESOME.  The lady who had put them together had obviously spent a lot of time getting all the information in there.  However, they didn’t fit on a single page, so I spent considerable time to make it fit on a single page (like I told you – picky).  After taking all that effort to get those schedules formatted just so I wanted them to be usable for more than one year!  So, even though it was totally not going to benefit me personally, I spent a couple hours yesterday morning updating the documents with the dates for next year and the different manuals that are associated with them.  Obviously they will have to be adjusted to fit each ward’s individual schedule for stake conferences or primary program practices, but I think this should give you a good start.  Oh, and for the older classes the names of the lessons are linked to the actual lessons on LDS.org.  So if you want to just upload the schedule to a Google Document and share that with your teachers they can just click to get to the manual instead of having to look up the lessons.  Hopefully that’s helpful to someone.

    Enjoy!

  • Primary Secretary Resources: Part 2: Reminder Emails

    Primary Secretary Resources: Part 2: Reminder Emails

    Ok, so I’m sorry that this installment doesn’t have any cool downloads associated with it, but this is just a tip that I have for those running the Primary.  I hate calling people.  Like really, really, really hate it.  I always feel like I get flustered or call at the wrong time and they’re eating dinner or whatever.  I just don’t like doing it.  So I decided early on in my secretarial career that I would just email my weekly reminders out to people.  Personally, I like getting emails better too because I’m reading them at a time when I have access to my calendar and no one else is vying for my attention and it’s more likely to be remembered.

    So, since I was sending out 6 emails every week with the same information I found an easier way to do it.  I looked for a little while to see if I could find an automated emailing system that would just automatically blast out my reminder emails on Sunday night for me without my having to think about it, but no such luck.  What I did come up with was that I could create canned responses in GMail and just fill in the blanks each week.  At the beginning of each month I have to remember to replace the text in the scripture and the talk email with the new scripture and theme for the month, but that’s really not that big of a deal.  Instead of having to think of what to say each week I just pop in my canned responses and I can send out all 6 emails in about 5 minutes.

    I was going to include a tutorial for how to do this in GMail, but I decided to Google it and WikiHow had already put together a much better tutorial than I could, so I’ll just direct you there 🙂  But I will include below the canned responses that I have so that if you want to copy them verbatim and use them for yourself, or use them as a baseline for what you want to put in your emails you can feel free.  The only caution I have with using these is to make sure that if you’re emailing a single parent I always try to be careful about making sure that it doesn’t still say “Brother & Sister”.  Anyways, without further ado, here are my canned responses:


    Primary Talk

    Hi Brother & Sister ___,

    Just wanted to send you a quick reminder that _______ is assigned to give a talk in Primary on Sunday. This month’s theme is We Are to Thank God in All Things.

    Please help your child to be prepared to fulfill this assignment. We always welcome the parents of kids who are participating in sharing time to come and assist their child or be there to watch. If you won’t be there on Sunday or if you have any questions, please let me know!

    Thanks,
    -Brittny


    Primary Scripture

    Hi Brother & Sister ___,

    Just wanted to send you a quick reminder that ___ was assigned to give our scripture in Primary on Sunday. This month’s scripture is “He commanded them that . . . every day they should give thanks to the Lord their God” (Mosiah 18:23).. Your child does not need to have the scripture memorized, just be willing to read or repeat the scripture at the front of the room, and then lead the rest of the primary in reciting it together.

    Please help your child be prepared to fulfill this assignment. We always welcome the parents of kids who are participating in sharing time to come and assist their child or be there to watch. If you won’t be there on Sunday or if you have any questions, please let me know!

    Thanks,
    -Brittny Hansen
    801.851.0250


    Primary Prayer

    Hi Brother & Sister ___,

    Just wanted to send you a quick reminder that ___ is assigned to give our prayer in Primary on Sunday. Please help your child be prepared to fulfill this assignment. We always welcome the parents of kids who are participating in sharing time to come and assist their child or be there to watch. If you won’t be there on Sunday or if you have any questions, please let me know!

    Thanks,
    -Brittny


    So, that’s it! Hopefully someone finds this tip useful 🙂

  • Primary Secretary Resources: Part 1: Birthday Cards

    Primary Secretary Resources: Part 1: Birthday Cards

    On Sunday I was released as the secretary from our ward’s primary presidency.  It came as a bit of a surprise since we had thought we were going to be in for three years and were just getting geared up for our third year.  But apparently it was our time to go on to other things – hopefully it means that we were doing things so right and awesome that it was time for us to grow in other capacities and not that we were failing so miserably that they needed someone else to take over 😉

    Anyways, last year I started putting together all of my resources in a hope that I could make them so easy peasy to use this year that I didn’t hardly have to think about it.  So now I have a bunch of resources to make my life easy, and I don’t need them.  So I thought I would share them with all of you and hopefully make someone else’s life easy instead 🙂  We have a primary with over 120 kids (plus 45 kids in our nursery) so anything I could do to make things run super smoothly made a huge difference in our ward.

    One thing that I decided to do at the beginning of the year was to put together all of our birthday cards, conducting sheets and opening exercises assignments wristbands for the entire year and have them all set to go in our cabinet at church.  It was a LOT of work at the time (and of course, the week that I finally got everything finished was the week just before they split our ward – so I had to reshuffle a lot of things again 😛 ), but it helped SO much with keeping our primary running smoothly.  Plus, it made it so that if there was a week that I was out of town I wasn’t racing to get things finished at the beginning of the week and passed off to the right counselor – everything was already in place and they just had to pick up the little packet when they got to church on Sunday and there was no frazzle in my absence.

    So, I thought I would start by sharing the birthday cards that I made for our kids, and the spreadsheet that I used to generate them so that I wasn’t custom making 120+ cards.  We decided to give each of the kids a birthday coupon that they can show to the bishop to get a treat on the week of their birthday.  We thought this was a good way to let the kids get a chance to meet with the bishop for a brief second and let him wish them a happy birthday.  It just felt more meaningful than handing them a piece of candy during sharing time.    Here’s a preview of what it looks like –

    The imagery that I used is from Megan Turnidge‘s scrapbooking site.  I tried to contact her to secure definite permission for using it in this project, but I haven’t received a response.  Since I only used her free birthday scrapbook pack I feel like it’s probably ok since you could just as easily go download all the graphics yourself.  I don’t think I’m violating her terms of use, but I’m definitely on the border line so I would have liked to have had her explicit permission (I try to be very sensitive to how I use other people’s intellectual property).  Anyways,  I totally recommend that you check out her stuff, it’s super cute!  Also, if you want to use the same font I got it from Kevin & Amanda’s Fonts for Peas site and the font is called Pea Marcie (you will need to download that font if you want your card to look like mine, otherwise it will just use whatever default font Publisher feels like using). I started with a Microsoft Publisher document and made a little card with a space for the child’s name, birthdate, and whether they were in Jr or Sr Primary.  Then I put together an Excel spreadsheet with those fields and pasted in all the information from MLS.  Then I did a mail merge and voila!  One hundred and twenty birthday cards done without my having to fill in all the information manually.  It’s like magic!

    If you’d like to take advantage of these templates but don’t know how to do a mail merge, don’t be intimidated!  I’ve tried to make this as easy peasy as possible so that, even without much technical skills, you can quickly make these birthday cards too 🙂  I promise it’s not nearly so scary as it sounds or looks, I even tested the steps out on my much less technically inclined sister (thanks Taylor!) and she didn’t have any problems with it.  I hope you’ll give it a try!  Here are the steps you’ll need to take –

    1. Download this zipped file: Birthday Coupons.  There’s an Excel file and a Publisher file (if you’ve never used Publisher before still don’t be intimidated!  You really won’t need to know anything about Publisher for this to work.  If you’ve used Word or Powerpoint before it’s very similar, but you don’t even have to know that much about it to make this work for you)
    2. Open up the Excel file and enter in the data for your primary.

      If you want to pull this data from MLS it’s actually pretty simple.  I would include screen shots but since I’m no longer secretary I don’t have MLS access to get the screen shots.  But to the best of my memory this is what you’ll need to do.  Go into MLS and find the Custom Reports menu item.  Then make a new report that filters for just primary children, and include the fields first name, last name, birth month, birth day (not the full birthday just the number of the day the child was born), birth year.  I don’t think they have a field for Jr vs Sr Primary, but if they do then add that in as well.  Run that report and I would recommend sorting the report by birth day and then birth month (just click on those field titles in those order to order the report).  Under the File Menu there should be an option that says “Export” or “Export to CSV”.  If you export the report as a CSV and either email that to yourself or pop it on a USB drive, you can take that home and copy the information and paste it straight into your excel spreadsheet rather than having to type it out yourself, just don’t overwrite the header row or your first card won’t print out and you’ll be frustrated.

    3. Save the Excel file. Make sure you know where you’ve saved it – you can save it where it was before, just make sure you know where that is whether it’s on your Desktop or in the Downloads folder or wherever.  Then close the file.
    4. (Psst, the hardest part is now done!)
    5. Open up the Publisher file.
    6. A pop up box should appear like the one below asking if you want to reconnect the data source – click yesaccess data
    7. Another pop up box should appear saying that reconnecting the data source failed (don’t worry, that’s what’s supposed to happen!) and it should have two option buttons, click the one that says “Try to reconnect the data source” and click continue.reconnect
    8. A file finder box should pop up asking you to try and find the file.  Connect to the excel file that we saved in step 3.
    9. Another box should pop up asking you what sheet you want to use, it should already have sheet 1 selected, but if not select that and click “Ok”select_tables

    That should be it!  You should now have birthday cards for all the kids in the ward!   That wasn’t so scary was it?

    You can preview and edit the individual cards by going to the mailings tab at the top and scrolling through the recipients:

    Or print them by going to Print and selecting “Print All Records”.  Or you can enter in which records you want and print them out a few at a time (I did this when I did them the first time because I was always worried about printing 30 pages and having run out of one of the colors of ink after page 5 and having wasted 25 pages of cardstock!)

    Hopefully this saves someone lots and lots of time, or lots of people a little bit of time 🙂  If you want to change what I’ve done please feel free to do so!  The layout is all controlled on the master page, which keeps you from having to make changes to each individual card, and also keeps your file size a little smaller.  You can access to Master Page by going to View -> Master Page

    If anyone has a cute template that they would like to share I’d be happy to post it here, or you’re welcome to post it on your own website.  If you use my mail merging-ness I would appreciate a link back to this tutorial.  And let me know, I’d be happy to link to you as well!

    If I haven’t scared you off with the complexity of a mail merge then tune in for the rest of the series where I will provide downloads for door signs, binder covers, conducting sheets, and reminder wristbands!  As well as including all my other tips and tricks of the trade from my couple of years as a Primary Secretary 🙂