The other day one of my coworkers sent me a PDF document of a mail merge letter. There was over 700 unique letters on a white background.
The request: "please print 700 sheets of letter head, then print these 700 letters on the letterhead."
Well, being a problem solver by nature I figured there had to be a way to merge the letter on top of the letterhead PDF and print it all in one print job. Turns out...
I was right!
And this is how I did it...
Let me know in the comments below if this was helpful to you!
And, if you have questions about Acrobat Pro or any Microsoft Office programs let me know and I will get a tutorial up for you!
To be honest... This guy (JP Sears) used to really bug me.
I mean, he makes fun of a lot of particular life styles like Vegan's, Network Marketers and... Yup. LIFE COACHES.
But after watching this interview with Lewis Howes...
I have a whole new level of respect for this guy!
Watch the video below and you will see why...
It has been a long time in coming and I have had several people asking me for this tutorial.
Turns out, it is a lot more complicated than I could do in one video. So, I am doing it in several parts. I will update this post with each part as they come available.
Part 1: Setting up the document and using master pages
Part 2: Creating the WEEK VIEW master page
Part 3: Coming soon (Week of March 13, 2017)
If at any time you have questions or would like me to cover something in more detail just drop it in the comments below or comment on the video over on my YouTube Channel.
I recently got back in to creating tutorials for my YouTube channel. Today I posted this tutorial on how to use an Excel data file to do a mail merge in Microsoft Publisher. You can use this same method for many other types of data merge... Like:
Nothing is more frustrating than posting awesome content that can impact peoples lives and then... Crickets.
Yup, no comments, no likes, no shares... no response what-so-ever.
This was me just last week. But, in the last few days my Instagram account has been blowing up! And, all I did was use a few hashtags and change the way I created my posts.
So here is what I learned:
Ok. Let's break this down.
First and foremost you MUST create AWESOME content.
Awesome content is genuine, makes a difference in peoples lives, inspires and encourages others.
To create awesome content I use Adobe Spark. It is free, super easy to use and you don't have to have a degree to make something that looks good.
A few months ago I challenged myself to start creating a video every day and post it to my YouTube channel. For the most part these were just "follow me around" type videos with a few thoughts and personal development tips somewhere in the mix.
After a couple of months my baby girl was born and I had to take a little break. During that time I did a little review of what I had been creating and decided that I wanted to do something different. I don't think my life is interesting enough for people to want to "follow me around" for the day and I wanted to do something that would add value to peoples lives.
What I came up with is a bid different than most of the vlogs that I follow but I think I am a bit more on track with what I am trying to accomplish.
Check out my first episode and if you like the direction I have taken please subscribe to the channel and leave me a comment below.
In the Spring of 2014 I did something crazy. One of my business mentors challenged me to read a personal development book and even handed me a copy of Dale Carnegie's "How to Win Friends and Influence People."
So what did I do that was so crazy?
Well, I took him up on the challenge...
Needless to say, it was life changing for me. One good book led to another and in a few short weeks I was putting together my first ever personal development plan.
That plan included reading one chapter a day in a personal development book and through this challenge I happened upon an incredible wealth of knowledge and was introduced to some highly influential people in the industry that I now consider my mentors and coaches.
I have taken their courses, read their books and I stay connected to their social media channels on a daily basis. So let me introduce you to them (in no particular order) and why I think they are people that deserve your attention and follow!
Brendon Burchard (Live, Love, Matter)
I first learned about Brendon from a book launch he did a few years ago. The book was "The Charge: The Nine Human Drives That Make You Feel Alive."
After reading Brendon's book I began following him on YouTube and his social media channels. His videos and course launches taught me a ton about the industry and led me to the thought leaders and top marketing trainers online.
His book "The Motivation Manifesto" is to date one of the most life changing books I have ever read.
Brendon is a New York Times best seller, author, trainer, coach and a master marketer. If you want to grow in your own personal development and learn from one of the best in the industry you need to be following Brendon Burchard!
Jeff Walker (Product Launch Formula)
I learned about Jeff through one of Brendon's launches. See, Jeff is the creator of Product Launch Formula, the number one strategy for selling just about anything online and Brendon is one of Jeff's top students.
After reading Jeff's book, "Launch," I began following his blog and YouTube channel. Just about everything I know about email marketing I have learn through Jeff Walker. He is the master, the Guru, the Man, but he would never admit to it.
If you have a product, a service, or anything to promote or sell online you should check out Jeff Walker and Product Launch Formula.
Marie Forleo (B-School)
I don't know how I even found Marie Forleo. I think it was through a mastermind group on Facebook.
Marie teaches an online class she calls B-School (short for business school) and is geared to entrepreneurs young and old -- mostly women but there are a few brave men who take her classes -- who want to take their businesses online and not come across sleazy, scammy or spammy.
I love Marie's weekly videos on YouTube and her website and if you sign up for her email list she will send you a weekly email update with links to her new content. I have not taken any classes with her -- Yet -- but I have gotten a ton of value from her weekly videos and emails.
I first learned about Crystal Paine through Dave Ramsey. He was talking about her book "Say Goodbye to Survival Mode" and it sounded like it was right up my alley.
I downloaded the sample of her book on iBooks and when I got to the end of the sample I hit the purchase button because I just had to know more.
This book was nothing short of life changing for me because 1) I was living in survival mode and 2) I felt like Crystal was writing the book right to me. I know she meant for the book to speak to women living in survival mode but personally her targeting is all off. :) This book is for anyone who wants to break free of survival mode living! Go read it now!!! :D
I learned about Michael through a Facebook ad. Yes. You read that right.
You know how it goes, as soon as Facebook figures out that you are interested in something it starts showing you related ads.
For me it was all the page likes and comments about personal development and building a platform to share my message. And, that is exactly what Michael is great at.
His book ad for "Platform: how to get noticed in a noisy world" popped up in my news feed and quickly landed on my reading list.
Michael's blog has had a huge part in my journey and the emails, launches, and leadership summit he did in 2015 have been stellar.
I have met, read, and taken courses with many other coaches and trainers in the past two years so this list could be much bigger. However, today I just wanted to share my top 5!
How about you? Who are your biggest influences right now?
Drop down in the comments below and share your favorite authors, trainers, mentors and coaches!
About the Author
I am a Full-Time Enterprise Support Technician at Evangel University and Part-Time Holistic Life Coach and Online Entrepreneur.